SUSE error has occurred access denied for user & #39;& #39;@& #39;localhost& #39; to&

Long time no practical MySQL, last due to install the BANQ forum system. When I went in with MySQL administrator I actually prompted MySQL error number 1045 Access denied for user ' admin ' @ ' localhost ' (using Password:yes) It seems that the password is right, username is wrong. Finally found himself actually made a few mistakes, username should be root, alas!

Find someone else's information at the same time. Sent up together. For next use.

Access denied for user "@ ' localhost ' to database

I installed MySQL 5.0 in Yast2 with my own CD under SuSE Linux 10.2, and after installing MySQL in the terminal, MySQL

Successfully started. Exit, and then enter mysqladmin-u root password XXXXX. Error occurred: Mysqladmin:connect to server at ' localhost ' failed

Error: ' Access denied for user ' root ' @ ' localhost ' (using Password:no) '

If you enter MySQL first, enter use MySQL after successful startup, such as the following error: Access denied for user "@ ' localhost ' to database ' MySQL '

And also. Lose MySQL can, lose mysql-u root is wrong:

Access denied for user ' root ' @ ' localhost ' (using password:no).

The reason is:

An error occurred while updating Rootpassword yesterday

Update user Set password = ' 123456 ' where user = ' root '//This is wrong, the password is not actually 123456

Should be update user set password = password (' 123456 ') where user = "root"

Detailed operation steps:

Turn off MySQL:

# Service Mysqld Stop

And then:

# Mysqld_safe--skip-grant-tables

Start MySQL:

# service Mysqld Start

Mysql-u Root

mysql> use MySQL

mysql> UPDATE user SET password=password (' xxx ') WHERE user= ' root ';

mysql> flush Privileges;

Mysql>\q

That ' s it. I hope those above could do a little favor for you!

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

SUSE error has occurred access denied for user & #39;& #39;@& #39;localhost& #39; to&