MySQL自動安裝指令碼(Ubuntu 與 CentOS 64)

Ubuntu MySQL自動化安裝指令碼

#/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 
 

CentOS 64 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 </etc/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;

《MySQL權威指南(原書第2版)》清晰中文掃描版 PDF

源碼包編譯安裝MySQL 5.6指令碼

MySQL源碼安裝