centos6.7安装mysql_centos6.7 yum安装mysql5.7

两台机器 内网互通

A：192.168.3.39

B：192.168.3.40

以root身份登录

先卸载老版本mysql

已安装centos6.7，选的basic-server模式，默认带了mysql5.1，先卸载掉，再安装

yum list installed|grep mysql

mysql-libs.x86_64

yum remove mysql-libs.x86_64

........

Complete!

yum list installed|grep mysql

无返回，则已卸载成功。

官网下载系统对应的mysql的rpm包

wget https://repo.mysql.com//mysql57-community-release-el6-9.noarch.rpm

安装rpm包

rpm -Uvh mysql57-community-release-el6-9.noarch.rpm

warning: mysql57-community-release-el6-9.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ########################################### [100%]

1:mysql57-community-relea########################################### [100%]

选择安装版本

When using the MySQL Yum repository, the latest GA release of MySQL is selected for installation by default.

会默认最新的正式版本(GA)

yum repolist all | grep mysql

mysql-connectors-community MySQL Connectors Community enabled: 30

mysql-connectors-community-source MySQL Connectors Community - So disabled

mysql-tools-community MySQL Tools Community enabled: 42

mysql-tools-community-source MySQL Tools Community - Source disabled

mysql-tools-preview MySQL Tools Preview disabled

mysql-tools-preview-source MySQL Tools Preview - Source disabled

mysql55-community MySQL 5.5 Community Server disabled

mysql55-community-source MySQL 5.5 Community Server - So disabled

mysql56-community MySQL 5.6 Community Server disabled

mysql56-community-source MySQL 5.6 Community Server - So disabled

mysql57-community MySQL 5.7 Community Server enabled: 164

mysql57-community-source MySQL 5.7 Community Server - So disabled

mysql80-community MySQL 8.0 Community Server disabled

mysql80-community-source MySQL 8.0 Community Server - So disabled

可以看到默认选的5.7版本

如果要选择其他版本，可以编辑/etc/yum.repos.d/mysql-community.repo 文件,修改对应版本的enabled=1

确认要安装的版本

yum repolist enabled | grep mysql

mysql-connectors-community MySQL Connectors Community 30

mysql-tools-community MySQL Tools Community 42

mysql57-community MySQL 5.7 Community Server 164

开始安装

yum install mysql-community-server

.......

Complete!

安装完成。

启动mysql服务

service mysqld start

Initializing MySQL database: [ OK ]

Installing validate password plugin: [ OK ]

Starting mysqld: [ OK ]

查看mysql状态

service mysqld status

mysqld (pid 37204) is running...

mysql5.7默认新建了一个临时密码，存在mysqld.log文件，查看临时密码

grep 'temporary password' /var/log/mysqld.log

2017-01-13T16:36:26.580447Z 1 [Note] A temporary password is generated for root@localhost: **5n-(#ex5xqyV**

更改root密码

mysql -uroot -p

Enter password:

使用临时密码 5n-(#ex5xqyV 登录后，修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

新密码太简单的话，会报ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

因为增加了密码强度验证插件validate_password，相关参数设置的较为严格