Ubuntu20 编译安装MySQL5.6
1、下载源码包
wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.6/mysql-5.6.51.tar.gz
2、添加用户组
useradd mysql -M -d / -s /usr/sbin/nologin
3、安装编译依赖包
sudo apt-get install make cmake gcc g++ bison libncurses5-dev build-essential bison openssl openssl-server build-essential libssl-dev pkg-config -y
4、配置编译参数
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DMYSQL_USER=mysql \
5、编译安装
make -j 8 && make -j 8 install # -j 开启多线程编译,根据CPU核数而定
6、复制配置文件等
#copy默认配置
cp support-files/my-default.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
7、初始化安装
#MySQL初始化安装
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
8、设置开机自启参数
#设置开机启动
chmod +x /etc/init.d/mysqld
update-rc.d /etc/init.d/mysqld defaults