CODEWITHSUNDEEP
mysqlphpstorm
yoni
yoni

Reputation: 25

How to create MySQL DB in PhpStorm?

I am trying to create a new MySQL DB in PhpStorm, but when I add table to information_schema I get this error:

Access denied for user ''@'localhost' to database 'information_schema'

In addition, when I create a new DB and test connection I get this pop-up window:

The specified user/password combination is rejected: "[42000][1044] Access denied for user ''@'localhost' to database 'db'"

and I don't have password.

Upvotes: 0

Views: 2287

Answers (1)

Deathstorm
Deathstorm

Reputation: 847

First of all the information_schema Database is the MySQL system schema. You shouldn't try to edit this Database

If you want to create a new table you should create that table in a new database. If your credentials are right you're able to create new databases running the following command in the console of your MySQL environment.

create database <database_name>

Upvotes: 1

Related Questions