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