Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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.

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


commented in your /etc/my.cnf

share|improve this answer

Your Answer


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.