Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to solve the problem of 1045 errors in the mysql database. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

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

The solution to the 1045 error in mysql database:

1. Find the my.ini file under the MySQL installation path and open it in notepad

two。 After opening it, find the location of mysqld. There are multiple mysqld in the content of this file. Note the location indicated by the arrow.

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

The role of skip-grant-tables as a startup parameter: the MYSQL server does not load permission judgment, and any user can access the database. That is, when this parameter is enabled, the security of the database is reduced.

On how to solve the problem of 1045 errors in the mysql database is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.