Find out MySQL database URL from phpMyAdmin

mysql database remote-server
Philip Kirkbride picture Philip Kirkbride · Jun 5, 2012 · Viewed 9.6k times · Source

I have an online MySQL database. I want to figure out the server URL so I can remotely connect to it.

Is there a way I can check my databases URL from phpMyAdmin?

Answer

David Manheim picture David Manheim · Jun 15, 2012

Remote connections are turned off by default.

Per Ashes999's comment: Ask your web hosting company.

Alternatively, per Here, try: echo $_SERVER['SERVER_ADDR'];.

Related questions

How to backup MySQL database on a remote server?

I have a MySQL database existing on a remote server. I only have sql connection privilege. I don't have FTP access to the server, and I need to do a complete dump of the database. I have tried mysqldump, but …

Read More
Test Remote Database Access Host

I've set up my Remote Database Access Host, on my web hosting cpanel, enabling my home computer IP address to access the online database. To the best of my knowledge it should be working, but I'm not 100% sure. Is there …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More