Mysql源码安装

kiloyp

一、准备工作
1、下载两个源码包
cmake-3.5.0-rc3.tar.gz
mysql-5.6.22.tar.gz
在操作系统上安装gcc gcc-c++和开发组件包
#yum -y install make gcc-c++ cmake bison-devel  ncurses-devel gccautoconf automake zlib* fiex* libxml* libmcrypt* libtool-ltdl-devel*
2、
二、安装cmake和mysql
解压cmake
#tar -zxvf cmake-3.5.0-rc3.tar.gz
#./configure
#make && make install
创建mysql用户和mysql组并把用户加到组里

# groupadd -r mysql
# useradd -r -g mysql -s /sbin/nologin mysql
#mkdir -p /mydata/data
#tar -xf mysql-5.6.22.tar.gz
# cd mysql-5.6.22
#cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/mydata/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

#make && make install

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

#cd /usr/local/mysql

#scripts/mysql_install_db --user=mysql --datadir=/mydata/data/

# cp support-files/my-default.cnf /etc/my.cnf

# cp support-files/mysql.server /etc/init.d/mysqld

# chkconfig --add mysqld

# service mysqld start

添加自动执行mysql脚本

# vim /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin
# . /etc/profile.d/mysql.sh
进入mysql
#mysql