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.
请先登录再写评论。
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)...