Update connection information for a monitored database instance
If connection information changes for one of your monitored database instances, you must update that information in DPA.
If you registered a MySQL database instance in DPA 2024.3 or earlier, DPA uses the MariaDB driver to connect to the MySQL instance, which does not support the caching_sha2_password authentication plugin. For these instances, the Update Connection dialog includes the MySQL Driver option. If you want to use the caching_sha2_password authentication plugin for an existing MySQL instance, complete the following steps and select MySQL Driver.
After you select this option and DPA has successfully connected with the MySQL JDBC driver, the option is no longer displayed and you cannot change back.
- From the DPA menu in the upper-right corner, click Options.
- Under Monitor Setup > Database Instances, click Update Connection.
- Select the database instance, and click Next.
- Select the checkbox next to the property, update the value, and click Next.
For database-specific connection information, see the following:
- Oracle
- SQL Server
- Sybase
- Db2
- MySQL or Percona
- MariaDB
- PostgreSQL
- Amazon RDS for Oracle
- Amazon RDS for SQL Server
- Amazon RDS for MySQL
- Amazon RDS for MariaDB
- Azure SQL Database
- Azure SQL Managed Instance
- Azure Database for MySQL
- Azure Database for MariaDB
- SQL Server running in the Google Cloud Platform
- MySQL running in the Google Cloud Platform
- Confirm the connection information, and click Update Connection.
- Click Finish, or Update Another Database Instance to continue updating.