修改密码:
use mysql
update user set password=password(‘xxx’) where user=‘root’ and host=‘localhost’;
远程连接:
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
flush privileges;
记录学习和工作
修改密码:
use mysql
update user set password=password(‘xxx’) where user=‘root’ and host=‘localhost’;
远程连接:
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
flush privileges;
评论 (0)