How to forget the root password in Mysql8.0.13 under Windows 10 system

1. First stop the mysql service

As an administrator, open CMD and close it or close the Windows service page

C:\Users\xxx>net stop mysql

Open the CMD page as an administrator and enter the following command to start MySQL without a password

C:\Users\xxx>mysqld --console --skip-grant-tables --shared-memory

See the following page and open a new CMD page

Enter the following in the new CMD page

mysql> flush privileges; -- Modify privileges Query OK, 0 rows affected (0.16 sec)

mysql> ALTER USER "root"@"localhost" IDENTIFIED BY "123456"; -- Change password Query OK, 0 rows affected (0.08 sec)

After completing the above operation, the password is changed. You can log in with the new password after exiting.

Reference: MySQL error: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement solution

Next, I will explain to you the solution to the MySQL error: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement. Interested students can refer to it.

Error description:

mysql> grant all on cactidb.* to dbuser@'localhost' identified by '123';

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Solution:

Refresh the permissions table first.

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql> grant all on cactidb.* to dbuser@'localhost' identified by '123';

Query OK, 0 rows affected (0.00 sec)

Reference as follows

https://www.jb51.net/article/203587.htm

This is the end of this article about how to operate Mysql8.0.13 when you forget the root password under Windows 10 system. For more related content about Windows 10 Mysql8.0.13 when you forget the root password, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!