Oracle Cloud Infrastructure Documentation

Updating MySQL Studio Settings on the DB System

You can enable or disable MySQL Studio and update the port number assigned to the MySQL Studio endpoint.

Note

MySQL Studio cannot be enabled on high availablity DB systems.

Use one of the following methods to update the MySQL Studio settings on a standalone DB system:

Note

Updating MySQL Studio settings on a DB system is not supported by the oci mysql db-system update CLI command.

Using the Console

Use the Console to enable or disable MySQL Studio on a DB system, or to update the port number assigned to the MySQL Studio endpoint. By default, MySQL Studio is disabled.

This task requires a running standalone DB system.
Do the following to update MySQL Studio settings on a DB system:
  1. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.
    The details page opens and displays information about the DB system.
  2. Select the Tools tab.
  3. To enable MySQL Studio on the DB system if it is currently disabled, do the following:
    1. In the MySQL Studio field under the MySQL Studio section, select Enable.
    2. Optionally, in the Enable MySQL Studio pane that appears , specify a port number in the MySQL Studio port field to assign to MySQL Studio endpoint. Supported port numbers are: 443 and all port numbers between the range 1024 to 65535. If a port number is not specified, port number 8443 is assigned to the MySQL Studio endpoint by default. This field appears only when MySQL Studio is enabled. The specified port number must not be the same as the database port, database X protocol port, or the MRS port (if MRS is enabled).
    3. Click Enable.
    MySQL Studio is enabled.
  4. To disable MySQL Studio on the DB system if it is currently enabled, do the following:
    1. Click Edit next to the MySQL Studio field.
    2. In the Edit MySQL Studio pane, select Disable in the MySQL Studio field.
    3. Select Update.
    MySQL Studio is disabled, and all the files that were uploaded to the application are deleted.
  5. To edit the port number assigned to the MySQL Studio endpoint, do the following:
    1. Click Edit next to the MySQL Studio field.
    2. In the Edit MySQL Studio pane, specify the port number to assign to MySQL Studio endpoint in the MySQL Studio port field.
    3. Select Update.
    The port number assigned to the MySQL Studio endpoint is updated.