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.

You may also be interested in:

MYSQL ERROR 1045 (28000): Access denied for user (using password: YES) solution
MySQL login error prompt: Solution to ERROR 1045 (28000)
Solution to 1045 error when navicat connects to mysql
Solution to 1044/1045 error when installing Navicat in MySQL
1045 error when installing MySql
Solution to MySql error code 1045 under Windows
How to solve Error 1045 access denied when installing MYSQL on winxp
MySQL ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: NO) Causes and solutions
How to solve the ERROR 1045 problem when logging into mysql
Solve the problem of ERROR 1045 (28000): Access denied for user ''root''@''localhost'' when logging in after installing MySQL 5.7.17 on Ubuntu 16.04

<<: How to enable or disable SSH for a specific user or user group in Linux

>>: Native js to implement a simple calculator