Jump to content

Archived

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

Fahid

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.

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

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.