I have a test MySQL database created in via WAMP/phpmyadmin on localhost:8080. It works, and I can access it via phpmyadmin. Now I want to connect to it from PHPStorm. Heres what I've done:
- I have followed the instructions and filled in the info on the DataSources and Drivers to the best of my knowledge.
- I did a drag and drop of the database name from myphpadmin Databases screen to the Database: box, which put the address http://localhost:8080/phpmyadmin/db_structure.php?token= big long string =sandboxdb in the form.
- I selected MYSQL and downloaded the jdbc drivers, which now show up in the driver files box
When I click OK, I get "connecting to database... " and a progress indicator, but no connection.
It seems to be looking for a password, but I have not set up any passwords for the database.
I'm a student starting an intro to databases course where I'll be learning SQL and PHP. I just need a sandbox to play with. Can someone help me to get this setup?