一、准备编译环境,安装所需依赖包
yum groupinstall 'Development' -y
yum install openssl openssl-devel zlib zlib-devel -y
yum install readline-devel pcre-devel ncurses-devel bison-devel cmake -y
二、编译安装
1、使用cmake编译,cmake编译方式不同于make,对比如下:
make:
./configure
./configure --help
cmake:
cmake .
cmake . -LH or ccmake .
2、编译选项
指定安装路径常用的选项
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/data/mysql
-DSYSCONFDIR=/etc
存储引擎配置:
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITH_FEDERATED_STORAGE_ENGINE=1
若要明确指定不编译某个引擎,可以使用类似如下命令:
-DWITHOUT_
若要编译其他功能,如SSL等,则可以使用如下选项来实现编译时使用某功能或不使用:
-DWITH_READLINE=1
-DWITH_SSL=system
-DWITH_ZLIB=system
-DWITH_LIBWRAP=0
其他常用选项:
-DMYSQL_TCP_PORT=3306
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock
-DENABLED_LOCAL_INFILE=1
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_DEBUG=0
-DENABLE_PROFILING=1
具体编译选项可以参考官方文档http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html
如要清除编译后生成的文件可以使用make clean命令
编译之后就可以make && make install安装了
三、配置MySQL
1、为MySQL提供账号,以安全方式运行进程,修改MySQL安装目录属主属组
useradd -r -s /sbin/nologin -M mysql
chown -R mysql:mysql /usr/local/mysql/
2、初始化MySQL
MYSQL_$HOME/scripts/mysql_install_db --user=mysql --basedir=/usr/locla/mysql --datadir=/usr/local/mysql/data
3、 为MySQL提供主配置文件
cp support-files/my-default.cnf /etc/my.cnf
4、为MySQL提供sysv服务脚本、并添加到服务启动列表
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld
5、将MySQL MAN手册添加到MAN搜索路径,修改/etc/man.conf添加
MANPAN /usr/local/mysql/man
6、输出MySQL头文件至系统头文件路径
ln -sv /usr/local/mysql/include/ /usr/include/mysql
7、输出MySQL库文件到系统查找路径,并让系统重新载入系统库
echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
ldconfig
8、修改环境变量加入MySQL,编辑/etc/profile添加路径、并重新载入
export PATH="$PATH:/usr/local/mysql/bin"
source /etc/profile
9、至此安装结束,启动MySQL
service mysqld start
以上内容就是小编跟大家分享的RHEL6.5编译安装MySQL5.6.26教程,希望大家喜欢。

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Linux new version
SublimeText3 Linux latest version

SublimeText3 Chinese version
Chinese version, very easy to use

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Mac version
God-level code editing software (SublimeText3)
