![]() ![]() Set password = Password("%NEWPASSWORD%") ■ The following example displays the command used to change a user password on a MySQL server: To ensure that these variables will be used as values and not as part of the command, when possible enclose them with quotation marks, as shown in the example below. These variables will be replaced during run time with the appropriate values: The statement template can contain any number of the following variables enclosed with ‘%’ (percentage) sign. The legal SQL statement template that will be used to change the password on the required database.įor more details about platform parameters, refer to the Privileged Access Security Reference Guide. The following example displays a valid connection string on a MySQL Server: ■ĭriver= server=%ADDRESS% user=%USER% option=3 port=%PORT% Password=%LOGONPASSWORD% 3.Ĭreate a temporary DSN and use the testing options in the DSN to test the connection between the CPM machine and the database server.Ĭonfigure the Password Change SQL Statement for MySQL Passwordsĭuring installation a default SQL statement template is configured for each database vendor whose users will be managed by the CPM during a password change task. The password of the user who will replace the invalid password with the new password. The name of the user who will replace the invalid password with the new password. The port used by the CPM to access the remote machine. Password Object properties or, if not defined there, from the ExtraInfo section of the platform. The instance name is case-sensitive and must be specified exactly as it appears. If there are several instances on the same machine, specify the instance as part of the address as follows: The address of the database server where the password is used. Reconcile account password object properties This is either the current password or the password of the reconciliation account. The plug-in automatically detects the password to use for logon. The password that the plug-in uses for logon. The Connection String template may contain any number of the following variables enclosed with ‘%’ (percentage) sign. This parameter is required if the DSN parameter is not supplied either at policy level or password level, indicating that the connection method is DSN‑Less.įor more details about platform parameters, refer to the Privileged Access Security Reference Guide. The Connection String that will be used to connect to the database through ODBC. In the Additional Policy Settings section of the platform, check the value of the following required parameter: ![]() Connect to the Remote Database with a Connection String (DSN-less) 1. Note: Make sure that the DSN is a system DSN and not a User DSN. Use the testing option in the DSN to test the connection between the CPM machine and the database server. This plug-in supports the following connection methods to connect to remote databases: ■Ĭonnect to the Remote Database with DSN 1.Ĭreate a System DSN for each database in the CPM machine. If the machine does not support this version of ODBC, download the mysql-connector-odbc-3.51.28-win32.msi from the MySQL downloads site: Connection Methods The machine that runs the CPM must support ODBC, version 3.51.28 (32-bit). MySQL ODBC 3.51 Driver or MySQL ODBC 5.3 Unicode Driver (recommended) The following driver is required on the CPM machine: ■ ![]() In the Platform Management page, make sure that the following target account platform is displayed. The CPM supports remote password management on a MySQL Server on the following platforms: ■ Automatic password management is supported on MySQL Server accounts on IPv4 and IPv6. ![]()
0 Comments
Leave a Reply. |