I have a problem with MySQL.
I am not very familiar with MySQL, only use MySQL databases for my PHP scripts.
recently I have installed
on my own PC( Windows XP-sp2 ) for faster development process.
I configured MySQL's root with no password.
I installed phpmyadmin with root user, and It's working OK.
Later on I installed MySQL Administrator (mysql server administration software by MySQL).
I created a clone of root user with name user and password 0000, through MySQL Administrator.
By clone I mean All privileges of root are available to user.
only difference is that root has no password, but user does.
After restarting MySQL server I executed following script.
<?php $link = mysql_connect('localhost', 'user', '0000') or die(mysql_error()); echo 'OK'; ?>and the result was as following:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
What's wrong ?
I am really in trouble.
Someone please tell me how to sort it ?
How to create new user ?
How to set privileges for them ?
Why I can't connect to MySQL server, when trying to connect with username, that has a password ?