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

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

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;