mysql-8.0.40二进制单节点部署
1、下载二进制包#
https://dev.mysql.com/downloads/mysql/
选择 mysql-8.0.40-linux-glibc2.28-x86_64.tar.xz
2、部署#
cd /opt
tar xf mysql-8.0.40-linux-glibc2.28-x86_64.tar.xz
groupadd mysql
useradd -g mysql -s /sbin/nologin -M mysql
mkdir /data/mysql-8.0.40/{data,tmp,logs} -p
chown -R mysql.mysql /opt/mysql-8.0.40-linux-glibc2.28-x86_64
chown -R mysql.mysql /data/mysql-8.0.40
chmod -R 750 /data/mysql-8.0.40/data
ln -s mysql-8.0.40-linux-glibc2.28-x86_64 mysql
ln -s /opt/mysql/bin/* /usr/local/sbin/
3、vim /opt/mysql/my-8.0.40.cnf#
[mysql]
# CLIENT #
port = 3306
prompt='(product)\u@\h [\d]>'
default-character-set=utf8mb4
no-auto-rehash
[mysqld]
lower_case_table_names = 1
character_set_server = utf8mb4
collation-server = utf8mb4_unicode_ci
character-set-client-handshake = 0
init_connect = 'SET NAMES utf8mb4'
server-id = 723306
explicit_defaults_for_timestamp = 1
default_time_zone = '+8:00'
log_timestamps = SYSTEM
skip-name-resolve
# DATA STORAGE #
datadir = /data/mysql-8.0.40/data
tmpdir = /data/mysql-8.0.40/tmp
# GENERAL #
port = 3306
basedir = /opt/mysql
user = mysql
default-storage-engine = InnoDB
socket = /tmp/mysql.sock
pid-file = mysql.pid
performance_schema = 1
# SAFETY #
max-allowed-packet = 64M
max-connect-errors = 1000000
# BINARY LOGGING #
log-bin = /data/mysql-8.0.40/logs/mysql-bin
binlog_format = row
binlog-cache-size = 4M
max-binlog-size = 1G
binlog-rows-query-log-events = ON
expire-logs-days = 3
sync-binlog = 1
log_bin_trust_function_creators= 1
# SLAVE BINLOGUPDATE#
log-slave-updates
# RELAY LOGS #
relay-log = /data/mysql-8.0.40/logs/relay-log
max-relay-log-size = 1G
relay_log_purge = 1
relay_log_recovery = 1
# CACHES AND LIMITS #
tmp-table-size = 96M
max-heap-table-size = 96M
max-connections = 1000
thread-cache-size = 64
open-files-limit = 65535
innodb_open_files = 65535
table-definition-cache = 4096
table-open-cache = 4096
key-buffer-size = 32M
read-buffer-size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M
sort_buffer_size = 2M
join_buffer_size = 8M
secure-file-priv = ''
open-files-limit = 65535
innodb_open_files = 65535
# LOGGING #
long_query_time = 0.2
log-error = /data/mysql-8.0.40/logs/error.log
slow-query-log = 1
slow-query-log-file = slow-query.log
#log-queries-not-using-indexes = 1
eq-range-index-dive-limit = 1000
#log-slow-slave-statements = 1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# SQL MODE #
sql-mode="NO_ENGINE_SUBSTITUTION"
## 8.0 ##
default_authentication_plugin = mysql_native_password
skip_ssl
[mysqld_safe]
nice = -19
[mysqldump]
quick
quote-names
max_allowed_packet = 64M
[client]
port = 3306
socket = /tmp/mysql.sock
4、初始化数据库#
/opt/mysql/bin/mysqld --defaults-file=/opt/mysql/my-8.0.40.cnf --initialize --user=mysql --datadir=/data/mysql-8.0.40/data
5、启动实例#
/opt/mysql/bin/mysqld_safe --defaults-file=/opt/mysql/my-8.0.40.cnf &
6、登录实例,需要使用初始化过程中生成的随机密码#
grep password /data/mysql-8.0.40/logs/error.log
2025-01-16T15:42:06.420055+08:00 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: xE+4wr#Wl-.&
/opt/mysql/bin/mysql -uroot -S /tmp/mysql.sock -p
// 修改密码
mysql> ALTER USER user() IDENTIFIED BY 'mysql';
Query OK, 0 rows affected (0.00 sec)
7、开机自启动#
cp /opt/mysql/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --list
chkconfig --add mysql
chkconfig --list
------------------------------- THE END -------------------------------
作者: ordinaryRoadX
出处:https://www.cnblogs.com/ordinaryRoadX/p/18676399
本站使用「CC BY 4.0」创作共享协议,转载请在文章明显位置注明作者及出处。
分类:
db
标签:
mysql-8.0.40
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库