MySQL Archives -


Plesk MySQL and admin password

Upto Plesk version 9.x both admin and MySQL admin password are same. And it is stored in the file /etc/psa/.psa.shadow. You can simply cat the file to get the password cat /etc/psa/.psa.shadow Since Plesk 10.x only the MySQL admin password is stored in /etc/psa/.psa.shadow. To get the plesk admin interface password you should ssh to […]

mysql_connect() [function.mysql-connect]: Too many connections

You will get the error mysql_connect() [function.mysql-connect]: Too many connections due to the connection limit set on MySQL Server. This can be due to either of the two settings max_connections or max_user_connections . If the value is set to zero then that means it’s unlimited. You can check the current values using below command root@host […]

ERROR 2006 (HY000): MySQL server has gone away

ERROR: Sometimes you may get below error while importing a sql file ERROR 2006 (HY000): MySQL server has gone away REASON: This generally happens when you are restoring a very large database you haven’t set enough max_allowed_packet in the mysql server configuration. SOLUTION: Edit /etc/my.cnf and set max_allowed_packet to a high value and restart the […]

How to check if InnoDB engine is enabled on your cPanel server

To check the status of the InnoDB engine. You should first SSH to the server. Then go into MySQL prompt using the “mysql” command. Then run the MySQL query SHOW VARIABLES LIKE ‘have_innodb'; It will show the status of the InnoDB engine. If the value is set to “YES” then that mean the InnoDB engine […]