Blog

Scenario:

• you have a Linux remote host with your MySQL database server
• you have enabled SSH server on your Linux Server
• you want manipulate your MySQL server using a remote machine (in this case I use a Mac).

To manipulate your MySQL you could use PhPMyAdmin, but I prefer to use a client application on my Mac without installing other software on remote Linux server (more secure!).

Well! To do this follow this steps on your Linux server:

1. edit your /etc/hosts.allow file and add this line (if missing):

   ALL:127.0.0.1

2. edit your /etc/ssh/sshd_config file and ensure that there is a line like this:

   AllowTCPForwarding yes

3. restart sshd daemon:

   linux:~# /etc/init.d/sshd restart

4. download Sequel Pro (or your preferred application) and add new connection using SSH tab on Connection Properties.
5. Done.

Enjoy!

About Marcello Gesmundo

I'm the founder of Yoovant company. I'm an engineer and an artist: what could be better than combine the technologies with the arts?