Ladies & Gentlement,

   I have installed mysql database in a server (192.1.3.139) running Windows2K Server. The reason that I didn't install in Linux because I failed so many times until I gave up.

   I entered the following commands:

mysql> use mysql;
mysql> delete from user where host='localhost' and user='';
mysql> quit;

c:\mysql\bin> mysqladmin reload
c:\mysql\bin> mysqladmin -u root password 123456

Then I tried to access mysql database on the other machine by entering below commands

c:\mysql\bin> mysql -h 192.1.3.139 -u root -p
Enter password : ******

I got the following error:

ERROR 1045: Access denied for user: 'root@BLACKELF' (Using password: YES)

Pls help !! Thanks in adv !!



c:\mysql\bin> mysql -h 192.1.3.

Well, every time you modify the mysql system tables (users, etc.) you need to reload the grant tables for the settings to take effect. Restart MySQL and let us know if you're still having problems.


Take care,

Nik
http://www.bigaction.org/