MySQL forgot the root password _ MySQL

MySQL forgot the root password in Windows

Mysqld-nt -- skip-grant-tables

Mysqladmin-u root flush-privileges password "newpassword"

----------------------------------------

Tip: 1045 access denied for user 'root' @ 'localhost' using password yes
I had a good time a few days ago. I did not get it yesterday. as a result, this error was reported this evening. I still cannot restart mysql.
I read a few online methods, but I don't know how to get them.
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.