I am connecting from a page on one server to a database on a different server and got this error: FATAL ERROR: Connection to database server failed.Client does not support authentication protocol requested by server; consider upgrading MySQL client Anyone know how to fix it?
What do you have in your config file (edit out all private info such as pasword etc before posting it)?
On my server i just use localhost..but on the other server i cant use localhost because the databse isnt on that server...so i contacted my dedicated server provider and they said just to use server.mydomain.com when i did that it said server unknown or something like that then i did just mydomain.com and thats when i got that error message. When i change the password it gives me cannot connect because of the password, when the password is good it gives me that: Client does not support authentication protocol requested by server; consider upgrading MySQL client so it looks like it did connect but then authentication protocol is not supported...i have no clue what that means.
That means the server doesn't accept remote connections. You may need to set this to work inside your cpanel.
The same thing happened with my local testing server. I just reset my password to pre4.1 style and then it started working fine. For more examples - http://dev.mysql.com/doc/refman/4.1/en/old-client.html
The server that contains mysql needs to be configured to allow remote access. If you have cPanel control panel, you can do this in the MySQL section
Even setting your connection via cpanel, some hosting providers disallow remote connections from the server configuration so you will not succeed if it's set this way. In my experience the only shared hosting that supports this is Netfirms, from which panel you can allow or deny such connection.
The authentication protocol was changed in 4.1. Probably the easiest ( and possibly the only if you are not an admin on the server) solution is to upgrade your client to 4.1 or newer.
You will have to upgrade your mysql client or change your mysql password mode to oldpasswords...On command line run the following: 1. mysql -u root -p next you will have to enter your mysql root password next mysql> UPDATE mysql.user SET password=OLD_PASSWORD('your_password') WHERE user='your_mysql_username' AND host='host'; (hit return)