mysql 8
为root用户设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
然后
FLUSH PRIVILEGES;
设置远程登陆
update user set host='%' where user='root';
然后
FLUSH PRIVILEGES;
mysql 8
为root用户设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
然后
FLUSH PRIVILEGES;
设置远程登陆
update user set host='%' where user='root';
然后
FLUSH PRIVILEGES;