The mysql access control is drinving me crazy. 

I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4)
After the installation of mysql  I run the mysql_install_db script

I could change the passwords for root so I reset the GRANT table using 
../safe_mysqld --skip-grant-tables

and than I set the passwords manually using
myql -u root mysql
mysql> INSERT INTO user (Host,User,Password)
            VALUES(''%','root',PASSWORD('abc'));
mysql> INSERT INTO user (Host,User,Password)
            VALUES('localhost','root',PASSWORD('abc'));
mysql> FLUSH PRIVILEGES;

I can set the password for e.g root (atleast I don't get any error message) using 
mysqladmin -h localhost -u root -p password 'def'



but when I try to access the DB using

mysql -h localhost -u root -p mysql

(depending on the password) I get the following error message:

ERROR 1044: Access denied for user: 'root@localhost' to database 'mysql' (if I use abc 
as password)

or

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) (if I use 
def as password)

Any suggestion or idea would be appreciated. Thanks!

Joachim Hoernle

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to