#连接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';
mysql报错:Host ***.***.***.*** is not allowed to connect to this MySQL server
Host ***.***.***.*** is not allowed to connect to this MySQL serverIP不允许连接mysql服务,mysql默认只能本机访问IP不允许连接mysql服务,mysql默认只能本机访问use mysql;#修改远程访问ip(可以根据需求设置访问网段,eg:update user set host = '192.168.1.%' w...