Mysql is loosing privileges
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