# 下載libtinfo5、libnuma1依賴
[root@lb ~]# apt update -y && apt install -y libtinfo5 libnuma1

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz

# 服務(wù)解壓至家目錄
[root@lb ~]# tar -xvf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
# 創(chuàng)建軟鏈接
[root@lb ~]# ln -s mysql-8.0.26-linux-glibc2.12-x86_64 mysql
# 查看
[root@lb ~]# ll | grep mysql
lrwxrwxrwx  1 root root        35 May  1 15:43 mysql -> mysql-8.0.26-linux-glibc2.12-x86_64/
drwxr-xr-x  9 root root      4096 May  1 15:43 mysql-8.0.26-linux-glibc2.12-x86_64/
-rw-r--r--  1 root root 914806904 Jul  2  2021 mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz

# /root/mysql/bin根據(jù)你安裝的實際地址來進(jìn)行替換
[root@lb ~]# echo 'export PATH=/root/mysql/bin:$PATH' >> /etc/profile
[root@lb ~]# source /etc/profile

[root@lb ~]# mysql -V
mysql  Ver 8.0.26 for Linux on x86_64 (MySQL Community Server - GPL)

[root@lb ~]# useradd -s /sbin/nologin -M mysql

[root@lb ~]# mkdir -p /data/mysql/data
[root@lb ~]# chown -R mysql.mysql /data/mysql/data

# 初始化數(shù)據(jù)庫，沒有報錯即代表成功
[root@lb ~]# mysqld --initialize-insecure  --user=mysql  --datadir=/data/mysql/data  --basedir=/root/mysql
2025-05-01T07:59:04.638615Z 0 [System] [MY-013169] [Server] /root/mysql-8.0.26-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.26) initializing of server in progress as process 132486
2025-05-01T07:59:04.656989Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-05-01T07:59:05.254538Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-05-01T07:59:05.950015Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2025-05-01T07:59:05.950635Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2025-05-01T07:59:06.009584Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

[root@lb ~]# ll /data/mysql/data/
total 177608
-rw-r----- 1 mysql mysql   196608 May  1 15:59 '#ib_16384_0.dblwr'
-rw-r----- 1 mysql mysql  8585216 May  1 15:59 '#ib_16384_1.dblwr'
drwxr-x--- 2 mysql mysql     4096 May  1 15:59 '#innodb_temp'/
drwxr-xr-x 6 mysql mysql     4096 May  1 15:59  ./
drwxr-xr-x 3 root  root      4096 May  1 15:56  ../
-rw-r----- 1 mysql mysql       56 May  1 15:59  auto.cnf
-rw------- 1 mysql mysql     1676 May  1 15:59  ca-key.pem
-rw-r--r-- 1 mysql mysql     1112 May  1 15:59  ca.pem
-rw-r--r-- 1 mysql mysql     1112 May  1 15:59  client-cert.pem
-rw------- 1 mysql mysql     1680 May  1 15:59  client-key.pem
-rw-r----- 1 mysql mysql     5995 May  1 15:59  ib_buffer_pool
-rw-r----- 1 mysql mysql 50331648 May  1 15:59  ib_logfile0
-rw-r----- 1 mysql mysql 50331648 May  1 15:59  ib_logfile1
-rw-r----- 1 mysql mysql 12582912 May  1 15:59  ibdata1
drwxr-x--- 2 mysql mysql     4096 May  1 15:59  mysql/
-rw-r----- 1 mysql mysql 26214400 May  1 15:59  mysql.ibd
drwxr-x--- 2 mysql mysql     4096 May  1 15:59  performance_schema/
-rw------- 1 mysql mysql     1676 May  1 15:59  private_key.pem
-rw-r--r-- 1 mysql mysql      452 May  1 15:59  public_key.pem
-rw-r--r-- 1 mysql mysql     1112 May  1 15:59  server-cert.pem
-rw------- 1 mysql mysql     1680 May  1 15:59  server-key.pem
drwxr-x--- 2 mysql mysql     4096 May  1 15:59  sys/
-rw-r----- 1 mysql mysql 16777216 May  1 15:59  undo_001
-rw-r----- 1 mysql mysql 16777216 May  1 15:59  undo_002

[root@lb ~]# cat /etc/my.cnf
[mysqld]
# 數(shù)據(jù)庫文件的存儲路徑
datadir=/data/mysql/data
# 服務(wù)器監(jiān)聽的端口號
port=3306
# 字符集設(shè)置
character-set-server=utf8mb4
# 排序規(guī)則
collation-server=utf8mb4_general_ci
# 允許的最大連接數(shù)
max_connections=1000
# MySQL服務(wù)器的緩存大小，用于緩存數(shù)據(jù)和索引
innodb_buffer_pool_size=1G
# 日志文件的路徑
log_error=/var/log/mysql/error.log
# 慢查詢?nèi)罩疚募穆窂?
slow_query_log_file=/var/log/mysql/slow-query.log
# 開啟慢查詢?nèi)罩荆?表示開啟，0表示關(guān)閉
slow_query_log=1
# 設(shè)定慢查詢的時間閾值，單位為秒，超過此時間的查詢將被記錄到慢查詢?nèi)罩局?
long_query_time=3
# 設(shè)置用戶
user=mysql
# 設(shè)置socket連信息
socket=/tmp/mysql.sock
[client]
# 客戶端默認(rèn)字符集
default-character-set=utf8mb4
[mysql]
# MySQL命令行工具的默認(rèn)字符集
default-character-set=utf8mb4
 

[root@lb ~]# mkdir -p /var/log/mysql/
[root@lb ~]# chown -R mysql.mysql /var/log/mysql/

[root@lb ~]# cp /root/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@lb ~]# chmod +x /etc/init.d/mysqld

# 沒報錯即代表啟動成功
[root@lb ~]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): mysqld.service.
# 檢查端口號
[root@lb ~]# ss -lntup | grep 3306
tcp   LISTEN 0      70                 *:33060            *:*    users:(("mysqld",pid=144896,fd=21))
tcp   LISTEN 0      1000               *:3306             *:*    users:(("mysqld",pid=144896,fd=24))

[root@lb ~]# mysqladmin -u root password "huangsir"
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[root@lb ~]# mysql -uroot -phuangsir
mysql: [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 10
Server version: 8.0.26 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

# 創(chuàng)建用戶，10.0.0.0/24代表網(wǎng)段，只有在這個網(wǎng)段之內(nèi)的IP才能連接數(shù)據(jù)庫，密碼設(shè)置為huangsir
mysql> CREATE USER 'root'@'10.0.0.0/24' IDENTIFIED BY 'huangsir';
Query OK, 0 rows affected (0.01 sec)
# 授權(quán)，*.*代表所有的庫和表
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.0.0/24' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
# 刷新權(quán)限
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)