Listing Users with Database Access
As a part of my server migration, I’ve begun noting which databases to transfer, which I can trash, and who owns them. This is pretty eye-opening, as it lets me know which users I had forgotten to purge as they left my services. SELECT User FROM mysql.db WHERE Db = ‘databasename’; That will retrieve all [...]