After installing MySQL, the root account prompt appears when logging in. mysql ERROR 1045 (28000): Access denied for use solution

After installing MySQL, you will find that the root password is not empty after executing mysql -uroot -p for the first time. To reset the root password, please refer to the following steps.

Edit the MySQL configuration file my.ini (if it is my_default.ini, please rename it to my.ini), and add the following under the [mysqld] entry:

 skip-grant-tables

After saving and exiting, restart MySQL and click "Start" -> "Run" (shortcut key Win+R).

1. Stop: Enter net stop mysql

2. Start: Enter net start mysql

At this time, enter mysql -u root -p in cmd to log in without a password. When password: appears, press Enter to enter. ERROR 1045 (28000) will not appear, but many operations will be restricted because we cannot grant (no permission). Follow the process below:

1. Enter the mysql database:

mysql> use mysql;
Database changed

2. Set a new password for the root user and enter the blue part yourself:

mysql> update user setauthentication_string=password("new password") where user="root";
Query OK, 1 rows affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

3. Refresh the database

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

4. Exit mysql:

mysql> quit
Bye

After the change, modify the my.ini file again, delete the "skip-grant-tables" line we just added, save and exit, and restart mysql.

You will be prompted after logging in again

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Just enter set password=password('新密碼');

The above is the solution to the problem that the root account prompts mysql ERROR 1045 (28000): Access denied for use appears after logging in to the newly installed MySql. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!