mysql8.0安装过程
开启远程访问
use mysql;
update user set host = '%' where host = 'localhost' and user = 'root';
flush privileges;
# 修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;
#设置允许远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
flush privileges;
评论区