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. This topic contains the following sections that describe software requirements and MySQL installation and configuration for the Advanced Management Console:. After you’ve installed MySQL, you can create a user and configure your database.
MySQL Community Server; MySQL Cluster; MySQL Installer; MySQL Workbench; MySQL Router; MySQL Utilities; MySQL Shell; MySQL Proxy; MySQL Connector/C; MySQL Connector/C++; MySQL Connector/J; MySQL Connector/Node.js; MySQL Connector/MXJ; MySQL Connector/NET; MySQL Connector/ODBC; MySQL Connector/PHP; MySQL Connector/PHP (mysqlnd) MySQL Connector. MySQL Cluster CGE (commercial) MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions.
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';.
![2012 2012](http://www.mysqltutorial.org//wp-content/uploads/2013/05/install-mysql-step-10.png)
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 handle BLOB entries, edit the. 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 in MySQL Reference Manual.
Set the options maxallowedpacket and innodblogfilesize in my.ini in the mysqld section to the values shown: mysqld maxallowedpacket=120M innodblogfilesize=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. Scripting on this page enhances content navigation, but does not change the content in any way.
MySQL Installer provides an easy to use, wizard-based installation experience for all your MySQL software needs. Included in the product are the latest versions of:. Choosing the right file:. If you have an online connection while running the MySQL Installer, choose the mysql-installer- web-community file.
If you do NOT have an online connection while running the MySQL Installer, choose the mysql-installer-community file. Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.
Online Documentation. and Please report any bugs or inconsistencies you observe to our. Thank you for your support!