path: root/satellit_installer/includes/10-handle_mysql.inc

mysql_add_db() {
	echo "# Creating mysql database $1..."
	echo "create database $1;" | mysql -u root 
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not create mysql database $1!"
	fi
}

mysql_delete_db() {
	# $1 database; $2 password
	echo "# Deleting mysql database $1..."
	echo "drop database if exists $1;"	| mysql -u root
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not delete mysql user $1!"
	fi

}

mysql_add_user() {
	# $1=user, $2=database, $3=privileges, $4=password
	echo "# Adding user $1 for database $2, privileges $3..."
	mysql -u root <<-CMDS
		CREATE USER '$1'@'localhost' IDENTIFIED BY '$4';
		GRANT $3 ON $2.* TO '$1'@'localhost';
	CMDS

	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not add mysql user!"
	fi
}

mysql_add_privs() {
	# $1=user, $2=database, $3=privileges
	echo "# Adding privileges $3 for user $1 on database $2..."
	mysql -u root <<-CMDS
		GRANT $3 ON $2 TO '$1'@'localhost';
	CMDS

	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not add privileges!"
	fi
}

mysql_delete_user() {
	# $1: mysql user, $2 password
	echo "# Deleting mysql user $1..."
	echo "drop user $1@localhost;"	| mysql -u root -p${2}
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not delete mysql user $1!"
	fi
}

mysql_import_dump() {
	# $1: dump file, $2: database
	echo "# Importing sql dump file $1..."
	mysql -u root -h localhost "$2" < "$1"
	ERR=$?
	if [ "$ERR" -ne 0 ]; then
		perror "Could not import sql dump file $1!"
	fi
}