Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR on create Database #1

Open
AhmadrezaMozaffary opened this issue Feb 14, 2022 · 1 comment
Open

ERROR on create Database #1

AhmadrezaMozaffary opened this issue Feb 14, 2022 · 1 comment

Comments

@AhmadrezaMozaffary
Copy link

Hi,
I have an issue with create database with sql command in VScode, Could you please help me ?

I do this :
CREATE DATABASE talently;

and it returns this error:
Request connection/GetChildrenForTreeItemRequest failed with message: ER_BAD_DB_ERROR: Unknown database 'default'

I tried to change th DB name to talently but I saw the same resault :(

@ahm1371ahm
Copy link

That's because your database system does not hold a database called default. Before connecting to your database in VSCode, you should create a database named 'talently' in your database system's CLI or GUI tools. For example, if you use MySQL, you may open MySQL Workbench and create a database there by this command:

CREATE DATABASE talenly;

Then go to VSCode and try to connect to your database again (by means of SQLTools plugin). Similarly, if you desire to use PostgreSQL, you should open pgAdmin and create a database there by the command above.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants