mysql 修改密码 开启远程访问权限
时间:2022-03-14 00:57
修改密码
update user set password=password(‘‘) where user=‘root‘;
FLUSH PRIVILEGES;
远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;
时间:2022-03-14 00:57
修改密码
update user set password=password(‘‘) where user=‘root‘;
FLUSH PRIVILEGES;
远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;