{"id":6175,"date":"2016-08-23T10:01:20","date_gmt":"2016-08-23T02:01:20","guid":{"rendered":"http:\/\/rmohan.com\/?p=6175"},"modified":"2016-08-23T10:04:24","modified_gmt":"2016-08-23T02:04:24","slug":"your-password-does-not-satisfy-the-current-policy-requirements","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6175","title":{"rendered":"Your password does not satisfy the current policy requirements"},"content":{"rendered":"

wget https:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-8.noarch.rpm<\/p>\n

[root@clusterserver2 software]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm
\nwarning: mysql57-community-release-el7-8.noarch.rpm: Header V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY
\nPreparing…\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%]
\nUpdating \/ installing…
\n1:mysql57-community-release-el7-8\u00a0 ################################# [100%]<\/p>\n

After the installation of this package. We will get two new yum repo related to MySQL<\/p>\n

[root@localhost ~]# ls -1 \/etc\/yum.repos.d\/mysql-community*\r\n\/etc\/yum.repos.d\/mysql-community.repo\r\n\/etc\/yum.repos.d\/mysql-community-source.repo\r\n[root@localhost ~]#\r\n<\/pre>\n
Installing MySQL Server<\/h3>\n
By using yum command, now we will install MySQL Server 5.6 . All dependencies will be installed itself.<\/p>\n
yum install mysql-server\r\n<\/pre>\n
How to start\/stop\/restart MySQL Server<\/h3>\n
Now MySQL Server is installed on your system.
\n
\nTo start MySQL Service<\/strong>, run command<\/p>\n
systemctl start mysqld\r\n<\/pre>\n
To stop MySQL Service<\/strong>, run command<\/p>\n
systemctl stop mysqld\r\n<\/pre>\n
To restart MySQL Service<\/strong>, run command<\/p>\n
systemctl restart mysqld\r\n<\/pre>\n
To get status of MySQL Service<\/strong>, run command<\/p>\n
systemctl status mysqld\r\n<\/pre>\n
Reset MySQL root password<\/h3>\n
On fresh installation of MySQL Server. The MySQL root user password is blank.
\nFor good security practice, we should reset the password MySQL root user.<\/p>\n
On newly installed MySQL Server, we generally recommend to use the command script. You have to just follow the instructions.<\/p>\n
mysql_secure_installation\r\n<\/pre>\n
In another method,you can log into MySQL server database and reset the password in secure way.<\/p>\n
mysql -u root\r\n<\/pre>\n
You will see mysql prompt like this mysql> . Use the below given commands to reset root\u2019s password.<\/p>\n
mysql> use mysql;\r\nmysql> update user set password=PASSWORD(\"GIVE-NEW-ROOT-PASSWORD\") where User='root';\r\nmysql> flush privileges;\r\nmysql> quit\r\n<\/pre>\n
 <\/p>\n
MySQL version: 5.7.9<\/strong><\/p>\n
For development, using a MySQL server with strong password policy is dosing some matter.<\/p>\n
If you set a simply password for someone, you will got an error like this:<\/p>\n
\n
\n
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements\r\n<\/pre>\n<\/div>\n<\/div>\n
To change the default password plugin level, we can change the settings at runtime or in config file.<\/p>\n
\n
\n
mysql> SHOW VARIABLES LIKE 'validate_password%';\r\n+--------------------------------------+--------+\r\n| Variable_name                        | Value  |\r\n+--------------------------------------+--------+\r\n| validate_password_dictionary_file    |        |\r\n| validate_password_length             | 8      |\r\n| validate_password_mixed_case_count   | 1      |\r\n| validate_password_number_count       | 1      |\r\n| validate_password_policy             | MEDIUM |\r\n| validate_password_special_char_count | 1      |\r\n+--------------------------------------+--------+\r\n6 rows in set (0.01 sec)\r\n<\/pre>\n<\/div>\n<\/div>\n
The default level is MEDIUM<\/code>, we can change it to LOW<\/code>, which will only check the password’s length(min: 8 chars).<\/p>\n
\n
\n
mysql> SET GLOBAL validate_password_policy=LOW;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\n\r\n<\/pre>\n
\n
$ mysql -u root -p<\/code><\/div>\n
> <\/code>set<\/code>password <\/code>for<\/code>root@localhost=password(<\/code>'newpass'<\/code>);<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
\n
\n
$ mysql -u root -p<\/code><\/div>\n
> show variables like <\/code>'char%'<\/code>;<\/code><\/div>\n
+--------------------------+----------------------------+<\/code><\/div>\n
| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+--------------------------+----------------------------+<\/code><\/div>\n
| character_set_client\u00a0\u00a0\u00a0\u00a0 | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_connection | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_database\u00a0\u00a0 | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_filesystem | binary\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_results\u00a0\u00a0\u00a0 | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_server\u00a0\u00a0\u00a0\u00a0 | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_set_system\u00a0\u00a0\u00a0\u00a0 | utf8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| character_sets_dir\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>\/usr\/share\/mysql\/charsets\/<\/code> |<\/code><\/div>\n
+--------------------------+----------------------------+<\/code><\/div>\n
8 rows <\/code>in<\/code> set<\/code> (0.00 sec)<\/code><\/div>\n<\/div>\n<\/div>\n
Or we can set it in my.cnf<\/code> file<\/p>\n
\n
\n
[mysqld]\r\nvalidate_password_policy=LOW\r\n\r\n\r\n\r\nsystemctl restart mysqld.service<\/code>\r\n<\/pre>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
wget https:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-8.noarch.rpm<\/p>\n
[root@clusterserver2 software]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm warning: mysql57-community-release-el7-8.noarch.rpm: Header V3 DSA\/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing… ################################# [100%] Updating \/ installing… 1:mysql57-community-release-el7-8 ################################# [100%]<\/p>\n
After the installation of this package. We will get two new yum repo related to MySQL<\/p>\n
 [root@localhost ~]# ls -1 \/etc\/yum.repos.d\/mysql-community* \/etc\/yum.repos.d\/mysql-community.repo \/etc\/yum.repos.d\/mysql-community-source.repo [root@localhost ~]# Installing MySQL Server <\/p>\n
By […]<\/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\/6175"}],"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=6175"}],"version-history":[{"count":4,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6175\/revisions"}],"predecessor-version":[{"id":6179,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6175\/revisions\/6179"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}