MySQL forgot the root password _ MySQL

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.