修改root用户名密码: SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpass’); SET PASSWORD FOR ‘root’@’127.0.0.1’ = PASSWORD(‘newpass’); SET PASSWORD FOR ‘root’@’%’ = PASSWORD(‘newpass’);
修改root用户名密码: SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpass’); SET PASSWORD FOR ‘root’@’127.0.0.1’ = PASSWORD(‘newpass’); SET PASSWORD FOR ‘root’@’%’ = PASSWORD(‘newpass’);