How do I find out my database server in mySQL?

[universetoday]

I want to connect to an external mysql database. Instead of "localhost", I need to put in the address of the database server. Is there a way within mySQL to find out what your database server address is?

[mack]

By default mysql will only allow connections from Localhost. You will need to grant permission for the other host to connect to it.

Do you not know the address of your mysql server? You may be best to speak to your host or server provider, they will be able to tell you, your exact hostnames and ip addresses.

Mack.

[grandpa]

You will need to grant permission for the other host to connect to it.

With our host (and many others I suspect) this comes with an additional fee.

[mack]

You may be correct. I am just used to shelling in and carrying out the procedure. I guess many hosts will indeed charge for this.

Mack.

[universetoday]

I've got a dedicated server with root access. I could do anything I like with my server, I just don't know how. :-)

[mack]

The address of mysql will be the same as the ip address if your server running mysql. Your server people should be able to tell you your exact ip.

To allow remote connection to connect to your mysql server you will need to run somethign like this...

GRANT ALL ON .* [e-mail] IDENTIFIED BY 'password';

Mack.

[pnllan]

"I want to connect to an external mysql database. Instead of "localhost", I need to put in the address of the database server..."

I'm taking it that you have a physically 'local' DB server, and that you also have access to a external or remote DB server. If so, do you have physical access or not? If not, the person administering the external DB server should be able provide this INFO.