blob: 755e1b3eebae5a2b7b26d1ffc1ce93eb3aad405d (
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" "$MYSQL_SAT_PASS"
mysql_add_user openslx openslx ALL "$MYSQL_OPENSLX_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
}
|