MySQL Users

• This is better known as privileges

SHOW GRANTS [FOR user];
 
SHOW GRANTS;
SHOW GRANTS FOR 'root'@'localhost';
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();

• http://dev.mysql.com/doc/refman/4.1/en/show-grants.html

• http://dev.mysql.com/doc/refman/4.1/en/grant.html

• Global Privileges (all databases and tables):

  GRANT ALL PRIVILEGES ON *.* TO username@localhost
  IDENTIFIED BY 'password';

• Global Privileges for “acme” database (and all acme tables):

  GRANT ALL PRIVILEGES ON acme.* TO username@localhost
  IDENTIFIED BY 'password';

• http://dev.mysql.com/doc/refman/4.1/en/revoke.html
• remove a user from all global, database, table, and column privileges

  REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...

• revoke removes a user from all privilege tables, but not the user table; you must use one of the following:
  • DROP USER

    DROP USER user [, user] ...

  • DELETE

    DELETE FROM mysql.user WHERE User='user_name' and Host='host_name';
    FLUSH PRIVILEGES;

You need to flush privileges after manually making changes to user tables.

FLUSH PRIVILEGES;