centos 7 mysql 编译安装_CentOS7 编译安装 MySQL5.7

男娘i 2022-10-26 14:23 35阅读 0赞

添加 mysql 用户(若存在，则跳过此步骤)

/usr/sbin/useradd -s /sbin/nologin mysql

创建数据库目录:

mkdir -p /data/mysql/data

chown -R mysql:mysql /data/mysql

编译 mysql 所需的程序或文件:

yum install gcc gcc-c++ cmake ncurses-devel bison

下载 mysql 源码包

cd /usr/local

\# wget http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.16.tar.gz

\# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.27.tar.gz

解压源码到当前目录

tar -zxvf mysql-5.7.27.tar.gz

设置安装参数

\# 切换到 mysql 目录

cd mysql-5.7.27

\# 设置参数

cmake -DMYSQL\_USER=mysql -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql-5.7.27 -DINSTALL\_DATADIR=/data/mysql/data -DMYSQL\_UNIX\_ADDR=/tmp/mysqld.sock -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DEXTRA\_CHARSETS=all -DWITH\_EMBEDDED\_SERVER=1 -DENABLED\_LOCAL\_INFILE=1 -DWITH\_MYISAM\_STORAGE\_ENGINE=1 -DWITH\_INNOBASE\_STORAGE\_ENGINE=1

编译 mysql

make

make install

设置参数文件

chown -R mysql:mysql /usr/local/mysql-5.7.27

cp /usr/local/mysql-5.7.27/support-files/my-default.cnf /etc/my.cnf

cp /usr/local/mysql-5.7.27/support-files/mysql.server /etc/init.d/mysqld

chmod a+x /etc/init.d/mysqld

开机启动

chkconfig --level 345 mysqld on

设置环境变量

echo "export PATH=/usr/local/mysql-5.7.27/bin/:$PATH" >> /etc/profile

source /etc/profile

\# 查看是否写进了 /etc/profile 文件

cat /etc/profile

设置软链接

/usr/local/mysql-5.7.27/scripts/mysql\_install\_db --user=mysql --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-5.7.27 --datadir=/data/mysql/data

\# 错误提示1：-bash: /usr/local/mysql-5.7.27/scripts/mysql\_install\_db: Permission denied

\# 解决，提供执行权限创建目录

chmod a+x /usr/local/mysql-5.7.27/scripts/mysql\_install\_db

\# 错误提示2：FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql-8.0.16/scripts/mysql\_install\_db

\# 解决，安装 autoconf 库

yum -y install autoconf

在 /etc/my.cnf 配置文件中写入参数

vim /etc/my.cnf

\# 添加以下内容:

\[mysqld\]

basedir=/usr/local/mysql-5.7.27

datadir=/data/mysql/data