linux系统centos7版本RPM安装 mysql 5.7

yum安装mysql

//yum安装
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
//启动服务
systemctl start  mysqld.service
systemctl status mysqld.service
//查看密码
grep "password" /var/log/mysqld.log
//进入mysql 
mysql -uroot -p
//需改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
//允许远程主机登录
update user set host = '%' where user = 'root';
//刷新
flush privileges;
//完成 就这么简单

源码安装mysql

mysql 安装包 下载网址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads

在linux中执行命令 下载 server,client,libs,common

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.29-1.el7.x86_64.rpm
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.29-1.el7.x86_64.rpm
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.29-1.el7.x86_64.rpm
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.29-1.el7.x86_64.rpm

按照依赖关系依次安装rpm包 依赖关系依次为common→libs→client→server
1.安装libs 出现错误

//清除yum里所有mysql依赖包
rpm -qa|grep mysql
yum remove mysql-libs

ivh中， i-install安装；v-verbose进度条；h-hash哈希校验

1安装 mysql-server 如果提示如下libaio依赖异常, 则根据提示下载所需依赖libaio,之后重新执行安装mysql-server 即成功

yum -y install libaio

2.如果提示 无法建立 SSL 连接 则执行以下代码

	yum -y install openssl openssl-devel gcc make perl

3.如果安装mysql-server时 报错

Error: Package: mysql-community-libs-5.6.42-2.el7.x86_64 (mysql56-community)
       Requires: libc.so.6(GLIBC_2.17)(64bit)

则修改/etc/yum.repos.d目录编辑mysql-community.repo 文件，将enabled设置为0，如下

# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

4 Job for mysqld.service failed because the control process exited with error code

因之前安装过mysql 导致 删除var/lib/mysql 即可

rm -rf /var/lib/mysql

重启mysql服务。

//查看mysql状态
systemctl status mysqld.service 
// 重启mysql服务
systemctl restart mysqld.service 

获取密码 在/var/log/mysqld.log 搜索 temporary password关键字获取密码:J4M>a,>4yD*6

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

进入mysql服务,设置密码,

[root@xxx]#mysql -u root -p
//设置密码 密码要够复杂 大小写,数字,特殊符号组成
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
//赋值权限 让所有主机能登录root 用户
mysql> use mysql;
mysql> update user set host='%' where User='root';
//刷新生效
mysql> flush privileges;

配置编码
修改/etc/my.cnf文件 加上配置

[mysql]
default-character-set =utf8

防火墙相关操作

//查看防火墙状态 
systemctl status firewalld.service
//开启防火墙
systemctl start firewalld.service
//关闭防火墙
systemctl stop firewalld.service

在开启了防火墙时，做如下设置，开启相关端口，
修改/etc/sysconfig/iptables 文件，添加以下内容：

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

如果关闭了防火墙 以及 mysql的root用户已经授权远程任何主机 则可能阿里云安全策略需要配置
登录阿里云–>服务器–>网络与安全–>安全组–>配置规则–>添加安全组规则,如下即可