I am looking to duplicate the MS SQL setup where I can grant someone permissions to setup databases where they then become the owner and can configure all necessary permissions within the databases ...

One of the tasks nearly any sysadmin frequently encounters is the care and feeding of the MySQL database server. You can build an entire career around nothing but this topic—making you a DB admin, not ...