> AND table_name IN ('user','db','tables_priv') Here are privs for MySQL 5.5 mysql> SELECT table_name,column_name If you want to see what privileges exist at the three levels run the the following queries SELECT table_name,column_nameĪND table_name IN ('user','db','tables_priv') If you do you accidently slip username privileges that username should not have. Username will have table privileges on the mydb.mytable only. If you run GRANT ALL PRIVILEGES ON mydb.mytable TO username Username will have database-wide privileges on the mydb database only. If you run GRANT ALL PRIVILEGES ON mydb.* TO username ALL PRIVILEGES stands for all privileges available for the level at which privileges are to be granted except for the GRANT OPTION and PROXY privileges. Username will have global database privileges (all databases) If you run GRANT ALL PRIVILEGES ON *.* TO username TO montylocalhost IDENTIFIED BY something. It should say something like GRANT USAGE ON *.* TO username. You can add new users by issuing GRANT statements: shell> mysql -userroot mysql mysql> GRANT ALL PRIVILEGES ON. Why drop the user first? When you first create a user called username and login, username has no privs. Esta parte está mal descrita: ALL PRIVILEGES: como mencionamos previamente esto permite a un usuario de MySQL acceder a todas las bases de datos asignadas en el sistema.

GRANT ALL PRIVILEGES ON mydb.* TO username Specifically, for users who have privileges at the global level, partialrevokes enables privileges for specific schemas to be revoked while leaving the privileges in place for other schemas. I suggest you drop the user first to clear up any server-wide privileges. It is possible to grant privileges that apply globally if the partialrevokes system variable is enabled. many of the grants you have in your answer do not exist in the mysql grant tables, 3) there are no types in MySQL, 4) no sequences in MySQL, 5) no database links, 6) no operators, 7) no clusters, 8) no synonyms, 9) no. To grant privs on a table mydb.mytable to username GRANT ALL PRIVILEGES ON mydb.mytable TO username GRANT ALL PRIVILEGES ON mydb.mytable TO username I suggest you drop the user first to clear up any server-wide privileges. Other privileges might be available to the account. To grant all privs on database mydb to username GRANT ALL PRIVILEGES ON mydb.* TO username In Oracle MySQL SHOW GRANTS displays only the privileges granted explicitly to the named account.

Mysql grant all privileges