准备工作
1.下载mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
下载地址:https://pan.baidu.com/s/1WMZctf_OUpqOKcgBKmREAQ
2.下载传输工具winscp
下载地址:https://pan.baidu.com/s/1QdQvDeJfQGbxYn_vyPBqdQ
安装mysql5.7
系统环境:centos7 64位
检查系统是否安装mysql(有安装的话自行卸载)
yum list installed mysql*
rpm –qa|grep mysql*
传输mysql5.7安装包,直接拖拽
安装mysql5.7
前提:检查现有mariadb安装包,如果有,则删除(注意mariadb版本,以显示的为准)
rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
官网: https://dev.mysql.com/downloads/mysql/
- 解压mysql总压缩包
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar - 安装rpm包:按如下顺序安装,有些包会有依赖
1.安装common
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
安装成功
2.安装libs
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
出现依赖问题,安装失败
解决依赖问题:
查看postfix和mariadb-libs
rpm -qa | grep postfix
rpm -qa | grep mariadb
卸载postfix和mariadb-libs
rpm -ev postfix-2.10.1-6.el7.x86_64
rpm -ev mariadb-libs-5.5.52-1.el7.x86_64
再次安装libs
重新安装下common后再次安装libs解决
3.安装client
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
安装成功
4.安装server
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
安装成功
5.安装devel
rpm -ivh mysql-community-devel-5.7.26-1.el7.x86_64.rpm
安装成功
配置mysql
1.启动mysql服务
systemctl start mysqld.service (service mysqld start)
(关闭命令:systemctl stop mysqld.service (service mysql stop))
2.查看3306端口是否成功开启,即mysql是否启动:
netstat -anp | grep 3306
mysql启动成功
3.修改my.cnf文件
vim /etc/my.cnf
新增以下内容:
validate_password=off
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
保存退出
4.重启mysql服务:
systemctl restart mysqld.service
5.修改初始密码:
cat /var/log/mysqld.log | grep password
复制初始密码
输入如下命令登陆mysql :
mysql -u root -p
输入刚刚复制的初始密码
登录成功
设置新密码:
set password=password('123456');
flush privileges;
添加远程访问权限:设置远程访问密码为123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
重启mysql服务即可使用。
systemctl restart mysqld.service
至此,mysql已经安装成功。