Your password does not meet current policy requirements

I want to create a new user in MySQL with the syntax:

create user 'demo'@'localhost' identified by 'password';

But it returns an error:

Your password does not meet the requirements of the current policy.

I tried many passwords, but they do not work. How can i fix this?

+89
source share
16 answers

Because of your password. You can see the password verification configuration parameters using the following query in the MySQL client:

SHOW VARIABLES LIKE 'validate_password%';

or you can set the password policy level below, for example:

SET GLOBAL validate_password_length = 6;
SET GLOBAL validate_password_number_count = 0;

You are checking the MySQL documentation .

+136
source

. . , . .

, "mysql_secure_installation" "medium".

, :

mysql -h localhost -u root -p
mysql>uninstall plugin validate_password;

, "validate_password".

+53

, . LOW, mysql:

mysql> SET GLOBAL validate_password_policy=LOW;
+33

sudo mysql_secure_installation.

  1. sudo mysql mysql.
  2. SELECT user,authentication_string,plugin,host FROM mysql.user; root auth_socket.
  3. uninstall plugin validate_password; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; .

: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04 .

+16

MySQL 8 *

SET GLOBAL validate_password.policy=LOW

, -

+12

, "validate_password_policy" "" " " . ( ). , , .

, mysql: SHOW VARIABLES LIKE 'validate_password%', @JNevill. "validate_password_policy" Medium, . : Validate Password Policy

. ( ):

  • 8
  • 1 ( 1 1 )
  • 1
  • 1

, . :

  • Student123 @
  • NINZAcoder $ 100
  • demoPass # 00

, .

"validate_password_policy" ( "HIGH").

+4

mysql LOW.

root

mysql -u root -p

SET GLOBAL validate_password_policy=LOW;

exit

MySQL

sudo service mysqld restart
+3

1. .

SHOW VARIABLES LIKE 'default_authentication_plugin';

2:

SHOW VARIABLES LIKE 'validate_password%';

3:

CREATE USER '<your_user>'@'localhost' IDENTIFIED WITH '<your_default_auth_plugin>' BY 'password';
+2

, , , mysql,

sudo mysql_secure_installation

- ,

:

> = 8 > = 8, , STRONG > = 8, , ,

, 0 = , 1 = 2 = :

:
0: abcdabcd
1: abcd1234
2: ancd@1234

+1

, . , .

, .

mysql-> SHOW VARIABLES LIKE 'validate_password%';

, validate_password_length, validate_password_number_count validate_password_policy.

, . , validate_password_length 6. 6, .

SET GLOBAL validate_password_length = 6;

validate_password_number_count 0. , .

SET GLOBAL validate_password_number_count = 0;

, validate_password_policy low. Medium High . low .

SET GLOBAL validate_password_policy=LOW;
+1

mysql> 'admin' @'localhost', 'Admin123'; 1819 (HY000):

mysql> validate_password; , 0 , 1 (0,05 )

mysql> 'admin' @'localhost', 'admin'; , 0 (0,05 )

0

Ubuntu 18.04.1 LTS: mysql Ver 14.14 Distrib 5.7.24, Windows 10 1809 (WSL).

, root.

validate-password=off /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld]

[mysqld]
#
# * Basic Settings
# * Another Settings
#
validate-password=off

MySQL.

service mysql restart

, MySQL

mysql -h localhost -u root -p
0

. , ( SQL)

" ('123456789')"

" (" A123456789 ")"

" ('A! 123456789')"

" ('A! a123456789')"

. + , , .

my.cnf, !

[mysqld] :

validate_password_policy=LOW
validate_password_special_char_count=0
validate_password_length=0
validate_password_mixed_case_count=0
validate_password_number_count=0
0

Laravel, MySQL 8.0.x,

'modes'=> [
             'ONLY_FULL_GROUP_BY',
             'STRICT_TRANS_TABLES',
             'NO_ZERO_IN_DATE',
             'NO_ZERO_DATE',
             'ERROR_FOR_DIVISION_BY_ZERO',
             'NO_ENGINE_SUBSTITUTION',
            ],

database.php, :

// database.php

    'connections' => [

        'mysql' => [
            'driver'      => 'mysql',
            'host'        => env( 'DB_HOST', '127.0.0.1' ),
            'port'        => env( 'DB_PORT', '3306' ),
            'database'    => env( 'DB_DATABASE', 'forge' ),
            'username'    => env( 'DB_USERNAME', 'forge' ),
            'password'    => env( 'DB_PASSWORD', '' ),
            'unix_socket' => env( 'DB_SOCKET', '' ),
            'charset'     => 'utf8mb4',
            'collation'   => 'utf8mb4_unicode_ci',
            'prefix'      => '',
            'strict'      => true,
            'engine'      => null,
            'modes'       => [
                'ONLY_FULL_GROUP_BY',
                'STRICT_TRANS_TABLES',
                'NO_ZERO_IN_DATE',
                'NO_ZERO_DATE',
                'ERROR_FOR_DIVISION_BY_ZERO',
                'NO_ENGINE_SUBSTITUTION',
            ],
        ],
    ],

.

0

MySql 8 :

SET GLOBAL validate_password.LENGTH = 4;
SET GLOBAL validate_password.policy = 0;
SET GLOBAL validate_password.mixed_case_count = 0;
SET GLOBAL validate_password.number_count = 0;
SET GLOBAL validate_password.special_char_count = 0;
SET GLOBAL validate_password.check_user_name = 0;
ALTER USER 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;
0

mysqld ubuntu, /etc/mysql/mysql.conf.d/mysqld.cnf, (, , plugin-load-add)

plugin-load-add=validate_password.so
validate_password_policy=LOW
validate_password_length=8
validate_password_mixed_case_count=0
validate_password_number_count=0
validate_password_special_char_count=0
0

Source: https://habr.com/ru/post/1016140/


All Articles