ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0
Fix:
Add the following line into '/etc/my.cnf' under the section "[mysqld]"
old-passwords = off
Then restart the mysql,
/etc/init.d/mysqld restart
Error:
Client does not support authentication protocol requested by server.
Fix:
Execute the following command from mysql prompt.
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
mysql> FLUSH PRIVILEGES;
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
That's all folks
Site is showing 'database not connected' error and apache is spitting the following error.
How to Fix for this issue:
[error] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/miyimco/public_html/dev/includes/functions/database.php on line 19
Add the following line into '/etc/my.cnf'
old-passwords = 1
Restart the mysql,
/etc/init.d/mysqld restart
Enter into mysql
mysql> UPDATE mysql.user SET password=OLD_PASSWORD('GIVE_PASSWORD_HERE') WHERE user='USERNAME_HERE' AND host='localhost';
mysql> flush privileges;
Cheers