SolutionBase: Configuring a simple database in MySQL 5.0

Do not begin the name of your schema with the word "test". All such schemas are assumed to be test databases, and are accessible to all users by default!

To create a database using the command line client program, connect to the MySQL server, and type the command:

CREATE DATABASE coop;

The command CREATE SCHEMA can also be used, and is. The semicolon at the end of the command is required in the command line client.

Create database tables and indexes

Once the schema is created, tables can be defined within it. In MySQL Administrator, click the Create Table button to bring up the Table Editor as seen above.