mysql

(XID xxxxxx) Database Error: There is no such grant defined for user “mysql_user” on host “host.name.com”

  2017-01-24
  Add Comment
Trying to give a user permissions for a database within cpanel and getting the error: (XID xxxxxx) Database Error: There is no such grant defined for user [...]

There was a problem adding the user: (XID xxxxxx) Database Error: Can’t find any matching row in the user table

  2016-11-23
  Add Comment
Trying to add a user to a database within cpanel but getting errors: There was a problem adding the user: (XID xxxxxx) Database Error: Can't find any [...]

Mysql::initcache() failed: The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely

  2016-05-26
  Add Comment
If you are getting this error in cpanel when trying to look at the mysql databases: Mysql::initcache() failed: The adminbin “cpmysql” in the [...]

Mysql SUPER privileges

  2016-05-25
  Add Comment
1227. "Access Denied; you need(at least one of) the SUPER privileges for this operation. If you get this error in mysql, you just need to give the user [...]

Table Type Doesn’t Support FULLTEXT Indexes

  2015-06-08
  Add Comment
#1214 - The used table type doesn't support FULLTEXT indexes ERROR 1214 (HY000) at line 29: The used table type doesn't support FULLTEXT [...]

Mysql Errors

  2015-06-04
  Add Comment
I just wanted to make a list of some mysql related errors and hopefully some simple ways to solve them. Mysql usually will show an error on the page when [...]

Disable Mysql Strict Mode in CentOS/WHM/cPanel

  2015-06-04
  Add Comment
To disable mysql strict mode in mysql (especially version 5.6) on a cPanel server, you would want to first ssh in to the server then before you do anything [...]