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!
Great prices and service! Truly is painless, professional and polite (That's their slogan).
After getting a dedicated server from AYK for almost 2 years, I couldn't be more happy. The prices are very reasonable, I haven't experienced a moment of downtime, the support is excellent and truly 24/7. You have a critical issue at 2am? You will have it sorted out in less than 15 minutes. If you are looking for honest, reliable and affordable hosting provider, look no further!
I recently switched to AYK Solutions from Softlayer for my dedicated server requirements. I received a much better specification server at significantly reduced cost from what Softlayer could offer me, with many of the previously 'extra' features at Softlayer included in the base price offered by AYK. The support was second to none, and they were extremely helpful in transferring all of my old server accounts over for no additional fee whatsoever.