Oracle ATG Web Commerce supports the MySQL database for use in evaluation and development installations. The Oracle ATG Web Commerce platform installer for Microsoft Windows will automatically install MySQL. You can also use the MySQL database on other operating systems but you will have to install and configure it yourself.
Use the MySQL database if you want to configure an Oracle ATG Web Commerce 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 ATG Web Commerce platform installer for Microsoft Windows can also install the MySQL database. The MySQL database is preconfigured with the user accounts that you will need to configure an evaluation or development application.
To install MySQL with the Oracle ATG Web Commerce platform, choose it from the list of products on the Select Products to Install screen of the installer wizard.
The Oracle ATG Web Commerce platform installer does not create the actual schemas or import required data. Use the Oracle ATG Web Commerce 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, choose ATG10.1.1 > Tools > Start MySQL Server from the programs section of the Windows Start menu.
The following table lists the MySQL database accounts and databases that the Oracle ATG Web Commerce platform installer creates for Microsoft Windows installations.
Account Name | Password | Database Name |
|---|---|---|
prod | Welcome1 | production_core |
pub | Welcome1 | publishing |
switchA | Welcome1 | switchinga |
switchB | Welcome1 | switchingb |
agent | Welcome1 | agent |
dw | Welcome1 | datawarehouse |
The Oracle ATG Web Commerce installation program does not set a password for the root MySQL user. You can log in as the root user without specifying a password. See information about administering a MySQL database in the documentation for that product (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 Oracle ATG Web Commerce. However, the MySQL database software is only included with the Microsoft Windows version of the installer program. If you install Oracle ATG Web Commerce on an operating system other than Microsoft Windows, you will have to install and configure MySQL yourself.
To prepare a MySQL database for evaluating or developing Oracle ATG Web Commerce applications;
Install the MySQL server and MySQL client software. To find the required version, refer to the Oracle ATG Commerce Supported Environments Matrix document in the My Oracle Support knowledge base (https://support.oracle.com/).
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 will 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.
