mysql一键安装各种版本操作

[root@dns soft]# cat auto_install_mysql.sh #!/bin/sh set -x groupadd mysql useradd -g mysql mysql #mkdir /usr/local/mysql mysql_dir1=/data/soft/mysql-5.1.53 mysql_dir2=/usr/local/mysql yum install -y gcc gcc-c++ autoconf automake ncurses-devel zlib zlib-devel openssl openssl--devel pcre pcre-devel #编译安装 cd $mysql_dir1 ./configure --prefix=/usr/local/mysql --datadir=/data/mysql_data --with-charset=utf8 --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-ssl --with-embedded-server --enable-local-infile --enable-assembler --with-plugins=innobase --with-plugins=partition make make install #创建mysql数据库服务器的配置文件及其权限 cd $mysql_dir1/support-files/ cp my-medium.cnf /etc/my.cnf cp mysql.server /etc/rc.d/init.d/mysqld chown root.root /etc/rc.d/init.d/mysqld chmod 755 /etc/rc.d/init.d/mysqld #创建授权表 cd $mysql_dir2/bin/ ./mysql_install_db --user=mysql --datadir=/data/mysql_data #修改目录权限 cd $mysql_dir2 chown -R root . #chown -R mysql var chgrp -R mysql . chown -R mysql.mysql /data/mysql_data #在启动服务之前要在配置文件中的[mysqld]里添加datadir=/data/mysql_data这个条件 #否则会报：Starting MySQL.Manager of pid-file quit without updating fi[FAILED] #错误信息。 #cd $mysql_dir2/bin #./mysql -u <<EOF #delete from mysql.user where host='localhost' and user=''; #set password for 'root'@'localhost'=password('123456'); #flush privileges; #EOF chkconfig --add mysqld set +x 编译参数说明 1 2 3 4 5 6 7 8 9 10 11 12 13 ./configure --prefix=/usr/local/mysql //MySQL安装目录 --datadir=/mydata //数据库存放目录 --with-charset=utf8 //使用UTF8格式 --with-extra-charsets=complex //安装所有的扩展字符集 --enable-thread-safe-client //启用客户端安全线程 --with-big-tables //启用大表 --with-ssl //使用SSL加密 --with-embedded-server //编译成embedded MySQL library (libmysqld.a), --enable-local-infile //允许从本地导入数据 --enable-assembler //汇编x86的普通操作符，可以提高性能 --with-plugins=innobase //数据库插件 --with-plugins=partition //分表功能，将一个大表分割成多个小表 mysql5.1编译安装第二个版本 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 #/usr/local/bin echo "create mysql user..." useradd -M -s /sbin/nologin mysql echo "install environment..." yum install  gcc gcc-c++ autoconf automake ncurses-devel zlib zlib-devel openssl openssl--devel pcre pcre-devel  libtermcap  libtermcap-devel imake  libtool  m4 libstdc++-devel  -y echo "download mysql..." if [ ! -f mysql-5.1.72.tar.gz ];then wget http://mirrors.sohu.com/mysql/MySQL-5.1/mysql-5.1.72.tar.gz else echo "mysql-5.1.72.tar.gz is exits" fi echo "install mysql..." if [ ! -d /usr/local/mysql ];then mkdir /usr/local/mysql fi tar -xvf mysql-5.1.72.tar.gz cd mysql-5.1.72 ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --localstatedir=/usr/local/mysql/var --with-tcp-port=3306 --without-debug --enable-assembler --sysconfdir=/etc --with-mysqld-user=mysql --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=gbk,utf8 --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-pthread --enable-thread-safe-client --with-big-tables --with-plugins=all    make && make install cp -v /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf cp -v /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld chmod 711 /etc/init.d/mysqld chown mysql:mysql /etc/init.d/mysqld chkconfig -add mysqld chkconfig --level 35 mysqld on /usr/local/mysql/bin/mysql_install_db --user=mysql service mysqld start /usr/bin/mysqladmin -u root password '123456' ln -s /usr/local/mysql/bin/mysql /usr/local/sbin/mysql Mysql5.5编译安装脚本 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 #!/bin/sh set -x groupadd mysql useradd -g mysql mysql mkdir /usr/local/mysql5.5 mysql_dir1=./mysql-5.5.24/ mysql_dir2=/usr/local/mysql5.5/ mysql_data_dir=/data/mysql_data_3308/ mysql_port=3308 yum install -y gcc gcc-c++ autoconf automake ncurses-devel zlib zlib-devel openssl openssl--devel pcre pcre-devel cmake ncurses-devel bison #编译安装 cd ${mysql_dir1} cmake  -DCMAKE_INSTALL_PREFIX=$mysql_dir2 -DMYSQL_UNIX_ADDR=/tmp/mysql$mysql_port.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_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=$mysql_data_dir -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=$mysql_port make -j 8 make install #创建mysql数据库服务器的配置文件及其权限 cd .. cp ${mysql_dir1}support-files/my-innodb-heavy-4G.cnf /etc/my${mysql_port}.cnf #cp ${mysql_dir1}support-files/mysql.server /etc/rc.d/init.d/mysqld #chown root.root /etc/rc.d/init.d/mysqld #chmod 755 /etc/rc.d/init.d/mysqld #创建授权表 ${mysql_dir2}scripts/mysql_install_db --defaults-file=/etc/my${mysql_port}.cnf  --user=mysql --datadir=$mysql_data_dir --basedir=$mysql_dir2 #修改目录权限 chown -R root  $mysql_dir2 #chown -R mysql var chgrp -R mysql $mysql_dir2 chown -R mysql.mysql $mysql_data_dir #在启动服务之前要在配置文件中的[mysqld]里添加datadir=$mysql_data_dir这个条件 #否则会报：Starting MySQL.Manager of pid-file quit without updating fi[FAILED] #错误信息。 #cd $mysql_dir2/bin #./mysql -u <<EOF #delete from mysql.user where host='localhost' and user=''; #set password for 'root'@'localhost'=password('123456'); #flush privileges; #EOF #chkconfig --add mysqld set +x You have mail in /var/spool/mail/root http://链接：http://pan.baidu.com/share/link?shareid=2677446066&uk=2637181905 密码：e4oh mysql5.5编译安装脚本第二版 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 #!/bin/sh echo "create mysql user..." useradd -M -s /sbin/nologin mysql echo "install environment..." yum -y install ntp vim-enhanced gcc gcc-c++ flex bison autoconf automake bzip2-devel ncurses-devel zlib-devel libjpeg-devel libpng-devel libtiff-devel freetype-devel libXpm-devel gettext-devel  pam-devel libtool libtool-ltdl openssl openssl-devel fontconfig-devel libxml2-devel curl-devel  libicu libicu-devel libmcrypt libmcrypt-devel libmhash libmhash-devel echo "install cmake..." wget http://www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz tar -xvf cmake-2.8.7.tar.gz cd cmake-2.8.7 sh configure make&&make install cd .. echo "install mysql5.5..." if [ ! -d /usr/local/mysql ];then mkdir -pv /usr/local/mysql fi if [ ! -f mysql-5.5.39.tar.gz ];then wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.39.tar.gz tar -xvf mysql-5.5.39.tar.gz cd mysql-5.5.39 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0 make&&make install echo "mysql make install complete..." echo "modify mysql  configuration file..." cp -vrf  support-files/my-medium.cnf /etc/my.cnf chmod +x /usr/local/mysql chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /usr/local/mysql/data echo "StartUp Actions Manager..." cp -vrf support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld chkconfig --add mysqld chkconfig mysqld on echo "initialize mysql..." chmod a+x /usr/local/mysql/scripts/mysql_install_db /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data service mysqld start /usr/bin/mysqladmin -u root password '123456' ln -s /usr/local/mysql/bin/mysql /usr/local/sbin/mysql echo "mysql5.5 install all..." echo "the root passwd 123456" else echo "mysql-5.5.39.tar.gz is exits" fi mysql5.5,mysql5.6可选版本安装脚本 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 #!/bin/sh echo "create mysql user..." useradd -M -s /sbin/nologin mysql echo "install environment..." yum -y install ntp vim-enhanced gcc gcc-c++ flex bison autoconf automake bzip2-devel ncurses-devel zlib-devel libjpeg-devel libpng-devel libtiff-devel freetype-devel libXpm-devel gettext-devel  pam-devel libtool libtool-ltdl openssl openssl-devel fontconfig-devel libxml2-devel curl-devel  libicu libicu-devel libmcrypt libmcrypt-devel libmhash libmhash-devel echo "install cmake..." wget http://www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz tar -xvf cmake-2.8.7.tar.gz cd cmake-2.8.7 sh configure make&&make install cd .. echo "install mysql5.5 or mysql5.6..." if [ ! -d /usr/local/mysql ];then mkdir -pv /usr/local/mysql fi if [ ! -f mysql-5.5.39.tar.gz ] || [ ! -f mysql-5.6.20.tar.gz];then echo "install mysql5.5 input 1,install mysql5.6 input 2:" read num case $num in 1) wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.39.tar.gz tar -xvf mysql-5.5.39.tar.gz cd mysql-5.5.39 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0 make&&make install  echo "mysql make install complete..." echo "modify mysql  configuration file..." cp -vrf  support-files/my-medium.cnf /etc/my.cnf cp -vrf  support-files/my-medium.cnf /etc/my.cnf chmod +x /usr/local/mysql chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /usr/local/mysql/data echo "StartUp Actions Manager..." cp -vrf support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld chkconfig --add mysqld chkconfig mysqld on echo "initialize mysql..." chmod a+x /usr/local/mysql/scripts/mysql_install_db /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data service mysqld start /usr/local/mysql/bin/mysqladmin -uroot password '123456' ln -s /usr/local/mysql/bin/mysql /usr/local/sbin/mysql echo "mysql5.5 install all..." echo "the root passwd 123456" ;; 2) wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.20.tar.gz tar -xvf  mysql-5.6.20.tar.gz cd mysql-5.6.20 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0 make&&make install  echo "mysql make install complete..." echo "modify mysql  configuration file..." cp -vrf  support-files/my-default.cnf /etc/my.cnf chmod +x /usr/local/mysql chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /usr/local/mysql/data echo "StartUp Actions Manager..." cp -vrf support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld chkconfig --add mysqld chkconfig mysqld on echo "initialize mysql..." chmod a+x /usr/local/mysql/scripts/mysql_install_db /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data service mysqld start /usr/local/mysql/bin/mysqladmin -uroot password '123456' ln -s /usr/local/mysql/bin/mysql /usr/local/sbin/mysql echo "mysql5.6 install all..." echo "the root passwd 123456" ;; *) echo "please input 1 or 2" exit 0 esac else echo "mysql-5.5.39.tar.gz is exits" fi