Jump to content


This topic is now archived and is closed to further replies.


MySQL problem

Recommended Posts

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.

$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 ?

Share this post

Link to post
Share on other sites

Check out [a href=\"http://dev.mysql.com/doc/mysql/en/old-client.html\" target=\"_blank\"]this refman page[/a] for more details.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.