Doing some work with MySQL security, I’ve noticed a few inconsistencies. They’re mostly not-too-terrible for daily work, except they get in my way right now.
The ALL PRIVILEGES inconsistency
The preferred way of assigning account privileges in MySQL is by way of using GRANT.
With GRANT, one assigns one or more privileges to an account, such as SELECT, UPDATE, ALTER, SUPER ,etc. Sometimes it makes sense for an account to have complete control over a domain. For …[Read more...]