下載安裝包
MySQL Community Downloads
安裝依賴
mysql 數據目錄初始化及服務啟動階段依賴libaio，檢測是否已安裝libaio
dnf install libaio
解壓安裝
## 創建用戶組
groupadd mysql
## 創建用戶
useradd -r -g mysql -s /bin/false mysql
## 解壓安裝包
tar xvf /path/to/mysql-VERSION-OS.tar.xz -C /mysql/install/path
## 創建符號鏈接
ln -s full-path-to-mysql-VERSION-OS mysql安裝后配置工作
初始化數據目錄
cd /opt/mysql
mkdir mysql-files
chown mysql:mysql mysql-files# 初始化數據目錄，注意生成的隨機密碼
bin/mysqld --initialize --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/mysql-files
可以將basedir，datadir加到配置文件中 Using Option Files
啟動服務
# 跳轉到安裝目錄后
# 注意：如果沒有在配置文件中指定basedir,datadir 則需要在命令行中指定
bin/mysqld_safe --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/mysql-files &
使用root登陸并修改密碼
[jxxchallenger@fedora-36 mysql]$ bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.3.0Copyright (c) 2000, 2024, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
Query OK, 0 rows affected (0.02 sec)mysql>
mysql日常
shutdown mysql
手動關閉mysql
[root@fedora-36 mysql]# bin/mysqladmin -u root -p shutdown
Enter password:
2024-03-02T14:25:07.972096Z mysqld_safe mysqld from pid file /opt/mysql/mysql-files/fedora-36.pid ended
[1]+ 已完成 bin/mysqld_safe --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/mysql-files
注意此處的 -u root 指定的是用戶表中的root
mysql 安裝包中提供一個方便的腳本來啟動/停止mysqld進程 （support-files/mysql.server)
語法：
[root@fedora-36 support-files]# ./mysql.server
Usage: mysql.server {start|stop|restart|reload|force-reload|status} [ MySQL server options ]
配置：
在 /etc/my. cnf中指定basedir和datadir；或者直接在mysql.server中指定
啟動服務：
./mysql.server start
停止服務：
./mysql.server stop
