by admin | Aug 1, 2020 | MySQL
Do you get the following error when trying to create user and grant privileges ? The database error when creating : ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...
by admin | Jul 15, 2018 | aws, MySQL
The Amazon RDS ( AWS RDS ) – Managed relational database service from aws is a real blessing these days. Since its managed by aws, you don’t have to worry about the patching / administration / backups / restore aspects of it. All you need to do is...
by admin | Apr 28, 2016 | cPanel/WHM, MySQL
You might want to install the the MySQL native driver for PHP (MySQLnd) over the custom MySQL driver provided with the default EasyApache. To enable this manually, you will need to edit the file : /var/cpanel/easy/apache/rawopts/all_php5 and make sure the following...
by admin | Oct 23, 2015 | cPanel/WHM, MySQL
For someone who upgraded MySQL from versions 5.0.x to something like 5.5.x, this error might be a familiar one : “Cannot load from mysql.proc. The table is probably corrupted” The database activities would not work as expected and hence you will need to...
by admin | May 11, 2015 | cPanel/WHM, MySQL
When trying to view the databases from the cPanel interface of an account, you might end up with no values at all. However, if you check the backend, you can find that these database folders consumes space. To fix this issue, SSH to the server and open the file :...
by admin | Aug 31, 2014 | MySQL
When trying to restart the MySQL service, do you happen to find the following error in the logs ? /usr/sbin/mysqld: Can’t create/write to file ‘/tmp/xx’ (Errcode: 122) date InnoDB: Error: unable to create temporary file; errno: 122 date [ERROR]...
