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 ? Quote 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. Quote 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 ) ! Quote Link to comment https://forums.phpfreaks.com/topic/3209-mysql-problem/#findComment-10969 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.