MySQL自动化安装脚本(ubuntu and centos64)

这篇文章主要为大家详细介绍了MySQL自动化安装脚本(ubuntu and centos64)，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

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

注：关于MySQL自动化安装脚本(ubuntu and centos64)的内容就先介绍到这里，更多相关文章的可以留意