Fahid Posted January 16, 2006 Share Posted January 16, 2006 Hello All ! 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 Apache 2.54 PHP 4.4.0 MySQL 4.1.7-nt 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 ? Link to comment https://forums.phpfreaks.com/topic/3209-mysql-problem/ Share on other sites More sharing options...
fenway Posted January 17, 2006 Share Posted January 17, 2006 Check out [a href=\"http://dev.mysql.com/doc/mysql/en/old-client.html\" target=\"_blank\"]this refman page[/a] for more details. Link to comment https://forums.phpfreaks.com/topic/3209-mysql-problem/#findComment-10943 Share on other sites More sharing options...
Fahid Posted January 18, 2006 Author Share Posted January 18, 2006 Thanks Guru ( fenway ) ! Link to comment https://forums.phpfreaks.com/topic/3209-mysql-problem/#findComment-10969 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.