MySQL5.7
update user set authentication_string=passworD("123456") where user='root';
修改密码后
root使用123456从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
MySQL5.7
update user set authentication_string=passworD("123456") where user='root';
修改密码后
root使用123456从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;