Board index Linux Mysql

Moderator: chandranjoy

Mysql - Issues

Postby chandranjoy » Wed Mar 10, 2010 4:59 pm

Error:
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 :)
chandranjoy
Site Admin
 
Posts: 283
Joined: Fri Oct 23, 2009 11:19 pm

Return to Mysql

Who is online

Users browsing this forum: No registered users and 1 guest


cron