To delete a MySQL user account, use the following command: DROP USER Conclusion To delete a MySQL database, use the following command: DROP DATABSE testdb If you want to revoke or restore all privileges from a MySQL user over a database, use the revoke command as shown below: REVOKE ALL PRIVILEGES ON testdb.* FROM Step 7 – Delete MySQL Database and User Account 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 Step 5 – Show Granted Privileges
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |