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').
Subject
Written By
Posted
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.