blob: fccba99c9cb436eb9cd74788231bf9e449902d4a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
add_mysql_dbs_users() {
# Now comes mysql stuff; adding databases:
mysql_add_db openslx
mysql_add_db sat
# $1=user, $2=database, $3=privileges, $4=password
mysql_add_user sat sat "DELETE, INSERT, SELECT, UPDATE, ALTER, CREATE, DROP" "$RANDOM"
mysql_add_user openslx openslx "ALL" "$TEMP_DB_PASS"
# $1=user, $2=database, $3=privileges
mysql_add_privs "openslx" "sat.*" "ALL"
mysql_add_privs "sat" "openslx.location" "SELECT, CREATE"
# $1=sql-dumpfile, $2=database
mysql_import_dump "$BASEDIR/static_files/db_sat_dump.sql" sat
}
|