一.mysql源码安装
下载mysql源码数据包,解压
下载cmake
[root@server1 mysql-5.7.31]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci ##指定安装路径等配置参数
yum install -y gcc-c++ ##安装c++
[root@server1 mysql-5.7.31]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_BOOST=boost/boost_1_59_0 ###指定boost路径
yum install -y ncurses-devel
rm -f CMakeCache.txt
yum install -y bison
[root@server1 mysql-5.7.31]# make ###编译
[root@server1 mysql-5.7.31]# make install ###安装
二.mysql安装配置
cd /usr/local/mysql/
cd support-files/
cp mysql.server /etc/init.d/mysqld ###复制脚本内容到mysqld
ll /etc/init.d/mysqld ###查看是否有执行权限
useradd -M -d /data/mysql -s /sbin/nologin mysql ###添加mysql用户
mkdir -p /data/mysql
chown mysql.mysql /data/mysql/ ###修改目录权限
cd /usr/local/mysql/bin
[root@server1 bin]# pwd ------> /usr/local/mysql/bin
[root@server1 bin]# vim ~/.bash_profile ###编辑配置文件
****************
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin ###添加目录
*****************
[root@server1 bin]# source ~/.bash_profile ###重启
[root@server1 ~]# which mysql ------->/usr/local/mysql/bin/mysql