What to do with 1045 error in mysql database

Solution to 1045 error in mysql database: First find the [my.ini] file in the MySQL installation path and open it with Notepad; then find the location of mysqld; then add the statement [skip] under [mysqld] -grant-tables]; just save it finally.

【Related learning recommendations: mysql tutorial(Video)】

Solution to 1045 error in mysql database:

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 mysqlds in the content of this file. Pay attention to the location pointed by the arrow

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

skip-grant-tables is used as a startup parameter: the 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.

If you want to know more about programming learning, please pay attention to the php training column!

The above is the detailed content of What to do with 1045 error in mysql database. For more information, please follow other related articles on the PHP Chinese website!