Mysql 5.6.12源码安装

CentOS是最小安装

所以先把安装环境补上

安装编译工具

yum install gcc gcc-c++ make cmake perl bison ncurses-devel

编译安装MySQL

/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar zxvf mysql-5.6.12-source.tar.gz 
cd mysql-5.6.12
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=/home/mysql/data -DMYSQL_USER=mysql
make&&make install

初始化，权限设制，

chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib/libmysqlclient.so.18
cd support-files/
cp my-default.cnf /etc/my.cnf
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/home/mysql/data --user=mysql

加入启动项

cp mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/init.d/mysqld
vi /etc/init.d/mysqld
（编辑此文件，查找并修改以下变量内容：）
	basedir=/usr/local/mysql
	datadir=/home/mysql/data
chkconfig --add mysqld
chkconfig --level 345 mysqld on
service mysqld start

设置管理密码

/usr/local/mysql/bin/mysqladmin password [new-password]