I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
#/> mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier@stripped)
Changes by Steve Harvey (sgh@stripped)
This software comes with ABSOLUTELY NO WARRANTY.
for USER 'myuser', from HOST '192.168.0.1', to DB 'membres'
| Select_priv | Y | | Shutdown_priv | N |
| Insert_priv | Y | | Process_priv | N |
| Update_priv | Y | | File_priv | N |
| Delete_priv | Y | | Grant_priv | N |
| Create_priv | Y | | References_priv | Y |
| Drop_priv | Y | | Index_priv | Y |
| Reload_priv | N | | Alter_priv | Y |
NOTE: A password is required for user `myuser' :-(
The following rules are used:
db : '192.168.0.%','membres','myuser','Y','Y','Y','Y','Y','Y','N','Y','Y','Y'
host : 'Not processed: host-field is not empty in db-table.'
This works fine all day long, but each morning when I come back to
work, my web site is no more working and the reason is :
ERROR 1044: Access denied for user: 'myuser@stripped' to database 'membres'
If I test 'mysqlaccess 192.168.0.1 myuser membres' I have the same
thing as above.
And as soon as I run 'mysqladmin reload' , it corrects the problem
and my web site is back.
It's 3 days I have this problem.
Maybe a program of mine is doing something that Mysql doesn't like
each nights, but for me, this shouldn't impact Mysql's access
And I don't understand why 'mysqlaccess' is returning the good
result but Mysql isn't granting access before I ask to reload
access rights ...
I had this problem with Mysql-3.23.47, I upgraded to 3.23.49 but I
still have the same problem.
Any idea ?