MySQL自动安装脚本(Ubuntu 与 CentOS 64)_MySQL

UbuntuCentOS

UbuntuMySQL自动化安装脚本

#/bin/bash
 function hasDpkg
{ 
    r=`dpkg -l | grep "$1"` 
    if [ -n "$r" ] 
      then 
        h=`dpkg -l | grep "ii  $1"` 
        if [ -n "$h" ] 
        then 
            return 1 
        else 
            return 0 
        fi 
      else 
        return 0 
      fi 
 } 
 
mysql="mysql-server-5.5" 
 
hasDpkg $mysql 
 
r=$? 
 
if [ $r -eq 1 ] 
 then 
    :
 #    echo "$mysql was installed" 
 else 
    echo "$mysql was not installed" 
    echo mysql-server mysql-server/root_password password adv | sudo debconf-set-selections 
    echo mysql-server mysql-server/root_password_again password adv | sudo debconf-set-selections  //设定root 用户及其密码
    apt-get install $mysql 
 fi 
 

CentOS64 mysql 自动化安装脚本
 
#/bin/bash
 function hasinstall
{
  r=$(rpm -qa "$1")
    if [ $r ]
    then
      return 1
  else
        return 0
  fi
 } 
 
mysql="mysql-server"
 
hasinstall $mysql 
 
r=$? 
 
if [ $r -eq 1 ] 
 then 
    :
    echo "$mysql was installed" 
 else 
    echo "$mysql was not installed"
    yum install mysql mysql-server mysql-devel
    service mysqld start
 fi
#add User to Mysql database
 echo "INFORM:Enter database root password"
 mysql -uroot -p -hlocalhost /cloud/mysql/adduser.sql
 

adduser.sql 脚本
 

insert ignore into mysql.user(Host,User,Password)
 values('localhost','loadserver','adv');
 flush privileges;
 
grant all privileges on *.* to loadserver@localhost identified by 'adv';
 
flush privileges;