1、查看系统自带的Mariadb
rpm -qa|grep mariadb
若存在: mariadb-libs-5.5.64-1.el7.x86_64
不存在:
2、卸载系统自带的Mariadb
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
3、检查MySQL是否存在
rpm -qa | grep mysql
若存在:
不存在:
4、检查用户和组是否存在
检查用户:
cat /etc/passwd | grep mysql
检查用户组:
cat /etc/group | grep mysql
5、不存在创建用户和组
创建mysql用户组:
groupadd mysql
创建mysql用户:
useradd -g mysql mysql
设置密码:
passwd mysql
6、上传MySQL资源包
将 mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz 压缩包上传到 /usr/local/ 目录下
7、解压
tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
重命名文件夹:
mv mysql-5.7.35-linux-glibc2.12-x86_64 mysql
进入目录:
cd /usr/local/mysql/
创建数据目录:
mkdir data
创建日志目录:
mkdir log
创建运行目录:
mkdir run
mkdir run/mysqld
上传 my.cnf 配置文件到 /usr/local/mysql/ 目录下
my.cnf 内容:
[mysqld]
socket=/usr/local/mysql/mysql.sock
# set mysql server port
port = 3306
# set mysql install base dir
basedir=/usr/local/mysql
# set the data store dir
datadir=/usr/local/mysql/data
# set the number of allow max connnection
max_connections=3000
# set server charactre default encoding
character-set-server=utf8
# set is case insensitive
lower_case_table_names=1
max_allowed_packet=16M
init_connect=‘SET NAMES utf8’
log-error=/usr/local/mysql/log/mysqld.log
pid-file=/usr/local/mysql/run/mysqld/mysqld.pid
[mysql.server]
user=mysql
[client]
port=3306
socket=/usr/local/mysql/mysql.sock
进入目录:
cd /usr/local
更改目录所属组和用户:
更改所属组:
chown -R mysql mysql/
更改所属用户:
chgrp -R mysql mysql/
检查目录:
ll
8、安装MySQL
进入初始化目录:
cd /usr/local/mysql
初始化数据库:
./bin/mysqld --initialize --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
查看数据库初始化密码:
grep 'temporary password' /usr/local/mysql/log/mysqld.log
复制配置文件:
cp /usr/local/mysql/my.cnf /etc/my.cnf
9、设置开机自启动
复制启动文件:
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
赋权:
chmod +x /etc/init.d/mysqld
赋予mysql用户mysql目录执行权限:
chown -R mysql.mysql /usr/local/mysql/
添加为服务:
chkconfig --add mysqld
查看服务列表:
chkconfig --list
看到3、4、5状态为开或者为 on 则表示成功
10、启动MySQL
启动:
/etc/init.d/mysqld start
重启:
/etc/init.d/mysqld restart
服务可选项:
11、登录MySQL
编辑环境变量:
vim /etc/profile
在末尾换行添加内容: export PATH=$PATH:/usr/local/mysql/bin
生效环境变量:
source /etc/profile
登录MySQL:
mysql -u root -p
输入初始化密码
登录后修改密码:
set password=password("Ysxx@1234");
创建远程登陆用户:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Ysxx@1234';
刷新:
flush privileges;
12、退出登录
退出:
exit
MySQL5.7 安装完毕