如何从 CentOS 源代码编译和安装 MySQL 5.7.29 呢, 下面做个简单明了的过程记录, 希望对大家有用.
安装编译工具和必要的包:
yum install gcc gcc-c++ ncurses-devel cmake bison
下载 MySQL 源代码
wget https://github.com/mysql/mysql-server/archive/mysql-5.7.29.tar.gz
编译并安装 MySQL
- /usr/sbin/groupadd MySQL
- /usr/sbin/useradd -g MySQL MySQL
- cd /tmp
- tar xvf MySQL-5.7.29.tar.gz
- cd MySQL-5.7.29/
- cmake -DCMAKE_INSTALL_PREFIX=/usr/local/MySQL \
- -DMYSQL_UNIX_ADDR=/tmp/MySQL.sock \
- -DDEFAULT_CHARSET=utf8 \
- -DDEFAULT_COLLATION=utf8_general_ci \
- -DWITH_EXTRA_CHARSETS=all \
- -DWITH_MYISAM_STORAGE_ENGINE=1 \
- -DWITH_INNOBASE_STORAGE_ENGINE=1 \
- -DWITH_MEMORY_STORAGE_ENGINE=1 \
- -DWITH_READLINE=1 \
- -DENABLED_LOCAL_INFILE=1 \
- -DMYSQL_DATADIR=/var/MySQL/data \
- -DMYSQL_USER=MySQL
开始编译安装
- make
- make install
配置 MySQL
mysql_secure_installation
设置 MySQL
- chmod +w /usr/local/MySQL
- chown -R MySQL:MySQL /usr/local/MySQL
- ln -s /usr/local/MySQL/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16
- mkdir -p /var/MySQL/
- mkdir -p /var/MySQL/data/
- mkdir -p /var/MySQL/log/
- chown -R MySQL:MySQL /var/MySQL/
- cd support-files/
- cp my-large.cnf /var/MySQL/my.cnf
- cp MySQL.server /etc/rc.d/init.d/mysqld
- /usr/local/MySQL/scripts/mysql_install_db \
- -defaults-file=/var/MySQL/my.cnf \
- -basedir=/usr/local/MySQL \
- -datadir=/var/MySQL/data \
- -user=MySQL
- chmod +x /etc/init.d/mysqld
- vi /etc/init.d/mysqld
- basedir=/usr/local/MySQL
- datadir=/var/MySQL/data
在系统启动时运行 MySQL:
- chkconfig -add mysqld
- chkconfig -level 345 mysqld on
启动服务:
service mysqld start
来源: http://www.linuxidc.com/Linux/2020-01/162178.htm