[mpancha]

So I'm running Tiger, I have apache on, and PHP enabled. PHP works as per the nifty phpinfo(); test php file.

The problem I'm having is I am trying to run a test php file to test my mysql setup (from this site: http://www.macdevcenter.com/pub/a/ma..._5.html?page=3)

bsically if the script works, it'll say so. The only change I made was to enter the root password I entered.

The problem I'm running into is I'm getting this error:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /Users/mpancha/Sites/dbtest.php on line 5

Warning: mysql_select_db(): Access denied for user 'mpancha'@'localhost' (using password: NO) in /Users/mpancha/Sites/dbtest.php on line 9

Warning: mysql_select_db(): A link to the server could not be established in /Users/mpancha/Sites/dbtest.php on line 9

Access denied for user 'mpancha'@'localhost' (using password: NO)

What is confusing me, is the php script doesn't use mpancha@localhost as the login, it uses root@locahost. "mpancha" is my user account on my ibook.

I'm completely lost on this, any help would be appreciated. Thanks in advance.

[jay3ld]

http://dev.mysql.com/doc/mysql/en/old-client.html

the Client does not support authentication protocol and password issue may be the same... i forgot what i did but i had this same error. i couldnt use any password logins because of the hashing errors.

https://sourceforge.net/forum/messag...msg_id=2989799
http://sourceforge.net/forum/forum.p...forum_id=72909


if you continue to have trouble i would ask mysql support site.
http://www.mysql.com/support/


if i remember how i got mine fixed i will tell you but ii am comming up blank and looking though the posts at sourceforge i cant find mine....

-Edit-
i think i remember
using terminal type: mysql
hit return and you should get the error.
Then type; SELECT Host, User, Password FROM mysql.user WHERE LENGTH(Password) > 16
hit return... it will be returning users including your root most likely

then just do either of these in terminal while your still using the mysql.
SET PASSWORD FOR 'SoMeUsEr'@'SoMeHoSt' = OLD_PASSWORD('NeWpWd');
or
UPDATE mysql.user SET Password = OLD_PASSWORD('NeWpWd') WHERE Host = 'SoMeHoSt' AND User = 'SoMeUsEr'; FLUSH PRIVILEGES;


Replace: NeWpWd = with your new password
Replace: SoMeUsEr = with your user name
Replace: SoMeHoSt = with your host. since its on the same machine its localhost

[moodymonster]

You may also find some useful stuff here:

http://www.entropy.ch/software/macosx/

[mpancha]

Jay3ld & Moodymonster, thanks for your help. I'll give it a try tonight!