mysql-8.0.40二进制单节点部署


1、下载二进制包#

https://dev.mysql.com/downloads/mysql/
选择 mysql-8.0.40-linux-glibc2.28-x86_64.tar.xz

2、部署#

Copy
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#

Copy
[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、登录实例,需要使用初始化过程中生成的随机密码#

Copy
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、开机自启动#

Copy
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 -------------------------------

posted @   ordinaryRoadX  阅读(20)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
点击右上角即可分享
微信分享提示
CONTENTS

"『还真给啊!太客气了』"