Why use MySql Client?
One time, You must access your database that is located in another site of earth from you but you want to access it from console just as is in your local computer. Using web based SQL is a good idea but it takes a lot of unnecessary data transfer, come to think of it, you just want to access the data in the Database, but in order to do that, you must download the html files along with data from Database. If this is your problem, then MySql Client will be the alternative way for you, the advantages are
- Minimalize unnecessary data transfer.
- Shorter waiting time.
- Reduce the Server load.
How to Connect to Remote Database?
This will be the code you need to type in order to connect to Remote Database
mysql -h server_site -u user -p
Example
mysql -h my_database_site.com -u root -p
Just a note, you have to make sure that your server allow you to do Remote Connection Database. As conclusion, keep trying and you will be make it.![]()