一、离线安装方式:
1.下载mysql5.7.27,官网地址 https://dev.mysql.com/downloads/mysql/5.7.html
注:点击archives,然后选择对应的版本下载
2.百度网盘地址,链接:https://pan.baidu.com/s/1K3XMaeTSbbhF7t6zor_kPA,提取码:tlb8
3.上传至服务器,指定目录然后解压:
tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
4.卸载冲突的rpm组件,如果不删除,会安装不成功。先查询,再删除:
查询命令:
rpm -qa | grep postfix
rpm -qa | grep mariadb
删除命令:
rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64
5.安装相关依赖:
yum -y install libaio
yum -y install net-tools
yum -y install perl
6.安装mysql相关组件,注意组件的顺序:
rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
7.启动mysql,并查看mysql状态
systemctl start mysqld.service
systemctl status mysqld.service
8.获取临时密码,MySQL5.7为root用户随机生成了一个密码:
grep 'temporary password' /var/log/mysqld.log
注:密码就是root@localhost:***,后面的星号就是临时密码
9.通过临时密码登录
mysql -uroot -p
注:使用临时密码有可能登录不上。解决方案是:
1).关闭mysql服务:
systemctl stop mysqld.service或者service mysqld stop
2)进入etc/my.cnf目录,在[mysqld]添加skip-grant-tables
3).重启mysql :
service mysqld restart或者systemctl start mysqld.service
注:修改完密码后,记得改回来。这里是无密码登录。
4).修改密码
mysql> use mysql; (可能会出现You must reset your password using ALTER USER statement before executing this statement错误,因为这是数据库5.7版本后,需要通过alter user user() identified by "df@zxcv123";修改当前用户密码,如果你修改的密码过于复杂会出现Your password does not satisfy the current policy requirements错误,请设置密码策略满足长度即可)
mysql> update user set password=password('123456') where user='root';
mysql> flush privileges; (必要步骤,一定要刷新权限表结构)
注:如果修改密码第二句设置修改密码,不行,可以使用下面这句。update mysql.user set authentication_string=password('root_password') where user='root';
另记得设置下mysql密码策略,有可能后期会出现远程登录,密码策略不匹配的情况:
设置密码满足长度策略即可:
set global validate_password_policy=0;
设置密码长度为6:
set global validate_password_length=6;
10.授权远程机器登录:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
flush privileges;
11.授权开机自启动:
systemctl enable mysqld
systemctl daemon-reload
12.设置MySQL的字符集为UTF-8,令其支持中文
vim /etc/my.cnf,添加如下配置:
[mysql]
default-character-set=utf8
13.重启mysql:
service mysqld restart
二、在线安装:
1.下载mysql rpm包:
wget http:
//repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
2.安装mysql源:
rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
3.安装mysql server:
yum install -y mysql-community-server
4.检测mysql启动状态:
systemctl status mysqld.service
注:接下来的操作就和上面第一种方式,第8步开始以后的步骤是一样的了。