15 lines
556 B
Bash
15 lines
556 B
Bash
#!/bin/bash
|
|
set -e
|
|
|
|
mysql --protocol=socket -uroot -p"${MYSQL_ROOT_PASSWORD}" mysql <<-EOSQL
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
|
|
ON gis_spbu.* TO '${MYSQL_USER}'@'%';
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
|
|
ON data_jalan.* TO '${MYSQL_USER}'@'%';
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
|
|
ON webgis.* TO '${MYSQL_USER}'@'%';
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
|
|
ON webgisuas.* TO '${MYSQL_USER}'@'%';
|
|
FLUSH PRIVILEGES;
|
|
EOSQL
|