database - How to configure DB Navigator for Jetbrains PHPStorm and WebStorm

Question

I need to set up a connection in the DB Navigator plugin for PHPStorm in a mac (snow leopard). It asks me for the route of a library that implements the java.sql.Driver class. I just don't have any idea of where is it. Any advice?

question from:https://stackoverflow.com/questions/7434742/how-to-configure-db-navigator-for-jetbrains-phpstorm-and-webstorm

Answer 1

Instructions

1. Install DB Navigator Plugin via menubar >> Settings >> Plugins >> Available-Tab
2. Download MySQL jdbc connector from here >> http://www.mysql.com/downloads/connector/j/
3. Unpack MySQL jdbc connector to a directory of your choice
4. Restart PHPStorm / WebStorm
5. Add a DB via menubar >> DB Navigator >> Settings >> Connection-Tab >> Plus-Button
6. Enter the parameters for your connection (see below for possible entries for a local MySQL DB)

Possible parameters for a local MySQL DB

• Name: name of choice (localhost)
• Description: additional info of choice (dbname)
• Driver Library: path to the .jar file (that is the directory used in step 3)
• Driver: preferred driver (most likely the standard driver will do >> com.mysql.jdbc.Driver)
• URL: connection URL with a jdbc reference (e.g.: jdbc:mysql://localhost:3306/)
• UserName: db username of choice (root)
• Password: db password of choice (root)