debian部署mysql 8.4.7LTS 二进制版本
1.下载二进制包
mysql-8.4.7-linux-glibc2.28-x86_64.tar.xz
2.安装依赖
apt update
apt install libaio1 libncurses5 libssl1.1 -y
3.解压安装包
tar -xvf mysql-8.4.7-linux-glibc2.28-x86_64.tar.xz
mv mysql-8.4.7-linux-glibc2.28-x86_64 /usr/local/mysql
4.创建用户和数据目录
sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql
sudo mkdir /usr/local/mysql/data
sudo chown -R mysql:mysql /usr/local/mysql
5.编辑cnf文件
#root@debian11:/usr/local/mysql# vi my3306.cnf
[mysql]
socket = /usr/local/mysql/mysql3306.sock
[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql3306.sock
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/mysql.pid
6.启动实例
/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my3306.cnf &
7.初始化数据库
# 初始化数据库
/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my3306.cnf --initialize --user=mysql
# 查看临时密码
grep 'temporary password' /usr/local/mysql/data/error.log
# 启动服务
/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/my3306.cnf --user=mysql &
8.测试连接
/usr/local/mysql# /usr/local/mysql/bin/mysql -uroot -p -S /usr/local/mysql/mysql3306.sock