Msql允许远程赋权命令

1、允许所有ip远程连接mysql，命令行输入一下命令

# grant all privileges on *.* to 'root'@'root' identified by '123456’:,

# flush privileges;

 

2、mysql数据库修改密码

# mysql -u root -p

# set password for 'root'@'%' = password('Test201904');

# set password for 'root'@'localhost' = password('Test201904');

# flush privileges;