Error trying to connect to db with phpstorm

Avatar
Permanently deleted user
Created

Hello,

I am new to phpstorm and having problems connecting to my database on my local machine.

I am using WAMP and phpstorm 6.0.3.

I set up the Data Source like this:
JDBC driver files: I tried
mysql-connector-java-5.1.26-bin.jar, mysql-connector-license.txt

And
MySQL Connector/J-5.1.26

JDBC driver class: com.mysql.jdbc.Driver


Database URL I tried:
jdbc://mysql://localhost:3306/dbname
And
jdbc://mysql://127.0.0.1:3306/dbname

User: root

Password: left blank, there is no password.

When I press Test Connection I get this error:
Incorrect driver and/or connection setting specified.

Can someone please help?

Votes

0

Share

2 comments
Avatar
Andriy Bazanov
Created

Hi there,

Database URL I tried:
jdbc://mysql://localhost:3306/dbname
And
jdbc://mysql://127.0.0.1:3306/dbname

That's wrong. You do not need first "//" . It should be like this (add port if necessary; you can skip it if it is default one, which is 3306)

jdbc:mysql://127.0.0.1/dbname

0
Avatar
Permanently deleted user
Created

God bless you ! :)

0

Please sign in to leave a comment.