Solution to 1045 error in mysql database

How to solve the problem of 1045 when the local database is connected to the server database?

This means: Access denied for user "root"@localhost

Solution:

1. Find the my.ini file in the MySQL installation path and open it with Notepad;

2. After opening, find the location of mysqld. There are multiple mysqld in the content of this file. Pay attention to the position pointed by the arrow

3. Add the statement skip-grant-tables under [mysqld] and save it after adding.

The role of skip-grant-tables as a startup parameter: MYSQL server does not load permission judgment, and any user can access the database. In other words, after enabling this parameter, the security of the database will be reduced.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.