Go to ...


A Better Technical Repository

RSS Feed

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: [email protected]

Setup new Connection:
User: mysqlusername
Password: userpassword
Database: mysql
Port: 6610
Socket: leave blank
Timeout: 30

Right click on you new connection and click open.

You should now see all of you Database

By: nighthawk