The Oracle Commerce Platform supports the MySQL database for use in evaluation and development installations. You can use MySQL if you want to configure an Oracle Commerce Platform server quickly and you are not concerned about large-scale performance and reliability. Database configuration for production use requires more sophisticated preparation. Configuring databases for production use is covered in Configuring Databases and Database Access. This section provides information about quickly configuring a MySQL database for an evaluation or development server.
Note that the Oracle Commerce Platform installer does not create the actual schemas or import required data. Use the Configuration and Installation Manager (CIM) utility to perform these steps before using the databases to run an application. See Configuration and Installation Manager (CIM).
You can use a MySQL database for evaluation and development applications on any operating system that is supported by the Oracle Commerce Platform. To prepare a MySQL database for evaluating or developing Oracle Commerce Platform applications:
Install the MySQL server and MySQL client software. To find the required version, refer to the Oracle Commerce Supported Environments document in the My Oracle Support knowledge base.
Open the MySQL console as the root user. If you have installed the MySQL client software, you may be able to do this by invoking the
mysqlexecutable file.mysql -u root -pCreate the production core database, create a user account for the production core database, and give the user account access to the database.
mysql> create database production_core;
Query OK, 1 row affected (0.00 sec)
mysql> create user 'prod'@'localhost' identified by 'Welcome1';
Query OK, 0 rows affected (0.09 sec)
mysql> grant all on production_core.* to 'prod'@'localhost';
Query OK, 0 rows affected (0.01 sec)Create any other databases that your installation requires. For example, if you use ATG Content Administration, create the publishing database. Use the MySQL commands shown in the previous step.
See the MySQL database documentation for additional information (http://dev.mysql.com/doc/).
The following table lists the recommended MySQL database accounts and databases for Oracle Commerce.
Account Name | Database Name |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
