Mysql permission management: a non-db administrator creates mysql

Mysql permission management: a non-db administrator creates mysql and installs mysql. When a database is created, several accounts are required for permission management. The following is a summary of the four accounts. Www.2cto.com 1. root Account, which is set when the database is installed. Assume that the account password is as follows: root passwd has the highest permissions to manage the database. You can create users, create databases, modify tables, and other permissions. 2. the second account is www.2cto.com create passwd. This account has all permissions to operate on a specific database. grant all on db_name to create @ '%' identified by 'passwd '; '%' indicates that the creat account can connect to the database from any host. the third account db_write passwd grants select, update, delete, insert on db_name to db_write @ '% 'identified by 'passwd'; 4. the fourth account, db_read passwd, grants the read permission account for a specific database select on db_name to db_read @ '%' identified by 'passwd ';