Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
====================================================================
#/> 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 ([EMAIL PROTECTED])
Changes by Steve Harvey ([EMAIL PROTECTED])
This software comes with ABSOLUTELY NO WARRANTY.
Access-rights
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.'
user :
'192.168.0.%','myuser','xxxxxxxxxxxxxxxx','N','N','N','N','N','N','N','N','N','N','N','N','N','N'
====================================================================
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: '[EMAIL PROTECTED]' 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
rights.
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 ?
Regards,
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
