Shulou(Shulou.com)05/31 Report--

How to solve the 1045 error in mysql database? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

Solution:

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.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.