_mysql

winserver mysql环境安装小记：

环境变量： http://c.biancheng.net/view/7143.html

离线安装：
Windows Server 2016安装MySQL - LanceCL - 博客园

远程访问：
https://cloud.tencent.com/developer/article/1795229

https://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server

重新安装的话需要停止服务、删除服务

如何删除一个服务在 Windows 系统中删除「服务」的 4 种方法 - 系统极客

如何杀死 mysqld：MySQL 服务无法启动请键入 NET HELPMSG 3523 以获得更多的帮助-腾讯云开发者社区-腾讯云

更改初始密码：
mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before - 开始认识 - 博客园

sql

mysql> alter user 'root'@'localhost' identified by '123456';  
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql8中nodejs连接的时间问题
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

问题： [42000][1044] Access denied for user 'root'@'%' to database 'xxxx'.

sql

GRANT CREATE ON *.* TO '<普通账号名>'@'%';

SET SESSION innodb_strict_mode = OFF;
SHOW VARIABLES LIKE ‘innodb_strict_mode’;