2020-11-19

---

前言

Mac安装mysql时忘记记录初始密码，

就这个东西
导致运行mysql出错
错误如下：ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
解决思路：修改mysql密码。

二、解决步骤

1.关闭mysql服务

2.在终端中以管理员权限启动mysqld_safe，命令如下：

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

此时会要求输入密码，输入mac密码即可。执行后结果如下：

2020-11-18T16:23:18.6NZ mysqld_safe Logging to '/usr/local/mysql/data/Yangs-MBP.lan.err'.
2020-11-18T16:23:18.6NZ mysqld_safe Starting mysqld daemon with databases from 

3.不要关闭当前的终端窗口，新建一个终端窗口，输入如下命令，回车登录mysql

/usr/local/mysql/bin/mysql

登录后，看到mysql欢迎信息：：

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.22 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.

4.在mysql窗口输入命令

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)

5.更改mysql密码

我是安装的8.0版本，mysql不同版本修改密码的命令有些差异，当时在这里卡了好久。😭

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
Query OK, 0 rows affected (0.01 sec)

版本不同的伙伴，也可以看看这个提问，找找有没有自己需要的：
https://stackoverflow.com/questions/36099028/error-1064-42000-you-have-an-error-in-your-sql-syntax-want-to-configure-a-pa

总结

安装软件的时候一定慢慢来，不要一味“next”，要留意信息！