Re: MySQL User and DB Tables
Posted by: Rick James
Date: October 22, 2013 08:24PM

GRANT USAGE ON *.* TO ... -- row only in `user`, but no permissions.
GRANT ... ON *.* TO ... -- row only in `user`, with selected permissions.
GRANT ... ON dbname.* TO ... -- row in both `user` and `db`, permissions only for `dbname`.
GRANT ... ON dbname.tblname TO ... -- also a row in tables_priv.

If you can get in as root, do
SHOW GRANTS FOR ...@...
for that particular user and where he is coming from (probably 'localhost').

Options: ReplyQuote


Subject
Written By
Posted
October 21, 2013 03:40PM
Re: MySQL User and DB Tables
October 22, 2013 08:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.