Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am relatively new at using linux and was wondering how hard it would be to allow remote access to mysql on my vps and if it is worth me doing for my needs.

The reason that I am asking is that I would like to use a desktop application to manage my databases instead of having to login to phpmyadmin.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

the best way would be keep 3306 closed from the public and then use an ssh tunnel to connection to your mysql server.

here is an example using putty.

http://realprogrammers.com/how%5Fto/set%5Fup%5Fan%5Fssh%5Ftunnel%5Fwith%5Fputty.html

share|improve this answer

You can allow external connections from certain IP using this SQL command:

GRANT ALL PRIVILEGES ON dbname.* TO username@'IP' IDENTIFIED BY 'password';

But please make sure you have

skip-networking

commented in your /etc/my.cnf

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.