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

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';