The Oracle Commerce Platform supports the MySQL database for use in evaluation and development installations. The Oracle Commerce Platform installer for Microsoft Windows automatically installs MySQL. You can also use the MySQL database on other operating systems but you must install and configure it yourself.
Use the MySQL database 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.
See information about using MySQL on Microsoft Windows in MySQL Installed on Microsoft Windows.
See information about using MySQL on other operating systems in Installing MySQL on Other Operating Systems.
MySQL Installed on Microsoft Windows
The Oracle Commerce Platform installer for Microsoft Windows can also install the MySQL database. The MySQL database is preconfigured with the user accounts that you use to configure an evaluation or development application.
To install MySQL with the Oracle Commerce Platform, choose it from the list of products on the Select Products to Install screen of the installer wizard.
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).
To start the MySQL database that is included in a Microsoft Windows installation, select Start > All Programs > Oracle Commerce Platform 11.1 > Tools > Start MySQL Server.
The following table lists the MySQL database accounts and databases that the Oracle Commerce Platform installer creates for Microsoft Windows installations.
Account Name | Password | Database Name |
|---|---|---|
| Welcome1 |
|
| Welcome1 |
|
| Welcome1 |
|
| Welcome1 |
|
| Welcome1 |
|
| Welcome1 |
|
The Oracle Commerce Platform installation program does not set a password for the root MySQL user. You can log in as the root user without specifying a password. Additionally, the default MySQL database does not support i18n content. See information MySQL database documentation for additional information (http://dev.mysql.com/doc/).
Installing MySQL on Other Operating Systems
You can use the MySQL database for evaluation and development applications on any operating system that is supported by the Oracle Commerce Platform. However, the MySQL database software is only included with the Microsoft Windows version of the installer program. If you install the Oracle Commerce Platform on an operating system other than Microsoft Windows, you must install and configure MySQL yourself.
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 a list of database types and suggested names in MySQL Installed on Microsoft Windows.
