Previous Topic: Enabling Support for the InnoDB Transaction EngineNext Topic: Creating a Database User


Creating a New Database

To create a database:

  1. Open a MySQL command window.
  2. To create the database schema, run the following command :
    CREATE SCHEMA '<schema-name>' DEFAULT CHARACTER SET utf8;
    
  3. To create the database user, run the following command :
    CREATE USER '<user-name>' identified by '<user-password>';