Learn MySQL (ii) common directives

Environment construction OK. Visual view I look at the face of a crazy, or command line learning.

Common directives:

1. Login:

MYSQL-H host name-u user name-P

Note: The native localhost, the-h section can be omitted. If you do not write the password after-p, wait for the command line prompt to enter the password before entering. or write the password directly, then-p followed by the password, no space:

Mysql-u root-p123456

2. View the existing database:

show databases;

Note: semicolon; must have

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| MySQL |
| Performance_schema |
| Sakila |
| SYS |
| World |
+--------------------+

3. Create a Database

Create Database MyDatabaseName;

Learn MySQL (ii) common directives