「CentOS7入門」MySQLにクライアントでリモート接続するの設定方法
環境
CentOS 7
1.3306のポートを開放します
#firewall-cmd --permanent --zone public --add-port 3306/tcp
#firewall-cmd --permanent --zone public --add-port 3306/tcp
#firewall-cmd --permanent --zone public --add-port 3306/tcp
2.MySQLサービスをゾーンに追加します
# firewall-cmd --permanent --zone public --add-service mysql
success
# firewall-cmd --reload
success
# firewall-cmd --permanent --zone public --add-service mysql
success
# firewall-cmd --reload
success
# firewall-cmd --permanent --zone public --add-service mysql success # firewall-cmd --reload success
3.ファイアウォールに設定を反映
# firewall-cmd --info-zone public
public (active)
target: default
icmp-block-inversion: no
interfaces: eth0
sources:
services: dhcpv6-client http mysql ssh
ports: 3306/tcp 80/tcp
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:
# firewall-cmd --info-zone public
public (active)
target: default
icmp-block-inversion: no
interfaces: eth0
sources:
services: dhcpv6-client http mysql ssh
ports: 3306/tcp 80/tcp
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:
# firewall-cmd --info-zone public public (active) target: default icmp-block-inversion: no interfaces: eth0 sources: services: dhcpv6-client http mysql ssh ports: 3306/tcp 80/tcp protocols: masquerade: no forward-ports: sourceports: icmp-blocks: rich rules:
4.権限の設定変更
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@"xxx.xxx.xxx.xxx" IDENTIFIED BY 'arkgame' WITH GRANT OPTION;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@"xxx.xxx.xxx.xxx" IDENTIFIED BY 'arkgame' WITH GRANT OPTION;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@"xxx.xxx.xxx.xxx" IDENTIFIED BY 'arkgame' WITH GRANT OPTION;
権限を更新します
MariaDB [(none)]> flush PRIVILEGES;
MariaDB [(none)]> flush PRIVILEGES;
MariaDB [(none)]> flush PRIVILEGES;
5.MariaDBのポートを確認します
MariaDB [(none)]> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
MariaDB [(none)]> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
MariaDB [(none)]> SHOW VARIABLES LIKE 'port'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+