mysql-5.6源码安装

1 yum -y install gcc gcc-c++ autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake

2 cd /

3 mkdir /opt/mysql
mkdir /opt/mysql/data/
mkdir/opt/mysql/etc

4 groupadd mysql

5 useradd mysql -g mysql -M -s /sbin/nologin

6 rz

7 tar zxf mysql-5.6.24.tar

8 cd mysql-5.6.24

9 cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql/ -DMYSQL_DATADIR=/opt/mysql/data/ -DSYSCONFDIR=/opt/mysql/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/opt/mysql/etc/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

10 make -j6

11 make install

12 cd /opt/mysql
chown -R mysql.mysql /opt/mysql
cp /opt/mysql/support-files/my-default.cnf /etc/my.cnf
cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld

13 vi /opt/mysql/etc/my.cnf
[mysqld]
basedir = /opt/mysql
datadir = /opt/mysql/data
port = 3306
server_id = …
socket = /opt/mysql/etc/mysql.sock
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

14 /opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data
或cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld

15 rm -f my.cnf
rm -f /etc/my.cnf.rpmsave

16 vi ~/.bash_profile
添加：
export PATH=$PATH:/opt/mysql/bin
wq!

17 source ~/.bash_profile

18 /etc/init.d/mysqld start

19 mysql

20 set password=password(‘yang123’);