Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This Developer Center contains the guides for Commerce 6.13.0 through 7.4.1.Visit new site

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

Creating the Database in MySQL 5.x

Creating the Database in MySQL 5.x

Creating the Database

  1. In the command prompt, open MySQL:
    mysql -u root -p
    
  2. In MySQL, enter the following command to create a database:
    create database COMMERCEDB character set utf8;
    
    Note:

    When starting fresh with Elastic Path 7.4.1, it is recommended you name the database schema COMMERCEDB. This will make configuring Liquibase simpler, as this has been set as the default.

  3. Enter the following command to create a user that has complete access to COMMERCEDB:
    grant all privileges on COMMERCEDB.* to ep@'localhost' identified by 'ep';
    
    Note:

    ep/ep is the default username/password combination used by Elastic Path.

Table Name Case Sensitivity

On Unix systems, table names in SQL queries may be case sensitive. To turn off case sensitivity, refer to the MySQL reference manual here:http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.htmlIn most cases this means adding the line lower_case_table_names under the section [mysqld] in /etc/mysql/my.cnf.