# 下载 mysql 安装包
Mysql-down
这里选择下载 mysql-8.3.0-linux-glibc2.28-x86_64.tar.xz , 一共 463MB
下载到服务器后，解压到 /usr/local/mysql , 并且进入该目录
# 创建 mysql 用户
useradd mysql | |
#创建 data 目录 | |
mkdir /home/mysql/data | |
#将 mysql 目录和 data 目录下文件所有权设置给 mysql | |
chown -R mysql:mysql /usr/local/mysql | |
chown mysql:mysql /home/mysql/data |
# 初始化 mysql
./bin/mysqld --initialize \ | |
--user=mysql \ | |
--basedir=/usr/local/mysql \ | |
--datadir=/home/mysql/data |
看到如下信息表示初始化成功
2024-01-26T08:52:39.462203Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. | |
2024-01-26T08:52:39.463753Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.3.0) initializing of server in progress as process 30791 | |
2024-01-26T08:52:39.494170Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. | |
2024-01-26T08:52:40.604098Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. | |
2024-01-26T08:52:43.997795Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: uxG/D<qNc7MJ | |
2024-01-26T08:52:50.436407Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. |
记住初始密码，这里是 uxG/D<qNc7MJ , 第一次登录需要
# 编写 my.cnf 文件
因为我们要使用 mysql 用户启动 mysqld 服务，所以修改 /etc/my.cnf 文件，让 pid 和 socket 文件放到 /home/mysql 下
[mysqld] | |
datadir=/home/mysql/data | |
socket=/home/mysql/mysql.sock | |
mysqlx_socket=/home/mysql/mysqlx.sock | |
pid-file=/home/mysql/mysql.pid | |
log-error=/home/mysql/mysql_error.log | |
general_log_file=/home/mysql/general_query.log | |
slow_query_log_file=/home/mysql/slow_query.log | |
[mysql] | |
socket=/home/mysql/mysql.sock |
# 启动 mysql
启动 mysqld
/usr/local/mysql/support-files/mysql.server start |
使用默认密码登录
[root@VM-12-5-opencloud mysql]# ./bin/mysql -uroot -p | |
Enter password: | |
Welcome to the MySQL monitor. Commands end with ; or \g. | |
Your MySQL connection id is 8 | |
Server version: 8.3.0 | |
Copyright (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 '这里填写密码'; |
# 使用 systemd 来启动 mysql
先停止 mysqld 服务，
/usr/local/mysql/support-files/mysql.server stop |
创建 mysql.service 文件
#/etc/systemd/system/mysql.service | |
[Unit] | |
Description=MySQL Server | |
After=network.target | |
[Service] | |
ExecStart=/usr/local/mysql/support-files/mysql.server start | |
ExecStop=/usr/local/mysql/support-files/mysql.server stop | |
User=mysql | |
Group=mysql | |
Restart=always | |
LimitNOFILE=infinity | |
[Install] | |
WantedBy=multi-user.target |
systemctl start mysql
加入开机自启动
systemctl enable mysql
# 结束
到这里 mysql8.3 就安装完成了！
