一,安装包下载
https://dev.mysql.com/downloads/mysql/5.7.html
二,删除mariadb
rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
三,解压,重命名
tar -xvf mysql-5.7.31-linux-glibc2.12-x86_64.tar
tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql-5.7.31
四,创建数据目录
cd /usr/local/mysql-5.7.31
mkdir data
mkdir log
mkdir tmp
五,创建用户组与用户权限
groupadd mysql
useradd -g mysql mysql
passwd mysql
chown -R mysql:mysql /usr/local/mysql-5.7.31
六,创建配置表
vi /etc/my.cnf
内容如下:
[client]
port = 3306
socket = /usr/local/mysql-5.7.31/tmp/mysql.sock
[mysqld]
port = 3306
basedir = /usr/local/mysql-5.7.31
datadir = /usr/local/mysql-5.7.31/data
tmpdir = /usr/local/mysql-5.7.31/tmp
socket = /usr/local/mysql-5.7.31/tmp/mysql.sock
pid-file = /usr/local/mysql-5.7.31/log/mysql.pid
log_error = /usr/local/mysql-5.7.31/log/error.log
slow_query_log_file = /usr/local/mysql-5.7.31/log/slow.log
explicit_defaults_for_timestamp=true
lower_case_table_names=1
七,数据库初始化
./mysqld --initialize --user=mysql
八,设置开机自启动mysql服务
cp /usr/local/mysql-5.7.31/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
九,切换用户启动
su mysql
service mysqld start
十,配置环境变量
vi /etc/profile
在最后增加下面代码
export PATH=$PATH:/usr/local/mysql-5.7.31/bin
生效配置
source /etc/profile
十一,更改密码
cd log/
vi error.log
/password #查找初始密码
登录mysql
mysql -uroot -p
#更新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123456';
flush privileges;
#开启远程
#grant all privileges on *.* to root@'%' identified by 'root123456';
show databases;
use mysql;
update user set host="%" where user='root';
flush privileges;
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;
exit;