MySQL 4.0.14 Access Denied remotely !

[kmthien]

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

 

[HJB417]

when you add users to the database, you can specify the domain names the account can be accessed from..
e.x.:
root@localhost
root@192.1.3.130
root@yourschool.edu

read this for more info

 

[kt]

Or use "%" to allow login from any address.

 

[kmthien]

Hi guys,

I have created a new database user but when I tried to login to mysql DB using this user, I can select any database. How can I prevent this user from select any database instead of just its own database ? Thanks in advance !

kmthien

 

[HJB417]

read the mysql documentation at the link above for the parameters of the GRANT command. You can specify what database(s), and I think datatable(s), a user has access to.