源码编译安装MysqL

环境准备

准备一台Centos6或Centos7服务器

系统： Centos6.8 Centos7.5

内存：1G

cpu： 2核

IP地址: 10.0.0.21

上传MysqL源码包

# 解压mysql包
tar zxf mysql-5.6.38.tar.gz 
# 进入mysql包里
cd mysql-5.6.38

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

# 编译安装  指向mysql安装目录，官方推荐设为/usr
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

make 

编译时间比较漫长，耐心等待完即可…

make install

cd /usr/local/mysql/support-files/
cp my-default.cnf /etc/my.cnf 
cp mysql.server /etc/rc.d/init.d/mysql
cd ..
cd scripts/
cd /usr/local/
chown mysql.mysql -R mysql
cd scripts/
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
service mysqld start

Centos7
find / -name libmysqlclient.so.18

先查找libmysqlclient.so.18文件

ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/

service mysqld start

cd /usr/local/mysql/bin/
 ./mysql
 /usr/local/mysql/bin/mysql

vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin/
source /etc/profile