MYSQL: Remote Administration using port forwarding
If a user like root is allowed to log onto the MYSQL locally only, the following method works perfect for remote administration.
You will need to know the following information:
1. MYSQL server name
2. MYSQL username
3. MYSQL database name
4. MYSQL listening port. Usually 3306
5. Install Mysql Navigator on your linux box
Connect to the remote server with a port forward:
ssh -L 6610:127.0.0.1:3306 mysqlusername@servername
Setup new Connection:
Socket: leave blank
Right click on you new connection and click open.
You should now see all of you Database