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

2023年 4月 23日 58.5k 0

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-

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;

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论