(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.
Now I like to create a test database for testing.
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?
(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.
I am going to mysql with the code below.dotker@dotker:/$ apachectl -v
Server version: Apache/2.4.29 (Ubuntu)
Server built: 2019-08-26T13:41:23
dotker@dotker:/$ mysql --version
mysql Ver 14.14 Distrib 5.7.27, for Linux (i686) using EditLine wrapper
And I am checking whether the mysql work correctly or not with the below.dotker@dotker:/$ 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.
So far, so good.mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
Now I like to create a test database for testing.
The quote above shows It doesn't create the database "testDB".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
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?