VALIDATE PASSWORD PLUGIN can be used to test passwords and improve security. It checks the strength of password and allows the users toset only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD plugin?
# 是否确认设置密码插件 Press y|Y for Yes, any other key for No: y
There are three levels of password validation policy:
LOW Length >= 8 MEDIUM Length >= 8, numeric, mixed case, and special characters STRONG Length >= 8, numeric, mixed case, special charactersand dictionary file
# 确定密码策略 Please enter 0 = LOW, 1 = MEDIUM and2 = STRONG: 2 Please setthe password for root here.
# 输入新的密码 New password:
# 重新输入新的密码 Re-enter new password:
Estimated strength ofthe password: 100 Do you wish to continue withthe password provided?(Press y|Y for Yes, any other key for No) : y By default, a MySQL installation has an anonymous user, allowing anyone tologinto MySQL without having to have a user account created for them. This is intended only for testing, andto make the installation go a bit smoother. # For advice on how to change settings please see You should remove them before moving intoa production environment.
# 是否移除任意用户登陆 Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success.
Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password fromthe network.
# 禁止root 远程登录 Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n
... skipping. By default, MySQL comes witha database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving intoa production environment.
# 移除测试数据库 Remove test database and access toit? (Press y|Y for Yes, any other key for No) : y - Dropping test database... Success.
- Removing privileges ontestdatabase... Success.
Reloading the privilege tables will ensure that all changes made so far will take effect immediately.
# 重新加载策略 Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Success.