linux放开mysql/mariaDB远程连接

1、登录MySQL

mysql -u root -p root

2、修改mysql库的user表，将host项，从localhost改为%。%这里表示的是允许任意host访问，如果只允许某一个ip访问，则可改为相应的ip

mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> select host, user from user;
mysql> update user set password=password('root') where user='root' and host='%';
mysql> flush privileges;

3、防火墙开放3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload