Previous Topic: Setting the lower_case_table_names VariableNext Topic: Creating a Database User


Creating a 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>';