MySQL允许远程访问

如果mysql没有设置允许远程访问时进入远程访问就会报错:

1
_mysql_exceptions.OperationalError: (1130, "Host 'x.x.x.x' is not allowed to connect to this MariaDB server")

就要修改mysql数据库的访问权限:

1
2
3
4
5
6
mysql>use mysql;
mysql>update user set host = '%' where host ='root';
MariaDB [mysql]> update user set host = '%' where host = 'localhost';
mysql>flush privileges;
mysql> select host, user from user;
mysql>quit

当然不用了也要改回去了:

1
2
mysql>update user set host = 'localhost'  where host ='%';
MariaDB [mysql]> update user set host = 'localhost' where host = '%';
Author: y500
Link: https://www.y500.me/2015/12/23/mysql-allow-remote-access/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.