mysql修改root密码 && mysql允许远程连接

修改密码:

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;

点赞

发表回复

电子邮件地址不会被公开。必填项已用 * 标注