mysql服务启动提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

有可能存在两个数据库服务

修改其中一个服务的端口号通过my.ini

进入到mysql 路径

D:\MySQL8.1\bin>mysql -u root -p
Enter password: ******
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

指定端口进行登录

D:\MySQL8.1\bin>mysql -h localhost -P 3307 -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 357
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

 

mysql> use mysql;
Database changed
mysql> select host, user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+------------------+
4 rows in set (0.00 sec)

mysql> select * from user;