database:mysql:password

Differences

This shows you the differences between two versions of the page.


database:mysql:password [2021/03/11 10:22] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== MySql password and old_password ======
 +<code sql>
 +/* Old password type */
 +SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');
 +/* New password type */
 +SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('mypass');
  
 +ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password  BY 'mypass';
 +</code>
 +<code>
 +SHOW VARIABLES LIKE 'validate_password%';
 ++--------------------------------------+-------+
 +| Variable_name                        | Value |
 ++--------------------------------------+-------+
 +| validate_password.check_user_name    | ON    |
 +| validate_password.dictionary_file    |       |
 +| validate_password.length             | 6     |
 +| validate_password.mixed_case_count   | 1     |
 +| validate_password.number_count       | 1     |
 +| validate_password.policy             | LOW   |
 +| validate_password.special_char_count | 1     |
 ++--------------------------------------+-------+
 +SET GLOBAL validate_password.length = 6;
 +SET GLOBAL validate_password.number_count = 0;
 +</code>
  • database/mysql/password.txt
  • Last modified: 2021/03/11 10:22
  • by 127.0.0.1