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

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