Jump to content

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 ?

Link to comment
https://forums.phpfreaks.com/topic/3209-mysql-problem/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.