MySQL Database Installation and Configuration for Advanced Management Console

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:

Install the MySQL database server only and select Server Machine as the configuration type.
Select the option to run MySQL as a service.
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:

Install the MySQL database server package.

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

sudo service mysql start
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.
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';
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';
Configure your MySQL installation to handle large BLOB entries, such as AMC Agent (installation) bundle and MSI binaries. To handle BLOB entries, edit the my.cnf file. For more information, see MySQL Option Files.
To edit the my.cnf file:
1. Open the my.cnf file in an editor. 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
2. Set the options max_allowed_packet and innodb_log_file_size in the [mysqld] section to the values shown:
```
[mysqld]
max_allowed_packet=300M
innodb_log_file_size=768M
```
  Note:
  Ensure that there are no other values for max_allowed_packet and innodb_log_file_size that override the set value.
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 Data Source connection in the application server.