create a database

dotKer

Member
(1) I installed xubuntu.
(2) I installed Apache.
(3) I installed PHP
(4) I installed mySQL

The php version is 7.2. and the below shows the version of the Apache and mySQl.
[email protected]:/$ apachectl -v
Server version: Apache/2.4.29 (Ubuntu)
Server built: 2019-08-26T13:41:23
[email protected]:/$ mysql --version
mysql Ver 14.14 Distrib 5.7.27, for Linux (i686) using EditLine wrapper
I am going to mysql with the code below.
[email protected]:/$ mysql -u root --password
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \\g.
Your MySQL connection id is 13
Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
And I am checking whether the mysql work correctly or not with the below.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
So far, so good.
Now I like to create a test database for testing.
mysql> CREATE DATABASE 'testDB';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''testDB'' at line 1
mysql> CREATE DATABASE 'testDB' DEFAULT CHARACTER SET utf8 COLLATE utf8__general_ci;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''testDB' DEFAULT CHARACTER SET utf8 COLLATE utf8__general_ci' at line 1
The quote above shows It doesn't create the database "testDB".

What's wrong with it?

Can I make a new database with your help?

Why doesn't it work?

Where is the manual for this?
 


alkion

Member
Last edited:

Members online


Latest posts

Top