安装包
已经编译好的二进制文件
1.maria-10.2.8
链接:http://pan.baidu.com/s/1nv3LrSX 密码:xyop
安装路径:/usr/locl/mysql
数据库文件路径: /app/mysqldb
日志文件路径:/var/log/mariadb/mariadb.log
2.maria-5.5.73
链接:http://pan.baidu.com/s/1geG88Un 密码:vfdu
安装路径:/usr/locl/mysql
数据库文件路径: /var/lib/mysql
日志文件路径:/var/log/mariadb.log
安装脚本
#!/bin/bash
# ------------------------------------------
# Filename: mysql_install.sh
# Date: 2017-10-12
# Revision:
# Author: 木子甘
# ID:16
# Description:mysql_install,可以自动区分centos版本
# ------------------------------------------
#判断版本
Version=`sed -r "s/.* ([^ ])[.].*/\1/" /etc/redhat-release`
lib_6=/var/lib/mysql
lib_7=/app/mysqldb
#1.卸载已经有的maria程序
rpm -e `rpm -qa mysql*` &>/dev/null
rpm -e `rpm -qa maria*` &>/dev/null
#2.创建系统账户mysql
if [ "$Version" -eq 7 ] ; then
useradd -r -m -d $lib_7 -s /sbin/nologin mysql
elif [ "$Version" -eq 6 ] ; then
useradd -r -m -d $lib_6 -s /sbin/nologin mysql
fi
#3.解压二进制文件到二进制程序的目标路径
if [ "$Version" -eq 7 ] ; then
tar -xvf mariadb-10.2.8-linux-x86_64.tar.gz -C /usr/local/ &>/dev/null
mv /usr/local/mariadb-10.2.8-linux-x86_64 /usr/local/mysql &>/dev/null
elif [ "$Version" -eq 6 ] ; then
tar -xvf mariadb-5.5.57-linux-x86_64.tar.gz -C /usr/local/ &>/dev/null
mv /usr/local/mariadb-5.5.57-linux-x86_64 /usr/local/mysql &>/dev/null
fi
#4.数据库文件创建
cd /usr/local/mysql
if [ "$Version" -eq 7 ] ; then
scripts/mysql_install_db --user=mysql --datadir=$lib_7 &>/dev/null
else
scripts/mysql_install_db --user=mysql --datadir=$lib_6 &>/dev/null
fi
#5.配置文件创建 配置文件中要指向数据库文件
mkdir /etc/mysql/
cp /usr/local/mysql/support-files/my-huge.cnf /etc/mysql/my.cnf
if [ "$Version" -eq 7 ] ; then
sed -r -i.bak "/^\[mysqld\]/s#.*#[mysqld] \n datadir = $lib_7 \n innodb_file_per_table = on \n skip_name_resolve = on#" /etc/mysql/my.cnf
elif [ "$Version" -eq 6 ] ; then
sed -r -i.bak "/^\[mysqld\]/s#.*#[mysqld] \n datadir = $lib_6 \n innodb_file_per_table = on \n skip_name_resolve = on#" /etc/mysql/my.cnf
fi
#6.日志文件创建
if [ "$Version" -eq 7 ] ; then
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown mysql:mysql -R /var/log/mariadb
elif [ "$Version" -eq 6 ] ; then
touch /var/log/mysqld.log
chown mysql:mysql /var/log/mysqld.log
fi
#7.服务脚本创建
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
#8.修改PATH路径
echo "PATH=/usr/local/mysql/maria_5/bin/:$PATH" >> /etc/profile.d/newvar.sh
#9.启动mysql服务
service mysqld restart
#10.安全脚本运行
unset Version lib_6 lib_7