3 MySQL Database Installation and Configuration for Advanced Management Console

The database for the Advanced Management Console provides data storage to host all the data. The database stores information about MSI files and applications, deployment rules, and deployment rule sets. The database also stores information about agents, Java Runtime Environment (JRE) statistics, and Java Installer configurations.

The Advanced Management Console is also supported on Oracle Database.

This topic contains the following sections that describe software requirements and MySQL installation and configuration for the Advanced Management Console:

Software Requirements for MySQL Database

To use MySQL database with Advanced Management Console, download and install a version of MySQL Server mentioned in Software Prerequisites and System Requirements for Advanced Management Console Components.

Installing MySQL Database for Advanced Management Console

This topic contains the following sections that describe MySQL installation and configuration setup instructions for Advanced Management Console on different platforms:

Installing MySQL Database on Windows

To install MySQL database:

  1. Install the MySQL database server only and select Server Machine as the configuration type.

  2. Select the option to run MySQL as a service.

  3. Launch the MySQL Command-Line Client. To launch the client, enter the following command in a Command Prompt window: mysql -u root -p .

    The -p option is needed only if a root password is defined for MySQL. Enter the password when prompted.

MySQL is installed and you can begin to configure your database.

Installing and Configuring MySQL on Linux

The following are example instructions to install and configure MySQL database for the Oracle Linux distribution of Linux operating system:

  1. Install the MySQL database server package.

    You can use the Yum tool to install MySQL on Oracle Linux: sudo yum install mysql-community-server.

  2. Start the MySQL service:

    sudo service mysql start

  3. Launch the MySQL Command-Line Client:
    mysql -u root -p

    The -p option is needed only if a root password is defined for MySQL. Enter the password when prompted.

  4. Create a user (for example, amc2) and a strong password:

    mysql> create user 'amc2' identified by 'amc2';

    To restrict the access to a machine (for example, to localhost for a user) create the user as follows:

    mysql> create user 'amc2'@'localhost' identified by 'amc2';

  5. Create the database (for example, amc2) and grant all access to the user, for example, amc2 as follows:

    mysql> create database amc2;

    mysql> grant all on amc2.* to 'amc2';

  6. Configure your MySQL installation to handle large BLOB entries, such as MSI binaries. To handle BLOB entries, edit the my.cnf file.

    You can find the my.cnf file in one of the following locations:

    • /etc/my.cnf

    • /etc/mysql/my.cnf

    • $MYSQL_HOME/my.cnf

    • [datadir]/my.cnf

  7. Set the options max_allowed_packet and innodb_log_file-size in the [mysqld] section to the values shown:
    [mysqld]
    max_allowed_packet=120M
    innodb_log_file_size=768M
    

The MySQL database user credentials provided in this topic are examples. The Advanced Management Console doesn’t need to know your MySQL database user credentials. MySQL database user credentials are only required to configure the DataSource connection in the application server.

Creating User and Configuring MySQL on Windows

After you’ve installed MySQL, you can create a user and configure your database.

To create and configure MySQL in a Windows environment:

  1. Create the user (for example, amc2) and a strong password:

    mysql> create user 'amc2' identified by 'amc2';

    To restrict access to a machine (for example, to localhost for a user) create the user as follows:

    mysql> create user 'amc2'@'localhost' identified by 'amc2';

  2. Create the database (for example, amc2) and grant all access to the user (for example, amc2 user):

    mysql> create database amc2;

    mysql> grant all on amc2.* to 'amc2';

  3. Configure your MySQL installation to handle large BLOB entries, such as MSI binaries. To handle BLOB entries, edit the MySQL Option Files.

    MySQL is a Windows Service, so it can be started or stopped from the Windows Service administrator page. Any updates to the my.ini MySQL option file must be done by the administrator.

    To edit the my.ini file:

    1. Open the my.ini file in an editor. You must edit the file with administrator privileges.

      By default, on MySQL 5.6, the option file is located at %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini.

      Note:

      The Advanced Management Console supports both MySQL 5.6 and MySQL 5.7. Oracle recommends that you use the latest update of MySQL 5.6 or 5.7.
    2. Set the options max_allowed_packet and innodb_log_file_size in my.ini in the [mysqld] section to the values shown:

      [mysqld]
      max_allowed_packet=120M
      innodb_log_file_size=768M
      
    3. Restart the MySQL service to apply changes.

The MySQL database user credentials provided in this topic are examples. The Advanced Management Console doesn’t need to know your MySQL database user credentials. MySQL database user credentials are only required to configure the DataSource connection in the application server.