Tutorial for MySQL An Introduction to Java Programming
Using MySQL
By default, the server contains two databases named mysql and test. You can see these two databases displayed in Figure 1.3 using the command show databases. The show databases command displays all available databases in the MySQL database server.
<side remark: create database>
The mysql database contains the tables that store the information about the server and its users. This database is intended for the server administrator to use. For example, the administrator can use it to create users and grant or revoke user privileges. Since you are the owner of the server installed on your system, you have full access to the mysql database. However, you should not create user tables in the mysql database. You can use the test database to store data or create new databases. You can also create a new database using the command create database databasename or drop an existing database using the command drop database databasename.