2.09.2012

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

Ярлыки: ,