MySQL password is correct but cannot log in locally -1045

MySQL password is correct but cannot log in locally -1045 Access denied for user 'root'@'localhost' (using password:YES

MySQL password is correct but cannot log in locally

The error is as follows:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Solution:

1. Add the option to skip the password question in the parameters for starting MySQL, as follows:

vim /etc/my.cnf

And add skip-grant-tables under [mysql],

This is used to skip the password question, but it is not a complete solution.

2. Restart the MySQL service

I use Mysql in Linux system, the statement is as follows:

Check the port number:

ps aux|grep mysqld

Check the status:

systemctl status mysqld

Restart mysql service

systemctl restart mysqld

Try to connect:

mysql -uroot -p123456

Enter the password. You have just set it to skip the password, so you can ignore it.

The steps are as follows:

[root@localhost ~]# mysql -uroot -p123456
mysql> use mysql
Database changed
mysql> select user,host,password from user where user='root';
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | % | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+------+-----------------------+-------------------------------------------+
4 rows in set (0.02 sec)

mysql> update user set host='localhost' where user='root' and host='%';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> quit
Bye

OK, exit mysql, restart mysql to solve the problem

Compare before and after:

[root@localhost ~]# mysql -uroot -p
mysql> use mysql;
Database changed
mysql> select user,host,password from user where user='root';
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+------+-----------------------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql> 
OK!

Summarize

The above is what I introduced to you. The MySQL password is correct but you cannot log in locally - 1045 Access denied for user ''root''@''localhost'' (using password: YES. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. Thank you very much for your support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:

PHP+MySQL implements login verification to see if the login name and password are correct
Solution to the problem of being unable to log in locally even though the MySQL password is correct
How to correctly modify the ROOT password in MySql8.0 and above versions

<<: Keepalived implements Nginx load balancing and high availability sample code

>>: js method to realize shopping cart calculation

React implements double slider cross sliding

MySQL password is correct but cannot log in locally -1045

React implements double slider cross sliding

Detailed explanation of persistent storage of redis under docker

How to use React to implement image recognition app

Detailed steps for installing Tomcat, MySQL and Redis with Docker

Detailed explanation of using javascript to handle common events

jQuery implements the practice of changing the position and size of div by dragging the mouse

Nginx rtmp module compilation arm version problem

56 practical JavaScript tool functions to help you improve development efficiency

How to configure Java environment variables in Linux system

JavaScript array merging case study

Recommend

Example of pre-rendering method for Vue single page application

Installing Docker Desktop reports an error message: WSL 2 installation is incomplete (Solve the error message)

Vue Getting Started with Weather Forecast

jQuery simulates picker to achieve sliding selection effect

How to prevent duplicate submission in jquery project

An article to understand MySQL master-slave replication and read-write separation

Complete tutorial on installing Apache, MySQL, PHP, LAMP on Ubuntu 18.04

JavaScript implements checkbox selection function

Example of how to quickly build a LEMP environment with Docker

Solve the abnormal error when building vue environment with webpack

Solution to Nginx session loss problem

XHTML introductory tutorial: Application of table tags

Examples of clearfix and clear

How to check the version of Kali Linux system

A brief analysis of the responsiveness principle and differences of Vue2.0/3.0