users_permissions
This is an old revision of the document!
Showing GRANTS for a user
SHOW GRANTS FOR 'user'@'x.x.x.x';
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
<sxh bash> flush privileges; <sxh>
users_permissions.1428011868.txt.gz · Last modified: 2024/05/23 07:26 (external edit)