windows安装mysql教程

https://www.cnblogs.com/zhangkanghui/p/9613844.html

开启外网访问:

命令行登录mysql

use mysql;
update user set host='%' where user='root';
flush privileges;

ok

补充:修复mysql 8.0 caching-sha2-password问题

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';

FLUSH PRIVILEGES;

 

posted @ 2020-06-24 09:17  官萧何  阅读(169)  评论(0)    收藏  举报