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!
The most caring provider AYKSolutions is a reliable hosting and decicated server probider with good uptimes etc etc, which nowadays is a must for any copany in the hosting industry, But what makes them stand out from cowd - is there sincere care for their customers. AYK stuff is always asking you about problems you have and doing their best to solve the problems and help yo ur business to grow. Best support ever!
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 :)
I have been with ayksolutions for around 5 years and have been thoroughly impressed with them. All support tickets are answered within minutes, regardless of the time of day. Prices are very reasonable, especially considering the support and services they provide. They are constantly doing crazy deals for servers as well. If you're looking for someone good and reliable to host with, from shared hosting to dedicated servers, I easily recommend ayksolutions.