Centos6.5下Mysql5.5一键安装脚本

T-hua

软件版本
Linux：Centos6.5
Mysql：mysql-5.5.20
#!/bin/bash   
#Auth By xiaohua
#Mysql auto install
clear
path_mysql=/usr/local/mysql
path_mysql_data=/usr/local/mysql/data
soft_path=/usr/local/src
install_mysql(){
    yum install gcc-c++ cmake ncurses-devel -y
    tar xf mysql-5.5.20.tar.gz -C /usr/local/src/
    useradd -M -s /sbin/nologin mysql
    cd /usr/local/src/mysql-5.5.20/
    cmake -DCMAKE_INSTALL_PREFIX=$path_mysql
          -DMYSQL_UNIX_ADDR=/tmp/mysql.sock  
          -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
          -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=$path_mysql_data  
          -DMYSQL-USER=mysql
          make -j 4 && make install
    chown -R mysql:mysql /usr/local/mysql/
    cat $path_mysql/support-files/my-small.cnf >/etc/my.cnf
    cat $path_mysql/support-files/mysql.server >/etc/init.d/mysqld
    sed -i '46,+1d' /etc/init.d/mysqld
    sed -i '46ibasedir='$path_mysql'' /etc/init.d/mysqld
    sed -i '47idatadir='$path_mysql_data'' /etc/init.d/mysqld
    chmod +x /etc/init.d/mysqld
    $path_mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=$path_mysql --datadir=$path_mysql_data --user=mysql &
    ln -s $path_mysql/bin/* /bin/
    service mysqld start
    chkconfig mysqld on
    mysqladmin -u root password '123456'
}
install_mysql
echo "Please executive mysql_secure_installation"
注：此脚本没有进行相关优化，仅供实验时快速安装使用，关于mysq优化，请点击查看或留言，谢谢。