Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 a quick way I can connect to the database from command prompt to make sure its allowing access from my IP address?

like image 914
Philip Kirkbride Avatar asked Jun 05 '12 16:06

Philip Kirkbride


1 Answers

use mysql client, if you have it installed it's quite easy to access a remote host

mysql -hyour_ddbb_server_ip -uyour_user -pyour_password your_database_name

or

mysql -h your_ddbb_server_ip -u your_user -p  your_database_name

* note that in the first option there are no blank spaces between parameter option and its value

* your_database_name is optional

like image 58
Packet Tracer Avatar answered Oct 27 '22 01:10

Packet Tracer