" ON `",gdb.Db,"`.* TO AS 'GRANT Statement (Reconstructed)' IF(gdb.Alter_routine_priv='Y','ALTER ROUTINE',NULL), IF(gdb.Create_routine_priv='Y','CREATE ROUTINE',NULL), IF(gdb.Show_view_priv='Y','SHOW VIEW',NULL), IF(gdb.Create_view_priv='Y','CREATE VIEW',NULL),
IF(gdb.Lock_tables_priv='Y','LOCK TABLES',NULL), IF(gdb.Create_tmp_table_priv='Y','CREATE TEMPORARY TABLES',NULL), IF(gdb.References_priv='Y','REFERENCES',NULL), IF(gdb.Host='%','ALL',gdb.Host) AS 'Remote-IP(s) Affected', GROUP BY CONCAT(gcl.Db,gcl.Table_name,gcl.User,gcl.Host)ĬONCAT("`",gtb.Db,"`") AS 'Database(s) Affected',ĬONCAT("`",gtb.Table_name,"`") AS 'Table(s) Affected', IF(gcl.Host='%','ALL',gcl.Host) AS 'Remote-IP(s) Affected',ĬONCAT("GRANT ",UPPER(gcl.Column_priv)," (",GROUP_CONCAT(gcl.Column_name),") ", * Get All Grants/Permissions for MySQL Instance */
#MYSQL LIST ALL USERS UPDATE#
There are a few issues to be handeld, such as user-password-linking, but because we frequently update passwords, that was not in the scope of this project. I designed this query in an attempt to re-build GRANT statements for all existing permissions (for frequent upkeep during database migration). Then feel free to use the following code (below), written in. * Column-Specific Grants */ SELECT * FROM lumns_priv * Table-Specific Grants */ SELECT * FROM mysql.tables_priv * Database-Specific Grants */ SELECT * FROM mysql.db If you can run the following SELECT statements without error: /* User-Specific Grants */ SELECT * FROM er
0 kommentar(er)
