Same database, and same user. Nope, it's a fairly low traffic application (a helpdesk) and there's no large importing done. When it happens again I will print out some SQL results. Anything I can look out for or provide the next time it happens?
Thanks ----- Original Message ----- From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Terence '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 11, 2004 10:41 PM Subject: RE: Privilege to single database being revoked occasionally Is it the same database, same user? Does it follow any maintenance or large import? -----Original Message----- From: Terence To: [EMAIL PROTECTED] Sent: 3/11/04 12:25 AM Subject: Privilege to single database being revoked occasionally Dear Lists, We moved to 4.1.0 when it was first launched, and twice a month or so, we get access denied commands to one particular database for one particular user. The privileges are correctly set, and the only way to restore access for the user, is to revoke and re-apply the privileges and all works fine again. I am the only user with permission to change privileges. I am just wondering if anyone else has stumbled across this problem in 4.1.0? It doesnt seem to have been fixed in version 4.1.1 according to: http://www.mysql.com/doc/en/News-4.1.1.html If there's any data I can provide for debugging purposes, please let me know. Thanks Terence -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]