diff options
author | Simon Rettberg | 2023-10-19 13:22:27 +0200 |
---|---|---|
committer | Simon Rettberg | 2023-10-19 13:22:27 +0200 |
commit | f3ce2e1cbf6368a0e3bd176c59f0d0ab7cadd6c7 (patch) | |
tree | 64e31708c54461caf65710578d3fd1dc037bf266 /satellit_installer/includes/10-functions_mysql.inc | |
parent | [SSPS] issue: lightred for better readablity on black background (diff) | |
download | setup-scripts-f3ce2e1cbf6368a0e3bd176c59f0d0ab7cadd6c7.tar.gz setup-scripts-f3ce2e1cbf6368a0e3bd176c59f0d0ab7cadd6c7.tar.xz setup-scripts-f3ce2e1cbf6368a0e3bd176c59f0d0ab7cadd6c7.zip |
[SSPS] Modernize; switch default user to openslx + sudo
Diffstat (limited to 'satellit_installer/includes/10-functions_mysql.inc')
-rw-r--r-- | satellit_installer/includes/10-functions_mysql.inc | 67 |
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 +} + |