centos6编译安装MySQL

yum -y install gcc gcc-c++ autoconf* automake* zlib* libxml* ncurses-devel* libgcrypt* libtool* openssl*

yum -y install cmake

groupadd -r mysql
useradd -r -g mysql -s /sbin/nologin -M mysql

mkdir -p /opt/mysql
mkdir -p /opt/data

chown mysql:mysql -R /opt/mysql/
chown mysql:mysql -R /opt/data/

cd /opt/software

wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.28.tar.gz

tar zxvf mysql-5.6.28.tar.gz

cd mysql-5.6.28

cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql \
-DMYSQL_DATADIR=/opt/data \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

# make clean
# rm CMakeCache.txt

make && make install && echo OK

cd /opt/mysql

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

scripts/mysql_install_db --user=mysql --basedir=/opt/mysql/ --datadir=/opt/data/

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

vim /etc/profile

PATH=/opt/mysql/bin:/opt/mysql/lib:$PATH
export PATH

source /etc/profile

/etc/init.d/mysql start

mysqladmin -u root password 123456

mysqladmin -u root -p password abcdef

mysql -u root -p

mysql>Grant all privileges on *.* to 'root'@'%' identified by 'youpassword' with grant option;
mysql> flush privileges;