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 is thee best hosting solution I have found in 10 years of searching. I'm very grateful of the services they provide. Such a vast variety to host whatever you desire at a great rate. The support team has always been great, always get a reply within 4 Hours of posting, usually way before 4H. I have a range of 1-10gbit machines and they've always kept up with premium standards. Networks they sell are premium, guaranteed. Thank you, AYK :)
Great response time and excellent service. I've been with AYK for nearly a year now and I couldn't be happier. If you're ready to make the step up from budget hosting to someone that can still work with you to spec out a server for your needs at an extremely competitive price, shoot these guys an email and see what they have available. You will not regret it. With datacenters located all ove r the globe they're certain to have something for you.. or they'll just build it