![]() Step 6 – Revoke Privileges from a MySQL User Account | GRANT SELECT, INSERT, DELETE ON `testdb1`.* TO | | GRANT ALL PRIVILEGES ON `testdb`.* TO | | GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO | Run the following command to display all granted privileges to testuser: SHOW GRANTS FOR should get the following output: +-a+ You can use the SHOW GRANTS command to display the privileges that you have granted to MySQL users. To grant all the privileges to testuser on testdb database, run the following command: GRANT ALL PRIVILEGES ON testdb.* TO grant all the privileges to testuser on all databases, run the following command: GRANT ALL PRIVILEGES ON *.* TO grant only SELECT, INSERT and DELETE privileges to testuser on testdb1 database, run the following command: GRANT SELECT, INSERT, DELETE ON testdb1.* TO 'localhost' Step 5 – Show Granted Privileges
0 Comments
Leave a Reply. |