=============================================================
参考文档
https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
=============================================================
1、添加yum仓库
http://dev.mysql.com/downloads/repo/yum/
此地址中选择rpm文件进行下载
sudo rpm -Uvh mysql80-community-release-el6-n.noarch.rpm(替换为下载的文件)
=============================================================
查看mysql仓库版本的启用与禁用
yum repolist all | grep mysql
=============================================================
禁用8版本的mysql
sudo yum-config-manager --disable mysql80-community
启用5版本的mysql
sudo yum-config-manager --enable mysql57-community
=============================================================
配置文件位置
/etc/yum.repos.d/mysql-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
======================================================
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
enabled=1为启用
=============================================================
再次查看所开启的版本
yum repolist enabled | grep mysql
=============================================================
安装mysql-server
sudo yum install mysql-community-server
=============================================================
启动mysql-server
sudo service mysqld start
=============================================================
查看状态
sudo service mysqld status
=============================================================
安装后mysql默认ROOT用户密码
sudo grep 'temporary password' /var/log/mysqld.log
=============================================================
更新初始密码
mysql -uroot-p
ALTER USER 'root'@'localhost' IDENTIFIEDBY 'MyNewPass4!';
note:密码过于简单为提示
Your password does not satisfy the current policy requirements
密码规则为小写字母+大写字母+特俗字符
=============================================================