解决mysql远程访问

1.use mysql;
2.show tables;
3.select host from user;
4.update user set host ='%' where user ='root';
5.重启mysql服务


也可以重新创建一个用户赋权限

1.CREATE USER liudong IDENTIFIED BY '123456'

2.GRANT ALL PRIVILEGES ON 数据库名.* TO 'liudong'@'%' WITH GRANT OPTION

grant all on mysql.* to 'root'@'localhost' identified by '12345';


3.GRANT ALL PRIVILEGES ON 数据库名.* TO 'liudong'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

4.FLUSH PRIVILEGES

INSERT INTO mysql.user (Host,User,Password) VALUES('%','system', PASSWORD('12345'));




允许192.168.1.200 用户为root 密码为 123456链接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.200' IDENTIFIED BY '123456' WITH GRANT OPTION;

允许任意ip
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

修改root用户密码为123456
update user set password=PASSWORD('123456') where user='root';

不建议用以下方式赋权限
UPDATE user SET Host='192.168.1.200' WHERE User='root' AND Host='%' LIMIT 1;
update user set host = '%' where user ='root';
flush privileges;


SELECT
    mysql.user.User,
    mysql.user.Password,
    mysql.user.Host
FROM
    mysql.user ;