Database permission management and maintenance _ MySQL

Manage and maintain Database permissions

1. delete the Grant select, insert, update, delete, execute on database. * to 'user' @ 'hostname' identifiedby 'password' for normal user queries'

2. developers need permissions for database developers: "create (create), alter (Modify), drop (delete), reference (foreign key ), create temporary tables, index, createview, show view ),"

Revoke 2 revoke permissions

1. Revoke all on database. * from 'user' @ 'hostname'

Optional 3 blocks option files to prevent other users from reading

1. the inventory option file is the my. ini file in the database.

2. use resource manager for Windows implementation

3. Linux uses statements such as % chmod 600. my. cnf.