cent os 6.6 x64 自动源码安装mysql 5.6脚本

前提: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'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-1764540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28539951/viewspace-1764540/