Allows you to search a variety of questions and answers
First ensure that outgoing port 3306 is open on the local server and incoming port 3306 is open on the remote server.
Then you can use the following:
mysql -h remote_IP -u remote_DB -p
If 'mysql' does not work, use the full path such as /usr/local/mysql/bin/mysql. That will change according to where your mysql is setup.
When prompted for the password, type in the password and you are in!
AYK Solutions offers unmatched top tier support. They have gone above and beyond time and time again. They are very pompt, highly knowlegeable and curtious. I have been using AYK for 4 years now and yup its easy to say they have earned a customer for life. Thank you so much for helping me and business excell. Regards, Johnny
Even though I only have a shared hosting plan, their technical support team responded to my tech support request within the hour, and correctly to boot. (I needed to have a subdomain point to a Tumblr blog by changing the CNAME.)