CenterOS7下 Mysql 5.7 tar.gz安装

原创

已于 2025-09-12 17:32:44 修改 · 517 阅读

标签

#mysql #sql #数据库

收录于

于 2021-06-10 17:53:28 首次发布

安装新版mysql前，需将系统自带的mariadb-lib卸载

安装新版mysql前，需将系统自带的mariadb-lib卸载

[root@hadoop01 ~]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@hadoop01 ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
[root@hadoop01 ~]# rpm -qa|grep mariadb

解压安装包

tar -zxvf mysql-5.7.24-el7-x86_64.tar.gz

将该文件夹拷贝到/usr/local/下并重命名为 mysql

mv  mysql-5.7.24-el7-x86_64  /usr/local/mysql

在mysql57 下创建文件夹data（我们将该文件夹设置为端口3306实例的目录，为防备多实例的情况）

   mkdir /usr/local/mysql/data
   mkdir /usr/local/mysql/log

my.cnf 文件

创建my.cnf 内容如下

[client]
socket=/usr/local/mysql/mysql.sock
port=3306
[mysqld]

basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock、
default-storage-engine=INNODB
character_set_server=utf8mb4
 
port=3306
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 
log-error=/usr/local/mysql/log/mysqld3306.log
pid-file=/usr/local/mysql/data/mysql.pid
 
log_bin=mysql3306-bin
server_id=1
#STATEMENT，ROW，MIXED
binlog_format=ROW
innodb_file_per_table = 1
lower_case_table_names=1
skip-grant-tables

将my.cnf 放到/etc/下