How to set the DB Navigator plug-in for Phpstorm

Instructions

1. Install DB Navigator Plugin via menubar >> Settings >> Plugins >> available-tab

2. Download MySQL JDBC Connector from here >> http://www.pc6.com/softview/SoftView_99415.html

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:your perfered Driver (most likely of the standard Driver would do >> com.mysql.jdbc.Driver)

• Url:connection URL with a JDBC reference (e.g.: jdbc:mysql://localhost:3306/)

• Username:the db UserName (root)

• Password:the db Password (root)

How to set the DB Navigator plug-in for Phpstorm