更新已有的用户名密码
UPDATE mysql.user set authentication_string = PASSWORD ("123") WHERE User = "root" and Host="%";
flush privileges;
重新设置现在正在登录的用户的账号密码
SET PASSWORD = PASSWORD ("123");
flush privileges;
更新已有的用户名密码
UPDATE mysql.user set authentication_string = PASSWORD ("123") WHERE User = "root" and Host="%";
flush privileges;
重新设置现在正在登录的用户的账号密码
SET PASSWORD = PASSWORD ("123");
flush privileges;