mysql报错:Host ***.***.***.*** is not allowed to connect to this MySQL server

IP不允许连接mysql服务,mysql默认只能本机访问

#连接mysql并输入密码
mysql -u root -p
#使用mysql表
use mysql;
#修改远程访问ip(可以根据需求设置访问网段,eg:update user set host = '192.168.1.%' where user ='root';)
update user set host = '%' where user ='root';