diff options
Diffstat (limited to 'setup/projects/adei/files/adei_init/mysql/pma.sql')
-rw-r--r-- | setup/projects/adei/files/adei_init/mysql/pma.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/setup/projects/adei/files/adei_init/mysql/pma.sql b/setup/projects/adei/files/adei_init/mysql/pma.sql new file mode 100644 index 0000000..884284f --- /dev/null +++ b/setup/projects/adei/files/adei_init/mysql/pma.sql @@ -0,0 +1,17 @@ +GRANT ALL ON `adei_%`.* TO 'adei'@'%'; + +CREATE USER IF NOT EXISTS 'pma'@'%' IDENTIFIED BY '@PWD@'; +ALTER USER 'pma'@'%' IDENTIFIED BY '@PWD@'; + +GRANT USAGE ON mysql.* TO 'pma'@'%'; +GRANT SELECT ( +Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, +Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, +File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, +Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, +Execute_priv, Repl_slave_priv, Repl_client_priv +) ON mysql.user TO 'pma'@'%'; +GRANT SELECT ON mysql.db TO 'pma'@'%'; +#GRANT SELECT ON mysql.host TO 'pma'@'%'; +GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'%'; +GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'%'; |