Oracle linux 8 二进制安装 MySQL 8.4企业版

[root@mysql8_3 ~]# ldd --version ldd

[root@mysql8_3 ~]#yum install libaio

[root@mysql8_3 ~]#yum install ncurses-compat-libs

[root@mysql8_3 ]#mkdir /u01

[root@mysql8_3 ]# useradd -r -g mysql -s /bin/false mysql

[root@mysql8_3 u01]# cd /u01

[root@mysql8_3 u01]# tar xvf mysql-commercial-8.4.4-linux-glibc2.28-x86_64.tar.xz

[root@mysql8_3 u01]# mv mysql-commercial-8.4.4-linux-glibc2.28-x86_64 mysql3308

[root@mysql8_3 mysql3308]# mkdir base

[root@mysql8_3 mysql3308]# mv * base/

[root@mysql8_3 mysql3308]# mkdir data

[root@mysql8_3 mysql3308]# cd ..[root@mysql8_3 u01]# chown -R mysql.mysql mysql3308

[root@mysql8_3 mysql3308]# base/bin/mysqld --initialize --datadir=/u01/mysql3308/data/ --user=mysql2025-04-09T06:10:07.862792Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.2025-04-09T06:10:07.866074Z 0 [System] [MY-013169] [Server] /u01/mysql-commercial-8.4.4-linux-glibc2.28-x86_64/base/bin/mysqld (mysqld 8.4.4-commercial) initializing of server in progress as process 118982025-04-09T06:10:08.040918Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2025-04-09T06:10:11.812516Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2025-04-09T06:10:25.552364Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fc9%Xt<E5eF/2025-04-09T06:10:38.228926Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

[root@mysql8_3 mysql3308]# ./base/bin/mysqld_safe --datadir=/u01/mysql3308/data/ --user=mysql &[1] 12586[root@mysql8_3 mysql3308]# 2025-04-09T06:15:10.255451Z mysqld_safe Logging to '/u01/mysql3308/data/mysql8_3.52.err'.2025-04-09T06:15:10.330480Z mysqld_safe Starting mysqld daemon with databases from /u01/mysql3308/data

[root@mysql8_3 mysql3308]# netstat -antupl

[root@mysql8_3 mysql3308]# ./base/bin/mysql -uroot -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.4.4-commercialCopyright (c) 2000, 2025, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>mysql> set password='123456';

[root@mysql8_3 mysql3308]# ./base/bin/mysql -uroot -p123456mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 10Server version: 8.4.4-commercial MySQL Enterprise Server - CommercialCopyright (c) 2000, 2025, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exitBye

[root@mysql8_3 mysql3308]# cp base/support-files/mysql.server /etc/init.d/mysql.server

[root@mysql8_3 mysql3308]# vim /etc/init.d/mysql.server# If you change base dir, you must also change datadir. These may get# overwritten by settings in the MySQL configuration files.basedir=/u01/mysql3308/basedatadir=/u01/mysql3308/data

[root@mysql8_3 mysql3308]# /etc/init.d/mysql.server startStarting MySQL.... SUCCESS![root@mysql8_3 mysql3308]# netstat -antupl

[root@mysql8_3 mysql3308]# echo "export PATH=$PATH:/u01/mysql3308/base/bin" >> /etc/profile[root@mysql8_3 mysql3308]# source /etc/profile[root@mysql8_3 mysql3308]# mysql -uroot -p123456mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.4.4-commercial MySQL Enterprise Server - CommercialCopyright (c) 2000, 2025, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

[root@mysql8_3 mysql3308]# vim my.cnf[mysqld]user=mysqlport=3308mysqlx_port=33080basedir=/u01/mysql3308/basedatadir=/u01/mysql3308/datasocket = /u01/mysql3308/data/mysql.sockpid-file = /u01/mysql3308/data/mysql.pidlog_error = /u01/mysql3308/data/mysql-error.loglog_timestamps=SYSTEMcharacter_set_server=utf8mb4skip_name_resolve=1binlog_format=rowlog-bin = /u01/mysql3308/data/binlogserver-id = 03533308skip_slave_start=1open_files_limit=65535innodb_buffer_pool_size=3Ginnodb_log_buffer_size=16Minnodb_log_file_size=256Msort_buffer_size = 6M

[root@mysql8_3 mysql3308]# chown mysql:mysql my.cnf

[root@mysql8_3 mysql3308]#  vim /usr/lib/systemd/system/mysqld83308.service# This service is actually a systemd target,# but we are using a service since targets cannot be reloaded.[Unit]Description=MySQL ServerDocumentation=mysqld.serviceAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/u01/mysql3308/base/bin/mysqld --defaults-file=/u01/mysql3308/my.cnfLimitNOFILE = 5000

[root@mysql8_3 mysql3308]# systemctl restart mysqld83308.service[root@mysql8_3 mysql3308]# netstat -antupl

[root@mysql8_3 mysql3308]# mysql -uroot -p123456 -S /u01/mysql3308/data/mysql.sockmysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.4.4-commercial MySQL Enterprise Server - CommercialCopyright (c) 2000, 2025, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>