Aptana: How to connect to remote MySQL database via ssh tunnel and SQL Explorer plugin
Connect with Aptana to remote mysql database access to which restricted to localhost only
Use:
- Sql Explorer plugin (www.sqlexplorer.org/)
- Putty
1. Create tunnel to host with putty(http://www.cs.uu.nl/technical/services/ssh/putty/puttyfw.html):
Source port: 3306
Destination: 127.0.0.1:3306 Remote
2. Install Sql Explorer plugin for Eclipse to Aptana
3. Add mysql connector to Sql Explorer plugin drivers
- Download MySQL Connector from http://www.mysql.com/products/connector/
- Go to Window->Preferences->SQL Explorer->JDBC Drivers
- Select MySQL Driver and click Add button
- There enter details (Name and Example URL) and select "Extra Class Path" tab and point it to previously downloaded MySQL connector
- Save it
4. Open puty tunnel
5. Open Sql Explorer plugin Connection view and click on Create new connection
- Name it
- Select MySQL Driver
- URL: 127.0.0.1:3306
- Other options you need
6. That's it