users_permissions []

This is an old revision of the document!

Showing GRANTS for a user

        
              SHOW GRANTS FOR 'user'@'x.x.x.x';

Database manipulation

        
              SELECT........read only
 
INSERT........insert rows/data
 
UPDATE........change inserted rows/data
 
DELETE........delete drop rows of data

Table Manipulation

        
              Table manipulation:
 
CREATE
DROP
ALTER

Granting ALL Privileges on a db

        
              GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'x.x.x.x';

Granting ALL Privileges on ALL dbs

        
              GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';

REMEMBER To Flush Privileges

        
              flush privileges;