TencentDB for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Database Architecture
- Database Instance
- Kernel Features
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Parallel Query
- Security Features
- Stability Features
- Purchase Guide
- Getting Started
- Connecting to MySQL Instance
- Database Audit
- Audit Rule Template
- MySQL Cluster Edition
- Maintenance Management Instance
- Operation Guide
- Instance Management and Maintenance
- Instance Upgrade
- CPU Elastic Expansion
- Read-Only/Disaster Recovery Instances
- Database Proxy
- Database Proxy Kernel Features
- Database Proxy Management
- Automatic Read/Write Separation Feature
- Connection Pool Feature
- Other Features
- Account Management
- Database Management Center (DMC)
- Parameter Configuration
- Network and Security
- Backup and Rollback
- Restoring Database from Backup File
- Monitoring and Alarms
- Operation Logs
- Practical Tutorial
- Calling MySQL APIs in Python
- White Paper
- Performance White Paper
- Performance Test Report
- Troubleshooting
- Connections
- API Documentation
- Data Import APIs
- Rollback APIs
- Parameter APIs
- Making API Requests
- Instance APIs
- Database Proxy APIs
- Database Audit APIs
- Security APIs
- Account APIs
- Backup APIs
- Database APIs
- Monitoring APIs
- Log-related API
- FAQs
- Backup
- Connection and Login
- Instance Upgrade
- Performance and Memory
- Service Agreement
- Reference
Setting Password Complexity
Last updated: 2024-07-22 15:27:34
TencentDB for MySQL allows you to set the password complexity to improve the strength of database access passwords and optimize the database security.
Prerequisites
The database version is:
MySQL 5.6, with minor version 20201231 or later.
MySQL 5.7, with minor version 20201231 or later.
MySQL 8.0, with minor version 20201230 or later.
The instance must be on a two-node/three-node architecture.
Use Limits
For any password set during account creation or reset in the TencentDB for MySQL console, it must at least meet the following initial account password requirements:
It can contain 8 to 64 characters
It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special symbols.
Special characters are
_+-&=!@#$%^*().Enabling Password Complexity
Note:
After the password complexity feature is enabled, any password set during account creation or reset must follow the password complexity policy.
Enabling when creating an instance on the purchase page
1. Log in to the TencentDB for MySQL purchase page.
2. Configure parameters as needed. Select Enable after the Password Complexity parameter.
3. Set the following parameters.
Parameter | Description |
Min Number of Uppercase or Lowercase Letters | You can select a number between 1 (default value) and 16. |
Min Number of Digitals | You can select a number between 1 (default value) and 16. |
Min Number of Symbols | You can select a number between 1 (default value) and 16. |
Min Number of Password Characters | You can select a number between 8 (default value) and 64. The minimum value must be greater than the sum of the above three parameters. |
Enabling for existing instances in the console
1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
2. On the instance management page, select Database Management> Account Management and click Password Complexity (disabled by default).
3. Select Enable in the Password Complexity pop-up window, set the following parameters, and click OK.
Parameter | Description |
Min Number of Uppercase or Lowercase Letters | You can select a number between 1 (default value) and 16. |
Min Number of Digitals | You can select a number between 1 (default value) and 16. |
Min Number of Symbols | You can select a number between 1 (default value) and 16. |
Min Number of Password Characters | You can select a number between 8 (default value) and 64. The minimum value must be greater than the sum of the above three parameters. |
Disabling Password Complexity
1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
2. On the instance management page, select Database Management> Account Management and click Password Complexity.
3. Select Disable in the Password Complexity pop-up window and click OK.
Relevant Documentation
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No