#!/bin/bash
set -e
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin
export PATH
yum -y remove mysql*
yum install ncurses-devel libtool -y
cur_dir=$(pwd)
useradd mysql -s /sbin/nologin -M
if [ -d "/var/run/mysql" ]; then
echo "/var/run/mysql Already exists"
else
mkdir /var/run/mysql
fi
cd $cur_dir/src
tar xvf mysql-5.1.58.tar.gz
cd mysql-5.1.58
./configure \
--prefix=/opt/mysql/ \
--localstatedir=/home/mysql \
--enable-assembler \
--enable-thread-safe-client \
--enable-local-infile \
--with-pthread \
--with-ssl \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static \
--with-mysqld-user=mysql \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-extra-charsets=complex \
--with-plugins=innobase,myisam,myisammrg \
--with-big-tables \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--without-docs \
--without-man \
--with-embedded-server \
--with-readline
make && make install
cd $cur_dir/src
rm -rf mysql-5.1.58
cd /opt/mysql/
cp share/mysql/my-medium.cnf /etc/my.cnf
/opt/mysql/bin/mysql_install_db --user=mysql
chown -R root.mysql /opt/mysql
chown -R mysql.mysql /home/mysql/
chown -R mysql.mysql /var/run/mysql/
cp share/mysql/mysql.server /etc/init.d/mysql
chmod u+x /etc/init.d/mysql
chkconfig --level 345 mysql on
cat > /etc/ld.so.conf.d/mysql.conf<<EOF
/opt/mysql/lib/mysql
EOF
ldconfig
sed -i 's/skip-locking/skip-external-locking/g' /etc/my.cnf
echo "pid-file = /var/run/mysql/mysqld.pid" >> /etc/my.cnf
/etc/init.d/mysql start
bin/mysqladmin -u root password "123456"
echo "============================mysql intall completed========================="
/usr/local/mysql/bin/mysql_secure_installation
echo "============================mysql secure installation completed========================="
##如果安装完成了，要更改数据目录，请按以下操作
#停止mysql /etc/init.d/mysql stop
#将原来mysql数据目录中的数据移动到新目录中
#mv /home/mysql /data/mysql
#chown -R mysql:mysql /data/mysql
#修改/etc/init.d/mysql 找到datadir=/data/mysql 右边为新的路径
#修改my.cnf 添加 datadir=/data/mysql
#启动服务即可
