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