1mysql服务器登陆
mysql -u root -p
2提示输入密码
输入密码
3插入新用户
grant select,insert,update,delete on *.* to root@"%" Identified by "123456";
4查询是否插入成功
select host ,user ,password from user where user='root';
5其他主机可以访问
1mysql服务器登陆
mysql -u root -p
2提示输入密码
输入密码
3插入新用户
grant select,insert,update,delete on *.* to root@"%" Identified by "123456";
4查询是否插入成功
select host ,user ,password from user where user='root';
5其他主机可以访问