mysql5.7二进制安装

原创已于 2026-04-28 09:48:04 修改 · 1.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

MySQL

于 2022-01-24 11:17:20 首次发布

本文详细介绍了MySQL服务器的安装步骤，包括下载安装包并上传至服务器、创建用户及目录、配置环境变量、初始化MySQL以及登录修改初始密码的过程。

1.1 yum安装依赖包
yum -y install make gcc gcc-c++ ncurses-devel bison openssl-devel
-------------------------------------------------------------------------------------------------------------
1.2 添加MySQL所需要的用户和组
groupadd mysql
useradd -g mysql mysql
su - mysql 之后的操作使用MySQL用户完成
-------------------------------------------------------------------------------------------------------------
1.3MySQL源码包，本地下载好了直接上传就行

-------------------------------------------------------------------------------------------------------------
1.4 创建mysql数据目录
mkdir -p /mysql/app
mkdir -p /mysql/data
-------------------------------------------------------------------------------------------------------------
1.5解压编译安装cmake、MySQL
[mysql@oracle app]$ tar -xzf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.38-linux-glibc2.12-x86_64 mysql
[mysql@oracle app]$ cd /mysql/app/mysql/support-files
-------------------------------------------------------------------------------------------------------------
1.6 添加启动脚本
[mysql@oracle support-files]$ sudo cp mysql.server /etc/rc.d/init.d/mysqld
-------------------------------------------------------------------------------------------------------------
1.7 添加masterA配置文件/etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
basedir = /usr/local/mysql
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data
pid-file = /usr/local/mysql/data/mysql.pid
log-error = /usr/local/mysql/data/mysql.err

server-id = 1
auto_increment_offset = 1
auto_increment_increment = 2 #奇数ID

log-bin = mysql-bin #打开二进制功能,MASTER主服务器必须打开此项
binlog-format=ROW
binlog-row-p_w_picpath=minimal
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=0
sync_binlog=0
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
expire_logs_days=15
max_binlog_size=1024M #binlog单文件最大值

replicate-ignore-db = mysql #忽略不同步主从的数据库
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
replicate-ignore-db = test
replicate-ignore-db = zabbix

max_connections = 3000
max_connect_errors = 30

skip-character-set-client-handshake                                     #忽略应用程序想要设置的其他字符集
init-connect='SET NAMES utf8'                                           #连接时执行的SQL
character-set-server=utf8                                               #服务端默认字符集
wait_timeout=1800                                                       #请求的最大连接时间
interactive_timeout=1800                                                #和上一参数同时修改才会生效
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES                     #sql模式
max_allowed_packet = 10M
bulk_insert_buffer_size = 8M
query_cache_type = 1
query_cache_size = 128M
query_cache_limit = 4M
key_buffer_size = 256M
read_buffer_size = 16K

skip-name-resolve
slow_query_log=1
long_query_time = 6
slow_query_log_file=slow-query.log
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M

-------------------------------------------------------------------------------------------------------------
1.8配置环境变量cat /etc/profile
export PATH=/mysql/app/mysql/bin:$PATH
-------------------------------------------------------------------------------------------------------------
1.9数据初始化
mysqld --initialize-insecure --user=mysql --basedir=/mysql/app/mysql --datadir=/mysql/data
-------------------------------------------------------------------------------------------------------------
2.0启动MySQL
/mysql/app/mysql/support-files/mysql.server start

标签

#mysql #数据库 #centos