Jump to content

Cannot grant privileges


Eiolon

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.