How do i find out what my IP Address of my MySQL host is?How can I export the privileges from MySQL and then...
What is Tony Stark injecting into himself in Iron Man 3?
Inorganic chemistry handbook with reaction lists
Averaging over columns while ignoring zero entries
Having the player face themselves after the mid-game
Vector-transposing function
Who has more? Ireland or Iceland?
Tool for measuring readability of English text
Should I file my taxes? No income, unemployed, but paid 2k in student loan interest
A running toilet that stops itself
Paper published similar to PhD thesis
Can I challenge the interviewer to give me a proper technical feedback?
What is the best index strategy or query SELECT when performing a search/lookup BETWEEN IP address (IPv4 and IPv6) ranges?
What is better: yes / no radio, or simple checkbox?
What would be the most expensive material to an intergalactic society?
Help! My Character is too much for her story!
What does it take to become a wilderness skills guide as a business?
Use Mercury as quenching liquid for swords?
Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?
Where is the License file location for Identity Server in Sitecore 9.1?
Too soon for a plot twist?
Boss Telling direct supervisor I snitched
How can I have x-axis ticks that show ticks scaled in powers of ten?
How can I portion out frozen cookie dough?
How to distinguish easily different soldier of ww2?
How do i find out what my IP Address of my MySQL host is?
How can I export the privileges from MySQL and then import to a new server?How do I add remote users to MySQL on OS X 10.6 Server?Can I install phpMyAdmin on its own to access a seperate database?Mysql dump from old serverNot able to manage DB using Webadmin in PleskHow can I move a mysql database to another host, preserving the users/passwords?Find what is causing failed connections in mysqlUnknown MySQL server host - connection problemI need to move my MySQL database to a network drive, currently on a free web host accountHow to add access to a host via symbolic name?
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.
mysql ip host
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
add a comment |
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.
mysql ip host
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
add a comment |
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.
mysql ip host
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
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.
mysql ip host
mysql ip host
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
asked Apr 6 '10 at 6:18
Deniz ZoetemanDeniz Zoeteman
3232616
3232616
add a comment |
add a comment |
5 Answers
5
active
oldest
votes
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 6 '10 at 7:14
joschijoschi
17.2k34048
6
My hostname saysubuntu. How do I check the IP address of that?
– Pacerier
Jul 7 '15 at 7:19
1
information_schema equivalent:select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';
– ThorSummoner
May 31 '18 at 17:29
add a comment |
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.
answered Oct 10 '14 at 17:52
DanielDaniel
6111
add a comment |
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
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
add a comment |
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 6:35
AkashAkash
1312
add a comment |
I am using home-brew and i need the same thing!
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f129635%2fhow-do-i-find-out-what-my-ip-address-of-my-mysql-host-is%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
5 Answers
5
active
oldest
votes
5 Answers
5
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 6 '10 at 7:14
joschijoschi
17.2k34048
6
My hostname saysubuntu. How do I check the IP address of that?
– Pacerier
Jul 7 '15 at 7:19
1
information_schema equivalent:select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';
– ThorSummoner
May 31 '18 at 17:29
add a comment |
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 6 '10 at 7:14
joschijoschi
17.2k34048
6
My hostname saysubuntu. How do I check the IP address of that?
– Pacerier
Jul 7 '15 at 7:19
1
information_schema equivalent:select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';
– ThorSummoner
May 31 '18 at 17:29
add a comment |
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 6 '10 at 7:14
joschijoschi
17.2k34048
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 6 '10 at 7:14
joschijoschi
17.2k34048
edited Oct 16 '12 at 14:14
Community♦
1
edited Oct 16 '12 at 14:14
Community♦
1
edited Oct 16 '12 at 14:14
Community♦
1
1
answered Apr 6 '10 at 7:14
joschijoschi
17.2k34048
answered Apr 6 '10 at 7:14
joschijoschi
17.2k34048
answered Apr 6 '10 at 7:14
joschijoschi
17.2k34048
17.2k34048
6
My hostname saysubuntu. How do I check the IP address of that?
– Pacerier
Jul 7 '15 at 7:19
1
information_schema equivalent:select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';
– ThorSummoner
May 31 '18 at 17:29
add a comment |
6
My hostname saysubuntu. How do I check the IP address of that?
– Pacerier
Jul 7 '15 at 7:19
1
information_schema equivalent:select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';
– ThorSummoner
May 31 '18 at 17:29
6
6
My hostname says
ubuntu. How do I check the IP address of that?– Pacerier
Jul 7 '15 at 7:19
My hostname says
ubuntu. How do I check the IP address of that?– Pacerier
Jul 7 '15 at 7:19
1
1
information_schema equivalent:
select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';– ThorSummoner
May 31 '18 at 17:29
information_schema equivalent:
select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'hostname';– ThorSummoner
May 31 '18 at 17:29
add a comment |
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.
answered Oct 10 '14 at 17:52
DanielDaniel
6111
add a comment |
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.
answered Oct 10 '14 at 17:52
DanielDaniel
6111
add a comment |
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.
answered Oct 10 '14 at 17:52
DanielDaniel
6111
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.
answered Oct 10 '14 at 17:52
DanielDaniel
6111
answered Oct 10 '14 at 17:52
DanielDaniel
6111
answered Oct 10 '14 at 17:52
DanielDaniel
6111
answered Oct 10 '14 at 17:52
DanielDaniel
6111
6111
add a comment |
add a comment |
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
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
add a comment |
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
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
add a comment |
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
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
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
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
edited Jul 6 '16 at 8:16
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
answered Jul 6 '16 at 7:53
Infra DBAInfra DBA
386410
386410
add a comment |
add a comment |
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 6:35
AkashAkash
1312
add a comment |
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 6:35
AkashAkash
1312
add a comment |
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 6:35
AkashAkash
1312
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 6:35
AkashAkash
1312
answered Apr 27 '16 at 6:35
AkashAkash
1312
answered Apr 27 '16 at 6:35
AkashAkash
1312
answered Apr 27 '16 at 6:35
AkashAkash
1312
1312
add a comment |
add a comment |
I am using home-brew and i need the same thing!
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am using home-brew and i need the same thing!
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am using home-brew and i need the same thing!
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am using home-brew and i need the same thing!
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 11 mins ago
user513569user513569
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 11 mins ago
user513569user513569
1
answered 11 mins ago
user513569user513569
1
1
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user513569 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f129635%2fhow-do-i-find-out-what-my-ip-address-of-my-mysql-host-is%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
