User Tools

Site Tools


users_permissions

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;


users_permissions.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki