mfiume
commented
10 years ago The "" users thing is new. We need to investigate.
On Thu, Nov 21, 2013 at 2:36 PM, jfoong notifications@github.com wrote:
I am able to restrict access with the following commands:
REVOKE ALL PRIVILEGES ON * . * FROM 'user'@'localhost'; REVOKE GRANT OPTION ON * . * FROM 'user'@'localhost'; DELETE FROM db WHERE user = ""; UPDATE mysql.user SET Create_userpriv = 'Y' WHERE user = 'user'; GRANT FILE ON ._ to 'user'@"localhost"; FLUSH PRIVILEGES;
Why do the "" users get added to the mysql.db table?
— Reply to this email directly or view it on GitHubhttps://github.com/compbio-UofT/medsavant/issues/221 .
I am able to restrict access with the following commands:
REVOKE ALL PRIVILEGES ON * . * FROM 'user'@'localhost'; REVOKE GRANT OPTION ON * . * FROM 'user'@'localhost'; DELETE FROM db WHERE user = ""; UPDATE mysql.user SET Create_userpriv = 'Y' WHERE user = 'user'; GRANT FILE ON ._ to 'user'@"localhost"; FLUSH PRIVILEGES;
Why do the "" users get added to the mysql.db table?