Upgrade MySQL server

I recently had to upgrade a mysql server from version 4.0.x to 5.0.x and ran into the following issues.

#1 Error Client does not support authentication protocol

This was due to the fact that the mysql client was older than 4.1 and the server was upgraded to 5.0.x and according to the MySQL documentation: MySQL 5.0 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients.

You can either upgrade the mysql client to a version 4.1 or greater or run the following for the user name that needs to connect with a mysql client version of 4.0 or less.

mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


In addition, you may need to edit your mysql server 
to accept old password. You can do this in the /etc/my.cnf 
file by adding old-password = 1 to the [mysqld] section and
restarting mysql.

#2 DNS issues. I was getting an error that the username couldn't
connect from a particular hostname.  To take DNS queries out of the
connection, you can add skip-name-resolution to the [mysqld] section
of your /etc/my.cnf file and this will tell mysql server daemon to 
not perform a DNS lookup of the calling IP address. Restart mysql.
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s