Grant Access

Show Existing Grant Permission

Show the SQL statements used to create the current grants on the database.

SHOW GRANTS;

GRANT ALL PERMISSIONS TO A DATABASE

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

GRANT PERMISSIONS ON DATABASE TABLE

GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';

GRANT DATABASE USAGE PERMISSIONS

GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;


Mysql Manual

Flush Privileges

flush privileges
Cookbook Category: 

Add new comment