Java321技术网
标题:
centos系统mysql修改远程登录密码与本地密码
[打印本页]
作者:
luozhangyou
时间:
2017-12-31 16:51
标题:
centos系统mysql修改远程登录密码与本地密码
本地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;
欢迎光临 Java321技术网 (https://www.java321.com/)
Powered by Discuz! X3.3