On occasion our MySQL 5.6 server loses some user privileges when restarted. The CREATE USER and GRANT commands are run through phpMyAdmin and function for as long as the server is running. After a restart of MySQL, the user record still exists but the privileges are missing. In phpMyAdmin User Accounts, the user appears with global privileges of "Usage". The expected SELECT permission is missing.
Users and privileges are created using:
CREATE USER 'userName'@'hostName' IDENTIFIED BY 'password'; GRANT SELECT ON *.* TO 'userName'@'hostName'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `dbName` . * TO 'userName'@'hostName';
What could be causing the loss of privileges? Is there something else that should be executed in addition to these commands to force MySQL to persist the permissions?