Adding a MySQL Database Instance
When you need to manage a MySQL database, add an instance for the database.
When you add an instance, a default database group is automatically created. The default database group includes all the data in the MySQL database.
Note: You cannot delete the default database group.
About This Task
When you discover MySQL instances, the newly discovered instances are assigned a plan as follows:
- If the MySQL server is installed from the Command Center, then the newly discovered instances inherit the plan of the server.
- If the MySQL server is not installed from the Command Center, then you must set a plan for the newly discovered instances.
- From the navigation pane, go to Protect > Databases.
The Instances page appears.
- Click Add instance > MySQL.
The Add MySQL instance dialog box appears.
- From the Server name list, select the server where you want to create the instance.
- In the Instance name box, type a name for the instance.
- In the Database user box, type the user name to access the MySQL application.
- In the Password box, type the password to access the MySQL application.
- If you are using a Linux platform, then in the UNIX username box, type the Linux operating system user name.
- In the Socket file box, enter the path to the socket file.
- In the Binary Directory box, enter the path to the directory where the MySQL application files are stored.
- In the Log Data Directory box, enter the path to the directory where the log files are stored.
- In the Configuration file box, enter the path to the configuration file as shown in the following examples:
- Windows: C:\Program Files\MySQL\MySQL Server 5.5\my.ini
- UNIX: /etc/my.cnf
- From the Plan list, select a server plan.
- Click Add.
Last modified: 2/27/2021 10:52:34 AM