MySQL 8.0.29でサーバーのホスト名を確認する
環境
MySQL 8.0.29-0ubuntu0.22.04.2
Ubuntu 22.04 LTS
構文
SHOW VARIABLES LIKE 'hostname’;
「SHOW VARIABLES LIKE」を利用してサーバーのホスト名を確認します
方法1
使用例
mysql> SHOW VARIABLES LIKE 'hostname';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| hostname | arkgame |
+---------------+---------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'hostname';
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| hostname | arkgame |
+---------------+---------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'hostname'; +---------------+---------+ | Variable_name | Value | +---------------+---------+ | hostname | arkgame | +---------------+---------+ 1 row in set (0.00 sec)
方法２
使用例
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| arkgame |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| arkgame |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname; +------------+ | @@hostname | +------------+ | arkgame | +------------+ 1 row in set (0.00 sec)