MySQL Forums
Forum List  »  General

Mysql is loosing privileges
Posted by: Pavel Ondrej
Date: May 02, 2013 09:22AM

Hi,
I have problem on some Centos OS 6 with Mysql.

On some servers, randomly, some random users lose their privileges. Show grants is ok, but when user call "use db", so mysql return perm. problems. After flush privileges is all ok.
Can you help me? Thanks.

Pavel

--------------

mysql> show grants for 3067_jevicky@
-> ;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for 3067_jevicky@ |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO '3067_jevicky'@'' IDENTIFIED BY PASSWORD 'XXX' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, TRIGGER ON `XXX\_cz\_1`.* TO '3067_jevicky'@'' |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

mysql> use thaimay_cz_1
ERROR 1044 (42000): Access denied for user '3067_jevicky'@'' to database 'XXX_cz_1'

T

Options: ReplyQuote


Subject
Written By
Posted
Mysql is loosing privileges
May 02, 2013 09:22AM


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.