Mysql1045accessdeniedforuser solution _ MySQL-mysql tutorial

Mysql1045accessdeniedforuser solution tip: 1045 access denied for user 'root' @ 'localhost' using password yes
Method 1:
#/Etc/init. d/mysql stop
# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &
# Mysql-u root mysql
Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';
Mysql> flush privileges;
Mysql> quit
#/Etc/init. d/mysql restart
# Mysql-uroot-p
Enter password: <输入新设的密码newpassword>
Mysql>
Method 2:
Directly use the username and password provided in the [client] section of the/etc/mysql/debian. cnf file:
# Mysql-udebian-sys-maint-p
Enter password: <输入[client]节的密码>
Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';
Mysql> flush privileges;
Mysql> quit
# Mysql-uroot-p
Enter password: <输入新设的密码newpassword>
Mysql>

Content from: www.bitsCN.com

Another method
Windows:

1. log on to the system as an administrator, stop the mysql service, or end the mysqld-nt process.
2. go to the command line and go to the mysql installation directory. assume that the installation directory is d:/mysql/. run CMD to enter the command line.
3. run d:/mysql/bin/mysqld-nt -- skip-grant-tables to start mysql and disable permission check.
4. run d:/mysql/bin/mysqladmin-u root flush-privileges password "newpassword" to reset the root password.
5. restart the mysql service.

You can also directly modify the mysql table in step 1. the SQL statements used are the same as those in linux.