February 14

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


Copyright 2021. All rights reserved.

Posted February 14, 2013 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B