new mysql database
So i install the driver, make a DB, it asks me for a username and password, well I put in the one i put in the project data source but it tells me the username/password combo is incorrect. I'm not sure where to change or find the username and password so i can edit and access the db i made in php storm. I'm not connecting to an already made one, i'm making one in phpstorm.
Please sign in to leave a comment.
Hi there,
Currently Database support in PhpStorm only works with already existing databases/schemas (be it empty or if it has some tables there already).
What I mean is -- you can create new Data Source in Database tool window without specifying actual database/schema name ... but you cannot create actual database/schema there (no such GUI) -- https://youtrack.jetbrains.com/issue/DBE-499
But .. once Data Source is created and connected in PhpStorm .. you can open SQL Console and execute command there -- MySQL allows creating new schema via DDL (e.g. "CREATE DATABASE z1;" -- I've tested and it works (if user is "root" :) )). Not sure of your db user will have enough rights to do that though (considering that normally if you have just user name and password it's a limited user that can work with specific database only and not root or alike user with broad admin rights)...