Go to ...

Techpository

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

Setup new Connection:
Host: 127.0.0.1
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