Test Remote Database Access Host

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

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?

Answer

Packet Tracer picture Packet Tracer · Jun 5, 2012

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

Related questions

'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
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More