find server ip by sql

up vote
0
down vote

favorite

How can I get server ip (host) by a MySQL query?
an sql like this:

SELECT @@SERVERIP

I want to connect to my db by netbeans, and I can't use 'localhost' for host.

thanks

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

1

Can you use 127.0.0.1 for host?
– Tadeck
Nov 30 '11 at 18:23

show variables like '%hostname%'
– Marc B
Nov 30 '11 at 18:25

Why? If you can connect to the server to execute such a query, you must already know either its hostname or its IP address, and once you have one of those, DNS will give you the other.
– user207421
Aug 1 '16 at 2:26

@EJP: because my shared hosting service do not allow direct connect to database server, and it hides its ip
– mrdaliri
Aug 1 '16 at 6:02

So you can't connect to it, so you want to connect to it to ask it how to connect to it? This isn't making any sense..
– user207421
Aug 2 '16 at 22:24

|
show 2 more comments

up vote
0
down vote

favorite

How can I get server ip (host) by a MySQL query?
an sql like this:

SELECT @@SERVERIP

I want to connect to my db by netbeans, and I can't use 'localhost' for host.

thanks

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

1

Can you use 127.0.0.1 for host?
– Tadeck
Nov 30 '11 at 18:23

show variables like '%hostname%'
– Marc B
Nov 30 '11 at 18:25

Why? If you can connect to the server to execute such a query, you must already know either its hostname or its IP address, and once you have one of those, DNS will give you the other.
– user207421
Aug 1 '16 at 2:26

@EJP: because my shared hosting service do not allow direct connect to database server, and it hides its ip
– mrdaliri
Aug 1 '16 at 6:02

So you can't connect to it, so you want to connect to it to ask it how to connect to it? This isn't making any sense..
– user207421
Aug 2 '16 at 22:24

|
show 2 more comments

up vote
0
down vote

favorite

How can I get server ip (host) by a MySQL query?
an sql like this:

SELECT @@SERVERIP

I want to connect to my db by netbeans, and I can't use 'localhost' for host.

thanks

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

How can I get server ip (host) by a MySQL query?
an sql like this:

SELECT @@SERVERIP

I want to connect to my db by netbeans, and I can't use 'localhost' for host.

thanks

mysql

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

asked Nov 30 '11 at 18:21

mrdaliri

2,744145890

1

Can you use 127.0.0.1 for host?
– Tadeck
Nov 30 '11 at 18:23

show variables like '%hostname%'
– Marc B
Nov 30 '11 at 18:25

Why? If you can connect to the server to execute such a query, you must already know either its hostname or its IP address, and once you have one of those, DNS will give you the other.
– user207421
Aug 1 '16 at 2:26

@EJP: because my shared hosting service do not allow direct connect to database server, and it hides its ip
– mrdaliri
Aug 1 '16 at 6:02

So you can't connect to it, so you want to connect to it to ask it how to connect to it? This isn't making any sense..
– user207421
Aug 2 '16 at 22:24

|
show 2 more comments

1

Can you use 127.0.0.1 for host?
– Tadeck
Nov 30 '11 at 18:23

show variables like '%hostname%'
– Marc B
Nov 30 '11 at 18:25

Why? If you can connect to the server to execute such a query, you must already know either its hostname or its IP address, and once you have one of those, DNS will give you the other.
– user207421
Aug 1 '16 at 2:26

@EJP: because my shared hosting service do not allow direct connect to database server, and it hides its ip
– mrdaliri
Aug 1 '16 at 6:02

So you can't connect to it, so you want to connect to it to ask it how to connect to it? This isn't making any sense..
– user207421
Aug 2 '16 at 22:24

Can you use 127.0.0.1 for host?
– Tadeck
Nov 30 '11 at 18:23

show variables like '%hostname%'
– Marc B
Nov 30 '11 at 18:25

Why? If you can connect to the server to execute such a query, you must already know either its hostname or its IP address, and once you have one of those, DNS will give you the other.
– user207421
Aug 1 '16 at 2:26

@EJP: because my shared hosting service do not allow direct connect to database server, and it hides its ip
– mrdaliri
Aug 1 '16 at 6:02

So you can't connect to it, so you want to connect to it to ask it how to connect to it? This isn't making any sense..
– user207421
Aug 2 '16 at 22:24

|
show 2 more comments

2 Answers
2

active

oldest

votes

up vote
0
down vote

no you cannot here you can read from this thread :

http://lists.mysql.com/mysql/224556

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

add a comment |

up vote
0
down vote

It's simple try this.

You can get the[hostname][instancename] by:

SELECT @@SERVERNAME;

To get only the hostname when you have hostnameinstance name format:

SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('', ltrim(rtrim(@@ServerName))) -1)

Alternatively as @GilM pointed out:

SELECT SERVERPROPERTY('MachineName')

answered Jun 18 at 3:53

ravi polara

317111

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f8330898%2ffind-server-ip-by-sql%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
0
down vote

no you cannot here you can read from this thread :

http://lists.mysql.com/mysql/224556

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

add a comment |

up vote
0
down vote

no you cannot here you can read from this thread :

http://lists.mysql.com/mysql/224556

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

add a comment |

up vote
0
down vote

no you cannot here you can read from this thread :

http://lists.mysql.com/mysql/224556

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

no you cannot here you can read from this thread :

http://lists.mysql.com/mysql/224556

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

answered Nov 30 '11 at 18:23

LostMohican

1,70242135

add a comment |

up vote
0
down vote

It's simple try this.

You can get the[hostname][instancename] by:

SELECT @@SERVERNAME;

To get only the hostname when you have hostnameinstance name format:

SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('', ltrim(rtrim(@@ServerName))) -1)

Alternatively as @GilM pointed out:

SELECT SERVERPROPERTY('MachineName')

answered Jun 18 at 3:53

ravi polara

317111

add a comment |

up vote
0
down vote

It's simple try this.

You can get the[hostname][instancename] by:

SELECT @@SERVERNAME;

To get only the hostname when you have hostnameinstance name format:

SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('', ltrim(rtrim(@@ServerName))) -1)

Alternatively as @GilM pointed out:

SELECT SERVERPROPERTY('MachineName')

answered Jun 18 at 3:53

ravi polara

317111

add a comment |

up vote
0
down vote

It's simple try this.

You can get the[hostname][instancename] by:

SELECT @@SERVERNAME;

To get only the hostname when you have hostnameinstance name format:

SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('', ltrim(rtrim(@@ServerName))) -1)

Alternatively as @GilM pointed out:

SELECT SERVERPROPERTY('MachineName')

answered Jun 18 at 3:53

ravi polara

317111

It's simple try this.

You can get the[hostname][instancename] by:

SELECT @@SERVERNAME;

To get only the hostname when you have hostnameinstance name format:

SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('', ltrim(rtrim(@@ServerName))) -1)

Alternatively as @GilM pointed out:

SELECT SERVERPROPERTY('MachineName')

answered Jun 18 at 3:53

ravi polara

317111

answered Jun 18 at 3:53

ravi polara

317111

answered Jun 18 at 3:53

ravi polara

317111

answered Jun 18 at 3:53

ravi polara

317111

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

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.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Nsryjdtyk