Problems with MySQL database creation in Django

Question

I'm trying to set up MySQL database to use in my django project, but getting erroe that database do not exist. I understand that first I should create it in MySQL console so I tried it like this:

$ mysql --username=myuser --password=1111
mysql> CREATE DATABASE 'myDB' CHARSET utf-8

when I hit enter after line above I'm getting following line

->

I assume that database is not created. I tried to do this in my system terminal and also in my project environment

So my questions:

1. Why DB is not created with command above ?

2. How should I create DB?

3. Do I need to use this weird quote ` or can use simple one like this ' ?

you missing ";" at the end. CREATE DATABASE myDB CHARSET utf-8; — Yogesh dwivedi Geitpl
– Yogesh dwivedi Geitpl, Commented Oct 1, 2014 at 7:51

plaes · Accepted Answer · 2014-10-01 07:48:04Z

1

MySQL commands need to be finalised with ;

CREATE DATABASE 'myDB' CHARSET utf-8;

answered Oct 1, 2014 at 7:48

plaes

32.9k11 gold badges95 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problems with MySQL database creation in Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related