1 of 1

MySQL Plugin

Rotate and Connect to MySQL databases with Keeper Commander

Keeper has also launched a zero-trust Password Rotation feature with KeeperPAM. This new capability is recommended for most password rotation use cases. The Documentation is linked below:

Password Rotation with KeeperPAM
Commander

Prerequisites

Install PyMySQL

The MySQL Commander Plugin requires the PyMySQL plugin version 0.10.1 and does not support more recent versions.

Prepare Records for Rotation

Create a record to store the MySQL username and password

Create a record using either the Keeper Vault UI, or Keeper Commander.

Commander rotation supports all record types. A "Login" field is required on the record.

Set the Host and Port of the record

If using an untyped record, the host and port can be set to custom fields. See below.

Optional Custom Fields

Label

Value

Comment

For Commander versions greater than 4.88

For Commander versions 4.88 and before

for more information about the edit command, see the

Rotate Passwords

Get Record UID

Find the UID in the record information popup

Use the search command to find the UID for your record. Replace "MySQL Example" with the name of your record.

Perform Rotation

To rotate MySQL passwords, use the rotate command in Commander. Pass the command a record title or UID (or use --match with a regular expression to rotate several records at once)

The plugin can be supplied to the command as shown here added to a record field, or automatically assigned based on the port number or based on the host starting with "mysql://" (see options above). Adding the plugin type to the record makes it possible to rotate several records at once with different plugins.

Output

After rotation is completed, the new password will be stored in the Password field of the record

Integration with the Keeper Commander's `connect` command

Custom Field Name

Custom Field Value

xxx refers to the 'friendly name' which can be referenced when connecting on the command line

Here's a screenshot of the Keeper Vault record for this use case:

For more information on the connect command, see the

MySQL Plugin

Rotate and Connect to MySQL databases with Keeper Commander

Keeper has also launched a zero-trust Password Rotation feature with KeeperPAM. This new capability is recommended for most password rotation use cases. The Documentation is linked below:

Password Rotation with KeeperPAM
Commander

Prerequisites

Install PyMySQL

The MySQL Commander Plugin requires the PyMySQL plugin version 0.10.1 and does not support more recent versions.

Prepare Records for Rotation

Create a record to store the MySQL username and password

Create a record using either the Keeper Vault UI, or Keeper Commander.

Commander rotation supports all record types. A "Login" field is required on the record.

Set the Host and Port of the record

If using an untyped record, the host and port can be set to custom fields. See below.

Optional Custom Fields

Label

Value

Comment

For Commander versions greater than 4.88

For Commander versions 4.88 and before

for more information about the edit command, see the

Rotate Passwords

Get Record UID

Find the UID in the record information popup

Use the search command to find the UID for your record. Replace "MySQL Example" with the name of your record.

Perform Rotation

To rotate MySQL passwords, use the rotate command in Commander. Pass the command a record title or UID (or use --match with a regular expression to rotate several records at once)

Output

After rotation is completed, the new password will be stored in the Password field of the record

Integration with the Keeper Commander's `connect` command

Custom Field Name

Custom Field Value

xxx refers to the 'friendly name' which can be referenced when connecting on the command line

Here's a screenshot of the Keeper Vault record for this use case:

For more information on the connect command, see the

MySQL Plugin

hashtagPrerequisites

hashtagInstall PyMySQL

hashtagPrepare Records for Rotation

hashtagCreate a record to store the MySQL username and password

hashtagOptional Custom Fields

hashtagRotate Passwords

hashtagGet Record UID

hashtagPerform Rotation

hashtagOutput

hashtagIntegration with the Keeper Commander's connect command

MySQL Plugin

hashtagPrerequisites

hashtagInstall PyMySQL

hashtagPrepare Records for Rotation

hashtagCreate a record to store the MySQL username and password

hashtagOptional Custom Fields

hashtagRotate Passwords

hashtagGet Record UID

hashtagPerform Rotation

hashtagOutput

hashtagIntegration with the Keeper Commander's connect command

Prerequisites

Install PyMySQL

Prepare Records for Rotation

Create a record to store the MySQL username and password

Optional Custom Fields

Rotate Passwords

Get Record UID

Perform Rotation

Output

Integration with the Keeper Commander's `connect` command

Prerequisites

Install PyMySQL

Prepare Records for Rotation

Create a record to store the MySQL username and password

Optional Custom Fields

Rotate Passwords

Get Record UID

Perform Rotation

Output

Integration with the Keeper Commander's `connect` command