use mysql;
-- 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
-- 修改用户外部访问权限
update user set host='%' where user = 'root';
FLUSH PRIVILEGES;
-- 开启远程访问
-- 直接执行这一句会报错:You are not allowed to create a user with GRANT; 是因为数据库里没有这个用户
grant all privileges on *.* to 'root'@'%' with grant option;
FLUSH PRIVILEGES;
mysql8修改密码,开启远程访问
于 2019-10-31 20:13:32 首次发布