Eiolon Posted August 18, 2011 Share Posted August 18, 2011 I am logged into the MySQL command line as root. I created a new user: CREATE USER 'programs'@'localhost' IDENTIFIED BY 'mypassword'; Then I try and grant privileges: GRANT SELECT, INSERT, UPDATE, DELETE ON programs.* TO 'programs'@'localhost' I get this as the response: Query OK, 0 rows affected (0.00 sec) When I check the user, it still has N for each of the permissions. I tried flushing privileges. Using MySQL 5.5. Quote Link to comment https://forums.phpfreaks.com/topic/245152-cannot-grant-privileges/ Share on other sites More sharing options...
Muddy_Funster Posted August 19, 2011 Share Posted August 19, 2011 How many tables are in your programs database? Do you get the same result specifying a specific table in the GRANT? Quote Link to comment https://forums.phpfreaks.com/topic/245152-cannot-grant-privileges/#findComment-1259429 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.