前提:centos 6.6已經做了basic安裝,ip和主機名已設定,mysql原始碼檔案 mysql-5.6.23.tar.gz放在/root下,
cmake-2.8.10.2.tar.gz放在/root下.
os:centos 6.6
mysql:5.6.23

---以下內容放在一個文字下,sh執行即可:
#!/bin/bash
yum -y remove mysql mysql-server mysql-libs compat-mysql51
yum -y install gcc gcc-c++

tar -zxvf /root/cmake-2.8.10.2.tar.gz
cd /root/cmake-2.8.10.2
./bootstrap
gmake
gmake install

tar -zxvf /root/mysql-5.6.23.tar.gz
cd /root/mysql-5.6.23
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.6 -DSYSCONFDIR=/etc -DMYSQL_DATADIR=/data/mysqldata -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_USER=mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
gmake
gmake install

cat > /etc/my.cnf <<EOF
[mysqld]
basedir = /usr/local/mysql5.6
datadir = /data/mysqldata

pid-file=/data/mysqldata/mysql01.pid
port = 3306
wait-timeout = 30
max_connections = 512
max_connect_errors = 10000000

log_bin=/data/mysqllog/mysql01.log
log_error=/data/mysqllog/mysql01.err

server-id=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
binlog_format=row
innodb_support_xa=1

innodb_buffer_pool_size=500M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=256M
innodb_log_files_in_group=3
[mysqld_safe]
log-error=/data/mysqllog/mysqld.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
EOF

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

mkdir -p /data/mysqldata
mkdir -p /data/mysqllog
chown -R mysql.mysql /data/mysqllog /data/mysqldata

cd /usr/local/mysql5.6/
./scripts/mysql_install_db --datadir=/data/mysqldata --basedir=/usr/local/mysql5.6 --defaults-file=/etc/my.cnf --user=mysql

cp /usr/local/mysql5.6/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod 755 /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

echo "export PATH=\$PATH:/usr/local/mysql5.6/bin" >>/etc/profile
. /etc/profile

service mysqld start

mysqladmin -u root password 'password'

cent os 6.6 x64 自動原始碼安裝mysql 5.6指令碼

相關文章