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://java321.com/)