SHOW PRIVILEGES lists the privileges supported by the server. It does not
tell you anything about which privileges a user has. This is documented in
the manual http://dev.mysql.com/doc/mysql/en/SHOW_PRIVILEGES.html.
To see the privileges for [EMAIL PROTECTED], you want
SHOW GRANTS FOR
Hi,
I need some help with privileges issues.
I want to create a user, bkup_user, with only Select, Reload, Lock Table
privileges.
I created the bkup_user with all privileges, and revoked all but select
reload and grant (could not find lock table). Command succeeded and I
flushed privileges.