{"id":7481,"date":"2018-05-29T09:00:03","date_gmt":"2018-05-29T01:00:03","guid":{"rendered":"http:\/\/rmohan.com\/?p=7481"},"modified":"2018-05-29T09:00:48","modified_gmt":"2018-05-29T01:00:48","slug":"7481","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7481","title":{"rendered":"ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement."},"content":{"rendered":"

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.<\/h3>\n
\n
<\/div>\n<\/div>\n
\n
\n

Create a user in Mysql in linux<\/b><\/p>\n

login to mysql as a root<\/p>\n

mysql -u root -p<\/b><\/p>\n

now create user with following command<\/p>\n

CREATE USER ‘testdb’@’localhost’ IDENTIFIED BY ‘test123’;<\/b><\/p>\n

if you got error like below.<\/p>\n<\/div>\n<\/div>\n

<\/div>\n
\"\"<\/a><\/div>\n
<\/div>\n
then you have to reset the root password as password policy level in mysql. so simply use the below command to set the password for root in mysql.
\n
\n<\/b>ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Root@1234’;<\/b>then it will show like “Query OK, 0 rows affected (0.00 sec)”<\/p>\n

now try again the step to create user as per the password policy.<\/p>\n

If you don’t want password policy and you want to create user password with some random simple password then follow the step below.<\/p>\n

login mysql as root
\n
\n<\/b>mysql -u root -p<\/b><\/p>\n

then check the policy status with below command
\n
\n<\/b>SHOW VARIABLES LIKE ‘validate_paswword%’;<\/b><\/p>\n

it will show like below image.<\/p>\n<\/div>\n

<\/div>\n
<\/div>\n
<\/div>\n
\"\"<\/a><\/div>\n
<\/div>\n
\n

you can see the validate_password_policy in MEDIUM.<\/p>\n

now you have to change to LOW. So you can proceed in your own way. Now set the paoly rule in low with following command.
\n
\n<\/b>SET GLOBAL validat_password_policy=LOW;<\/b><\/p>\n<\/div>\n

<\/div>\n
<\/div>\n
\"\"<\/a><\/div>\n
<\/div>\n
<\/div>\n
\"\"<\/a><\/div>\n
<\/div>\n
now check the password policy like above. You will get like below image.<\/div>\n
<\/div>\n
\n

mysql> SET GLOBAL validate_password_length = 4;
\nQuery OK, 0 rows affected (0.01 sec)<\/p>\n

mysql> SHOW VARIABLES LIKE ‘validate_password%’;
\n+————————————–+——–+
\n| Variable_name | Value |
\n+————————————–+——–+
\n| validate_password_dictionary_file | |
\n| validate_password_length | 4 |
\n| validate_password_mixed_case_count | 1 |
\n| validate_password_number_count | 1 |
\n| validate_password_policy | MEDIUM |
\n| validate_password_special_char_count | 1 |
\n+————————————–+——–+
\n6 rows in set (0.00 sec)<\/p>\n

mysql> SET GLOBAL validate_password_policy = LOW;
\nQuery OK, 0 rows affected (0.01 sec)<\/p>\n<\/div>\n

 <\/p>\n

\n
Performance schema is not installed by default.<\/div>\n<\/div>\n
\n
\n

For checking, you can run the command<\/p>\n

SHOW VARIABLES <\/span>LIKE<\/span> 'performance_schema'<\/span>;<\/span><\/code><\/pre>\n
Suppose, now you will see OFF<\/p>\n
To enable it, start the server with the performance_schema variable enabled. For example, use these lines in your my.cnf file:<\/p>\n
[<\/span>mysqld<\/span>]<\/span>\r\nperformance_schema<\/span>=<\/span>ON<\/span><\/code><\/pre>\n
More details you can found in official documentation:<\/p>\n
https:\/\/dev.mysql.com\/doc\/refman\/en\/performance-schema-q<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. <\/p>\n
Create a user in Mysql in linux<\/p>\n
login to mysql as a root<\/p>\n
mysql -u root -p<\/p>\n
now create user with following command<\/p>\n
CREATE USER ‘testdb’@’localhost’ IDENTIFIED BY ‘test123’;<\/p>\n
if you got error like below.<\/p>\n
 then you have to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7481"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7481"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7481\/revisions"}],"predecessor-version":[{"id":7487,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7481\/revisions\/7487"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}