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 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 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.

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 use 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 ATG11.0 > 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. 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 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 must install and configure MySQL yourself.

To prepare a MySQL database for evaluating or developing Oracle ATG Web Commerce applications;


Copyright © 1997, 2014 Oracle and/or its affiliates. All rights reserved. Legal Notices