安装了mysql5.7后，如何进行配置（密码等）初始化

2019独角兽企业重金招聘Python工程师标准>>>

1、装好后先开启mysql

mysql.server start

2、直接使用mysql的配置脚本（如果是其他安装方式请自行寻找改文件，一般在mysql/bin目录下）（直接打开下面命令）

/usr/local/opt/mysql/bin/mysql_secure_installation

3、启动这个脚本后，即可根据如下命令提示进行初始化设置

4、你想设置验证密码吗？我们选y：

Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No: y

5、你想设置的密码的强度是什么 0低 1中 2强，安需求选，我这里选0

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 characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:

6、输入两次新密码

Please set the password for root here.

New password: 

Re-enter new password:

7、如果你的密码不太符合规范，则会出现如下提示（这里不管按y还是其他都需要重新输入）

Estimated strength of the password: 25 
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
 ... Failed! Error: Your password does not satisfy the current policy requirements

8、输入符合规范的密码后，则提示（是否删除匿名用户，我们选y，移除掉）

By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) :

9、提示是否禁止远程登陆？我们选y

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) :

10、是否移除默认安装的数据库并登陆mysql，我们选y

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) :

11、是否重新载入权限表（刷新权限，选y）：

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) :

12、看到如下提示就完成了

All done!

转载于:https://my.oschina.net/cxgphper/blog/863471