MySQL Database

ID #188

Can I connect to my MySQL database from my own computer?

Applies to: Grid System

No, we do not allow connections to the database servers from outside our network.


Last update: 2010-10-03 13:19
Author: FAQ Admin
Revision: 1.2

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 3.2 (5 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ

Comment of Anonymous:
It is possible to use port forwarding through an ssh tunnel. You can use PuTTY to create this, then use MySQL Front for instance and connect to localhost:3306 et voila :-)
Added at: 2004-03-01 00:10

Comment of Anonymous:
You can find lots of articles with a simple search:
http://www.google.com/search?q=ssh+tunnel+mysql+putty

like this one:
http://www.phpbuilder.com/columns/kenlin20040702.php3

Added at: 2005-05-08 23:06

Comment of Anonymous:
If you have trouble with dropped connections, use the db server's IP address rather than domain name to establish your ssh tunnels. I couldn't connect to DB2 until I did this. Thanks Modwest!
Added at: 2009-11-20 09:59

Comment of Anonymous:
This worked for me. From my PC, I issued this command in a terminal window, which establishes the tunnel:

ssh -L localhost:33066:db2.modwest.com:3306 username@shell.modwest.com

Then, I ran this:

mysql -h 127.0.0.1 -P 33066 -u username -p

After typing my database password, I was able to access all of my databases that are stored on the server 'db2.modwest.com'.

You'll obviously need to update the username in this example to whatever your actual username is and, you may also need to update the database server name if your database resides on one of the other database servers at Modwest.

I hope this helps someone else!

Added at: 2010-12-14 12:38