CentOS6.5安装MySQL5.7.9

背景

这几天有时间连接到我的阿里云上看了下,以前好像也没在上面做什么东西,索性这几天决心要搞,就从头来过,然后详细的记录下来,以后还可以回头再来看看.

开始

直接就操作了”重新初始化磁盘”,一切都是新的了,删掉了以前的快照.然后登陆进去

>yum update

安装MySQL

看了下yum库里面只有MySql5.1,太老了,google了一下,找到了mysql的官网,跟着操作一下:

• 下载含有yum库的rpm包,CentOS6.5,选择:Red Hat Enterprise Linux 6 / Oracle Linux 6 (Architecture Independent), RPM Package版本,我现在现在到的文件是:mysql57-community-release-el6-7.noarch.rpm

• 添加yum库

  >rpm -Uvh mysql57-community-release-el6-7.noarch.rpm

• 安装

  >yum install mysql-community-server

• 启动

  >sudo service mysqld start

• 查看状态

  >sudo service mysqld status

• 设置密码

  >mysql_secure_installation

  这里和之前的版本有些不同,执行mysql_secure_installation后需要输入密码,整个安装过程都没有输入密码的地方,这里很茫然.后来搜索了一下,原来出事密码记录在安装日志里面了

• 查看默认密码:

  >grep “password” /var/log/mysqld.log
  >[Note] A temporary password is generated for root@localhost: e-wmIr.ot0nU

• 再次输入mysql_secure_installation就可以设置新密码了:

  >mysql_secure_installation
  >Enter password for user root:

• 密码强度

  到这里我以为一切都很顺利,没想到,设置密码的过程让我差点崩溃.
  我列出我设置过的密码:

  • 10位以上纯数字
  • 10位以上纯字母
  • 10位以上数字+字母
  • 10位以上数字+大小写字母
  • 32位数字+大小写字母

  返回的提示全部都是

  >Your password does not satisfy the current policy requirements

  崩溃!!!

  没办法,再去google一下吧,找到这个,大概看了一下,自从MySQL5.6.6以后添加了一个validate_password的插件.

  大概介绍一下:这个插件会把密码分为三个等级,LOW(弱),MEDIUM(中),STRONG(强),数值从1-100.如果你的密码检测得到的结果是LOW,对不起,密码不能使用.我们再来看下三个级别的定义:

  LOW:密码必须至少8个字符。

  MEDIUM:在LOW的基础上,密码必须包含至少1个数字字符，1小写和大写字符和一个特殊（非字母数字）字符的条件。

  STRONG:在MEDIUM基础上,每截取4个或者更长的字符不能是字典文件里面的单词(如果指定了字典文件)

  知道了这些,终于可以设置一个有效的密码了吧.正好昨天刚安装可KeePassX,按照他规则生成一个密码,强度100:

  >Estimated strength of the password: 100

  后面就是简单的设置了:

Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : 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) : y
Success.

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) : y
Success.

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

 ... skipping.
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.

All done!