MySQL error 1045 (28000): Access denied for user 'root' @ 'local

Ubuntu9.10 install MySQL

Sudo apt-Get install mysql-Server

The installation is successful, and the password and OK are required at the end of the installation.

Mysql-u root-P

Enter the password.

An error occurred!
Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: yse)

Leave the password Blank

Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: No)

Change the password!

#/Etc/init. d/MySQL stop
# Mysqld_safe -- user = MySQL -- skip-grant-tables -- skip-Networking &
# Mysql-u root MySQL
Mysql> Update user SET Password = PASSWORD ('My password ') where user = 'root ';
Mysql> flush privileges;
Mysql> quit

#/Etc/init. d/MySQL restart
# Mysql-u root-P
Enter password:

Mysql>

Solution.

Ubuntu9.10 install MySQL

Sudo apt-Get install mysql-Server

The installation is successful, and the password and OK are required at the end of the installation.

Mysql-u root-P

Enter the password.

An error occurred!
Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: yse)

Leave the password Blank

Error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: No)

Change the password!

#/Etc/init. d/MySQL stop
# Mysqld_safe -- user = MySQL -- skip-grant-tables -- skip-Networking &
# Mysql-u root MySQL
Mysql> Update user SET Password = PASSWORD ('My password ') where user = 'root ';
Mysql> flush privileges;
Mysql> quit

#/Etc/init. d/MySQL restart
# Mysql-u root-P
Enter password:

Mysql>

Solution.