How to find the host name of mysql server

Run this query at mysql command terminal or mysql command prompt

mysql> SELECT *
FROM information_schema.GLOBAL_variables
WHERE variable_name LIKE 'hostname'
LIMIT 0 , 30


Output:
+---------------+-----------------+
| VARIABLE_NAME | VARIABLE_VALUE  |
+---------------+-----------------+
| HOSTNAME      | name.localhost         |
+---------------+-----------------+
1 row in set (0.00 sec)