I'm trying to set up other users besides root and mysql. but I keep getting this error:
I installed mysql with marc's entropy binary. after installing I added users to the grant table like this:
mysql> GRANT ALL PRIVILEGES ON *.* TO user@localhost \
-> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO user@"%" \
-> IDENTIFIED BY 'password' WITH GRANT OPTION;
I can login to mysql from the command line or ssh using : mysql -u user -p.
and I can also connect to mysql using a gui mysql frontend like mysqladministrator or yourSQL. But when i try to connect from my php script it give me that error.
why is mysql giving my this error saying that my client doesn't support this authentication protocal? this is my php connection script:
I can connect with this same script using user: mysql with no password
| Quote: |
| Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in |
I installed mysql with marc's entropy binary. after installing I added users to the grant table like this:
mysql> GRANT ALL PRIVILEGES ON *.* TO user@localhost \
-> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO user@"%" \
-> IDENTIFIED BY 'password' WITH GRANT OPTION;
I can login to mysql from the command line or ssh using : mysql -u user -p.
and I can also connect to mysql using a gui mysql frontend like mysqladministrator or yourSQL. But when i try to connect from my php script it give me that error.
why is mysql giving my this error saying that my client doesn't support this authentication protocal? this is my php connection script:
| Code: |
| <?php
$host="localhost"; $user="user"; $password="password"; $db="my_db"; $conn=mysql_connect($host,$user,$password) or die ("error connecting to mysql:".mysql_error()); $select_db = mysql_select_db($db,$conn) or die (mysql_error()); ?> |
I can connect with this same script using user: mysql with no password
