Archive for December 9th, 2011

MySQL Socket Error in phpMyAdmin

While accessing phpMyAdmin, you may get the following error. #2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured) This is due to the missing socket file in the location /tmp. The socket path which is specified in the phpMyAdmin configuration file is /tmp/mysql.sock. $ vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/ cfg[‘Server’][‘socket’]    […]

phpMyAdmin Error: Cannot start session without errors

If we get an error given below while accessing phpMyAdmin. Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. Inference By looking into the error, we expect that there can be error in writing session files. Either the owner do not have […]

PhpMyAdmin error – “The local MySQL server’s socket is not correctly configured”

First of all check whether MySQL is running or not using the following command: ps uax | grep mysql If MySQL is running then, find the location of the socket file created by MySQL. Most probably it will be at “/var/lib/mysql/mysql.sock“. But when PHP communicates with MySQL server in the same host, it uses a […]

Warning message in PhpMyAdmin after upgrading MySQL version to 5 In cPanel server.

In cPanel server after upgrading MySQL version to 5, PhpMyAdmin shows a warning message as given below Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.45 CPanel’s internal PHP is not compiled with MySQL 5. That is why you are facing this issue. In order to fix this, perform the following […]

Using encrypted passwords in mysql

It is a good idea to store passwords in encrypted forms in mysql databases. Function MD5() is a good option to encrypt the passwords. You can use this function in the mysql codes to encrypt the passwords. There may be some situations that we may need to reset the password stored in encrypted form, then […]

InnoDB: Operating system error number 13 in a file operation.

You might come across with following error while starting mysql. ———————————– 071027 7:43:13 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: ‘open’. InnoDB: Cannot continue operation. 071027 07:43:13 mysqld ended […]

Disk full error in MySQL logs

Disk full error in MySQL logs. ——————- 81218 14:53:40 [ERROR] /usr/libexec/mysqld: Disk is full writing ‘/tmp/#sql_5047_21.MYI’ (Errcode: 28). Waiting for someone to free space… Retry in 60 secs ——————- This occurs when /tmp runs out of space. Check the size of /tmp partition. It should be atleast 3 times as the size of largest table. […]

Unable to start Mysql after its Downgrade

This issue usually happens after the mysql downgrade from version 5 to 4. The error will be like: ERROR 2002: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) If you check further, you can see charset issue related with mysql (charset #83) in the /var/lib/mysql/HOSTNAME.err file. You can fix this issue by appending the below line in […]

How to change the storage engine to InnoDB

1.Edit the /etc/my.cnf file and look for this line: skip-innodb and comment it out: #skip-innodb 2.Add the following entry in the /etc/my.cnf file default-storage_engine = InnoDB 3. Save the file, and restart mysql /etc/rc.d/init.d/mysqld restart 4. You can use the following command to check the “storage engine” used in the server. mysqladmin variables | grep storage_engine […]

Timeout error occurred when trying to start MySQL Daemon.

If you are getting the following error while trying to start MySQL service; [root@ ~]# /etc/init.d/mysqld restart Stopping MySQL:                                            [FAILED] Timeout error occurred trying to start MySQL Daemon. Starting MySQL:                                            [FAILED] [root@ ~]# And if you are getting the following error in the MySQL log; [root@ ~]# tail -f /var/log/mysqld.log 080503 14:30:28 [ERROR] Can’t start […]