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!
AYKsolutions - best solution for small/high business I have several plans with them and i can sleep well because their team watch over my servers. I started with a small shared account and now, after two years i have multiple dedicated boxes. I like the way they treat their customers, even if they have a small or a big plan. Their tehnical support is the best i ever meet ( worked with many hosting pro viders ). In one word: If you need cheap and no headache for your internet bussiness, AYKsolutions it's your best choice
I have never experienced a more professional and personal client-based service such as I am enjoying from AYKSolutions. This is no plotted statement either. I'm not a guru by no means, and they have been unbelievably superb in helping me promptly, professionally, courteously, and completely. Thank you Artyom & team.
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