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. 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? Link to comment https://forums.phpfreaks.com/topic/245152-cannot-grant-privileges/#findComment-1259429 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.