MySQL problem?

Question

PLz tell me how to connect my Website using MySQL...i installed it n created a DataBase with "root" user n password....now d problem is dat i cant able to connect dis Db to my Web......

The error generated is.........

"Client does not support authentication protocol requested by server..."

Now wht shud i do ??? If u know any Source den plz Help me wid ur Knowledge....

Thank U

Answer 1

Hello, as a MySQL pdpc supporter, the solution is clearly not "You need to use a provider that supports MySQL. " as the previous answer has stated.

You are clearly using an old client to connect. It is "CLEAR" that your web module which supports MySQL is using an old driver.

If you are using PHP, In older versions of PHP, the mysql extension does not support the authentication protocol in MySQL 4.1.1 and higher. I belive you are using the MySQL extension and your using the MySQL 5 (which I assume) Please upgrade your extension for your host and use the "mysqli" extension instead.

Let me simplify this, since it is getting too complicated :)
You are using a library in any dynamic language (PHP/ASP/JSP/RUBY/etc) which is NOT Compatible to your existing MySQL Version (4.0) or newer (4.1.1 or +)
MySQL 5 uses new hash algorithms for authentication so it needs the newest driver for connection, if your current application cannot go through this change, you can do what is suggested in the link below.

If you need any more help, I could help you at this matter (it is pretty straight forward) You were stuck in this loop which conflicts in drivers :p Easily fixed.

Message me if anything goes wrong.

Good Luck

Answer 2

You need to use a provider that supports MySQL.

You can read this tutorial as well:
http://www.webmonkey.com/programming/php/tutorials/tutorial4.html