linux源码安装mysql

# 更新系统包
sudo apt-get update
sudo apt-get upgrade

# 安装必要的依赖包
sudo apt-get install build-essential cmake libncurses5-dev libssl-dev

# 下载MySQL源码包
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.26.tar.gz

# 解压源码包
tar -zxvf mysql-8.0.26.tar.gz
cd mysql-8.0.26

# 创建编译目录
mkdir build
cd build

# 配置编译选项
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
         -DWITH_SSL=yes \
         -DWITH_EMBEDDED_SERVER=no \
         -DWITH_UNIT_TESTS=off

# 编译源码
make -j $(nproc)

# 安装MySQL
sudo make install

# 创建MySQL用户和组
sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql

# 初始化MySQL数据目录
sudo mkdir /usr/local/mysql/data
sudo chown -R mysql:mysql /usr/local/mysql
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql

# 启动MySQL服务
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

# 创建MySQL配置文件
sudo tee /etc/my.cnf <<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
user=mysql
EOF

# 启动MySQL服务
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

# 确保所有依赖包已安装
sudo apt-get install build-essential cmake libncurses5-dev libssl-dev

# 清理之前的编译文件并重新编译
make clean
make -j $(nproc)

# 确保数据目录不存在
sudo rm -rf /usr/local/mysql/data

# 重新初始化数据目录
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql

# 检查配置文件
sudo grep -v '^#' /etc/my.cnf | grep -v '^$'

# 检查端口是否被占用
sudo netstat -tuln | grep 3306

# 修改配置文件或释放端口后重新启动
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &