Properly planned MySQL Password Management is the first step to protect your database<\/span><\/h1>\n

---

\n

We at MinervaDB provide MySQL and \u00a0MariaDB Database Security Audit (Please read about our Security Practice at MinervaDB Consulting Page<\/a><\/span><\/strong>) for our customers globally, We don’t go easy with password management .. Weaker passwords are serious security threats and we highly recommend stronger passwords. Technically Password Validation\u00a0<\/em>is about the policies that every new password must comply and this task is taken care by validate_password\u00a0<\/strong>component in MySQL, You have several system variables to configure\u00a0validate_password\u00a0<\/strong>component and status variables to monitor<\/span><\/p>\n

To use\u00a0validate_password\u00a0<\/strong>component you must install it first:<\/p>\n

Verify if\u00a0validate_password\u00a0<\/strong>component is installed:<\/p>\n

mysql> select * from mysql.component;\r\n\r\nEmpty set (0.00 sec)<\/pre>\n
We have successfully verified validate_password\u00a0component is not installed \ud83d\udc46<\/p>\n
Install validate_password<\/strong> component next and confirm:<\/p>\n
mysql> INSTALL COMPONENT 'file:\/\/component_validate_password';\r\n\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> select * from mysql.component;\r\n\r\n+--------------+--------------------+------------------------------------+\r\n\r\n| component_id | component_group_id | component_urn\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n+--------------+--------------------+------------------------------------+\r\n\r\n|\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4 |\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4 | file:\/\/component_validate_password |\r\n\r\n+--------------+--------------------+------------------------------------+\r\n\r\n1 row in set (0.00 sec)\r\n\r\n<\/pre>\n
\n
\n
Table of Contents<\/p>\n<\/i><\/a><\/span><\/div>\n