This is driving my nuts. How do I grant full access on a particular database (all tables) to a particular user. I issued the following command but when I log in as the user and do I "show database" I don't see the database:
grant all on mynewdb.* to 'gregh'@'%';
This way anyplace the user gregh logs in from, the user would have access to mynewdb. However, when gregh logs in from localhost, and does a "show databases", only the "test" database shows up. Am I doing something wrong?
grant all on mynewdb.* to 'gregh'@'%';
This way anyplace the user gregh logs in from, the user would have access to mynewdb. However, when gregh logs in from localhost, and does a "show databases", only the "test" database shows up. Am I doing something wrong?