Previous Topic: Enabling Support for the InnoDB Transaction EngineNext Topic: AM_7.1--Creating a Database User (MySQL)


Creating a New Database

To create a database:

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