MySQL总结

1、启动mysql

sudo /usr/local/mysql/support-files/mysql.server start
2、停止mysql

sudo /usr/local/mysql/support-files/mysql.server stop
3、重启mysql

sudo /usr/local/mysql/support-files/mysql.server restart

1、connect ECONNREFUSED 127.0.0.1:3306

重启MySQL即可

2、ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server

原因

导致这个错误的原因是，目前，最新的mysql模块并未完全支持MySQL 8的“caching_sha2_password”加密方式，而“caching_sha2_password”在MySQL 8中是默认的加密方式。

解决办法

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
Query OK, 0 rows affected (0.12 sec)

3、set password for root@localhost = password(‘123’);报语法错误

换成alter user 'root'@'localhost' identified by '123'即可。