MySQL 8 Cookbook

How to do it...

Connect to the MySQL server:

shell> mysql -u root -pEnter Password:mysql> CREATE DATABASE company;mysql> CREATE DATABASE `my.contacts`;

The back tick character (`) is used to quote identifiers, such as database and table names. You need to use it when the database name contains special characters, such as dot (.).

You can switch between databases:

mysql> USE companymysql> USE `my.contacts`

Instead of switching, you can directly connect to the database you want by specifying it in the command line:

shell> mysql -u root -p company

To find which database you are connected to, use the following:

mysql> SELECT DATABASE();+------------+| DATABASE() |+------------+| company    |+------------+1 row in set (0.00 sec)

To find all the databases ...