Mysql ----- 安装登录ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘

1.登录mysql不成功

mysql  -u -root -p
Enter password: *****
ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: YES)

解决办法：
在mysql安装目录C:\Program Files\MySQL\MySQL Server 8.0下找到my.ini文件，加入skip-grant-tables（如果找不到my.ini文件，在C:\ProgramData\MySQL\MySQL Server 8.0找到，然后复制到C:\Program Files\MySQL\MySQL Server 8.0）

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=MYSQL
skip-grant-tables
# The TCP/IP Port the MySQL Server will listen on
port=3306

管理员权限进入命令行：依次输入

C:\Windows\system32>net stop mysql80
MySQL80 服务正在停止.
MySQL80 服务已成功停止。


C:\Windows\system32>net start mysql80
MySQL80 服务正在启动 .
MySQL80 服务已经启动成功。

C:\Windows\system32>cd C:\Program Files\MySQL\MySQL Server 8.0

C:\Program Files\MySQL\MySQL Server 8.0>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>mysql> status  #输入status查看是否连接成功
--------------
mysql  Ver 8.0.21 for Win64 on x86_64 (MySQL Community Server - GPL)

Connection id:          9
Current database:
Current user:           root@localhost
SSL:                    Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter:        ;
Server version:         8.0.21 MySQL Community Server - GPL
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Binary data as:         Hexadecimal
Uptime:                 9 min 58 sec

Threads: 3  Questions: 6  Slow queries: 0  Opens: 115  Flush tables: 3  Open tables: 36  Queries per second avg: 0.010
--------------

mysql>

登录成功