Linux MySQL 外部接続設定

確認

Thank you for reading this post, don't forget to subscribe!

mysql> SELECT user, host FROM mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

host を % に変更

mysql> RENAME USER 'root'@'localhost' TO 'root'@'%';

mysql> SELECT user, host FROM mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+

FireWallでポート解放

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

コマンドから接続を確認

% mysql -uroot -p -h IP ADDRESS