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:
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 a User and Configuring MySQL on Windows
To create a user and configure MySQLon Windows:
-
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';
-
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';
-
Configure your MySQL installation to handle large
BLOB
entries, such as MSI binaries. To handleBLOB
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:-
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:
As of MySQL 5.7.18,my-default.cnf
is no longer included in or installed by distribution packages. See Server Configuration Defaults in MySQL Reference Manual. -
Set the options
max_allowed_packet
andinnodb_log_file_size
inmy.ini
in the[mysqld]
section to the values shown:[mysqld] max_allowed_packet=120M innodb_log_file_size=768M
-
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.