Jump to content


Photo

MySQL problem


  • Please log in to reply
2 replies to this topic

#1 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 16 January 2006 - 11:57 PM

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 ?
Back Again...

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 17 January 2006 - 12:14 AM

Check out [a href=\"http://dev.mysql.com/doc/mysql/en/old-client.html\" target=\"_blank\"]this refman page[/a] for more details.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 Fahid

Fahid
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationPakistan

Posted 18 January 2006 - 03:28 AM

Thanks Guru ( fenway ) !
Back Again...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users