centos系统mysql修改远程登录密码与本地密码

luozhangyou

本地root密码:

update user set password=password("密码xxxx") where user="root";
或
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');


flush privileges;

设置远程帐号密码:

GRANT ALL PRIVILEGES ON *.* TO '远程帐号xxx'@'%'IDENTIFIED BY '密码xxxx' WITH GRANT OPTION;

flush privileges;