blob: 09eec240a681151bb6ee5970f4c66b51ae1c4031 (
plain) (
tree)
|
|
add_mysql_dbs_users() {
# Now comes mysql stuff; adding databases:
mysql_add_db openslx
mysql_add_db sat
# $1=sql-dumpfile, $2=database
mysql_import_dump "$BASEDIR/static_files/db_sat_dump.sql" sat
mysql_import_dump "$BASEDIR/static_files/db_openslx_dump.sql" openslx
# $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"
}
|