I am recieving this error:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I am receiving this error when attempt to connect to MySQL like so:
$connection = @ mysql_pconnect($hostName, $username, $password) or die(mysql_error());
$db = mysql_select_db($databaseName, $connection) or die(mysql_error());
Rest assured I am using the correct login information.
I have recently upgraded to MySQL 4.1 and have had no trouble with any of my current users, whom I ported over from the prev. version, connecting to MySQL in this same manor above.
BUT, this is the first user I have created myself (my host administration utilities used to be able to create them for me, but now with the new upgrade the utility ceases to work properly... which was fine with me cause I insisted that I would be able to use MySQL old school style).
Well, I guess I get what I deserve... errors! 🙂
So, now i come to you asking what did i do wrong.
Here is how i created the new User: (exactly how the manual said.)
-I root'd into my shell, and logged in as root to mysql.
i then (only using my own data):
mysql> INSERT INTO user (Host,User,Password)
VALUES('localhost','custom',PASSWORD('obscure'));
mysql> INSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,
Update_priv,Delete_priv,Create_priv,Drop_priv)
VALUES('localhost','customer','custom',
'Y','Y','Y','Y','Y','Y');
mysql> FLUSH PRIVILEGES;
Note: After each INSERT I was prompted that 1 row was effected. After the Flush, 0 rows were effected.
Also, through my Shell I have been able to log in with the user!
But, I have NOT been able to login using phpMyAdmin.
hence, the reason for my earlier post in the general section regarding my phpMyAdmin issue.
So, what must I do to create new users correctly, and what can i do to fix my current new user problem?
Sorry if i talked to much, just wanted to fully explain my problem!
Thank-you,
phence
