How do I find out what my IP Address of my MySQL host is?

Question

I have a free domain running at x10hosting (x10.bz), and I want to find out the IP Address of my MySQL host for it, so I can contact the MySQL database from another host. I've already added that host to the access list, but now I need to find out the IP Address of the MySQL host. How can I find this out? x10 is using cPanel X and PHPMyAdmin.

score 53 · Accepted Answer · edited Oct 16 '12 at 14:14

53

The SQL query SHOW VARIABLES WHERE Variable_name = 'hostname' will show you the hostname of the MySQL server which you can easily resolve to its IP address.

SHOW VARIABLES WHERE Variable_name = 'port' Will give you the port number.

You can find details about this in MySQL's manual: 12.4.5.41. SHOW VARIABLES Syntax and 5.1.4. Server System Variables

edited Oct 16 '12 at 14:14

Community

1

answered Apr 06 '10 at 07:14

joschi

21,387
3
47
50

8

My hostname says `ubuntu`. How do I check the IP address of that? – Pacerier Jul 07 '15 at 07:19
2

information_schema equivalent: `select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';` – ThorSummoner May 31 '18 at 17:29
1

I don't understand how hostname can supposedly be resolved to an IP address. Mine is running on docker so the hostname is jibberish. – Shardj Jun 17 '19 at 09:28
Add `;` at the end of the query like so: `SHOW VARIABLES WHERE Variable_name = 'hostname';` – Blues Clues Jun 23 '21 at 08:53

mysqlrockstar · Answer 2 · 2016-07-06T08:16:19.210

You may try this if using MySQL 5.7 version

 mysql> SELECT SUBSTRING_INDEX(USER(), '@', -1) AS ip,  @@hostname as hostname, @@port as port, DATABASE() as current_database;
+-----------+-----------------+------+------------------+
| ip        | hostname        | port | current_database |
+-----------+-----------------+------+------------------+
| localhost | host001         | 3306 | kakadba          |
+-----------+-----------------+------+------------------+
1 row in set (0.00 sec)

Or just write status in mysql prompt

mysql> \s

OR

 mysql> status

score 7 · Answer 3 · answered Oct 10 '14 at 17:52

Using PHPMyAdmin all variables are already listed if you click "home" > "MySQL system variables". You can use the find feature of your browser to search for the "hostname" and the "port" variables or scroll to them. It's listed in alphabetical order. No mucking about with queries if you are a non technical person.

score 4 · Answer 4 · answered Apr 27 '16 at 06:35

4

Once you are in phpMyAdmin, look for the horizontal menu:

Dashboard | Sql | Status | Users ...etc

Click on Variables.

Here you will find all the variables for mySql server. You can try the search box for specific variables.

Good Luck.

answered Apr 27 '16 at 06:35

Aakash

141
3

How do I find out what my IP Address of my MySQL host is?

4 Answers4