Loading...

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.

Procedure

  1. From the navigation pane, go to Solutions > Databases > DB Instances.

    The Instances page appears.

  2. Click Add instance > MySQL.

    The Add MySQL instance dialog box appears.

  3. From the Server name list, select the server where you want to create the instance.
  4. In the Instance name box, type a name for the instance.
  5. In the Database user box, type the user name to access the MySQL application.
  6. In the Password box, type the password to access the MySQL application.
  7. If you are using a Linux platform, then in the UNIX username box, type the Linux operating system user name.
  8. In the Socket file box, enter the path to the socket file.
  9. In the Binary Directory box, enter the path to the directory where the MySQL application files are stored.
  10. In the Log Data Directory box, enter the path to the directory where the log files are stored.
  11. 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
  12. From the Plan list, select a server plan.
  13. Click Add.

Last modified: 10/23/2019 4:35:42 AM