新建目录
mkdir -p /home/software/package
将压缩包上传到此目录下
1.查看mariadb的版本信息
rpm -qa | grep mariadb
2.卸载(注意mariadb版本)
sudo rpm -e mariadb-libs-5.5.65-2.el7.x86_64 --nodeps
3.检查MySQL 用户组是否存在(没有输出就代表没有)
cat /etc/group | grep mysql
cat /etc/passwd |grep mysql
4.创建MySQL 用户组和用户
groupadd mysql
useradd -r -g mysql mysql
5.切换到/home/product/software/package/目录下(这里是我放安装包的地方)
cd /home/software/package
6.将安装资源包中mysql-5.7.43-linux-glibc2.12-x86_64.tar.gz解压缩并移动到/目录下,并重命名为mysql
tar -zxvf mysql-5.7.43-linux-glibc2.12-x86_64.tar.gz -C /
mv /mysql-5.7.43-linux-glibc2.12-x86_64/ /mysql/
7.切换到MySQL目录下创建相应目录和日志文件
cd /mysql
mkdir -p {data,logs}
touch /mysql/logs/mysqld.log
8.更改MySQL 目录下所有文件夹所属的用户组、用户以及权限
chown -R mysql:mysql /mysql
chmod -R 755 /mysql
9.编写etc目录下的my.cnf 配置文件,并添加配置
vi /etc/my.cnf
[mysqld]
datadir=/mysql/data
basedir=/mysql
user=mysql
port=3306
character-set-server=utf8
server-id=1
max_connections=1000
log-bin=mysql-bin
binlog_format=MIXED
max_binlog_size = 512M
expire_logs_days = 3
binlog_ignore_db = mysql,performance_schema,information_schema
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
# 取消密码验证
#skip-grant-tables
symbolic-links=0
[mysqld_safe]
log-error=/mysql/logs/mysqld.log
pid-file=/mysql/data/ahtech.pid
10.授予my.cnf 配置文件775权限
chmod -R 775 /etc/my.cnf
11.切换到mysql/bin下初始化启动MySQL服务,记录下初始密码。MySQL 依赖于该libaio 库。如果未在本地安装此库,则数据目录初始化和后续服务器启动步骤将失败。
yum install libaio -y
cd /mysql/bin
./mysqld --defaults-file=/etc/my.cnf --initialize
12.建立软连接
ln -s /mysql/support-files/mysql.server /etc/init.d/mysqld
ln -s/mysql/bin/mysql /usr/bin/mysql
chomd +x /usr/bin/mysql
13.启动mysqld
service mysqld start
14.登录MySQL服务
mysql -u root -p
15.使用初始密码登录
正常情况下使用命令修改密码:
ALTER USER USER() IDENTIFIED BY 'AB12345678c';
16.开始配置远程连接
use mysql;
update user set Host='%' where User='root';
flush privileges;
select host, user from user;
17.重启mysqld,开启开机启动
systemctl daemon-reload
service mysqld stop
systemctl start mysqld
/sbin/chkconfig mysqld on
18.查看服务状态
systemctl status mysqld
完成配置!