1 files changed, 67 insertions, 0 deletions
diff --git a/satellit_installer/includes/10-functions_mysql.inc b/satellit_installer/includes/10-functions_mysql.inc
new file mode 100644
index 0000000..5b99719
--- /dev/null
+++ b/satellit_installer/includes/10-functions_mysql.inc
@@ -0,0 +1,67 @@
+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
+}
+