Keith,
Thanks for answering me.
Yes I did. Nothing in the MySQL log either. Keep in mind that these
errors only sometimes show up and usually in the middle of a few queries
in a row (while permissions are set for the whole table). Because the
script runs fine most of the time, I don't think privilege settings are
the key here.
Could this message appear when, for instance, a maximum amount of
threads has been spawned or MySQL has reached its connection limit?
Jorrit
Keith Roberts wrote:
Check your mysql log and see if it says anything about not
being able to use the new password format.
Did run mysql_fix_privilege_tables to update your
mysql passwords in the mysql privileges database?
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee <[EMAIL PROTECTED]>
Subject: Random 'select permission denied' since upgrade to 5.0.18
Hello list,
Recently we upgraded from 3.23.3 to 5.0.18 and started noticing some
weird behaviour. We have update scripts running on a regular interval
and some of these scripts randomily exited with MySQL error:
SELECT command denied to user 'user'@'host' for table 'example'
However, this error message only appears sporadically. Usually these
scripts run without any problems.
tcpdump shows nothing more than we already know. I see the error message
appear on different queries.
We have the server running on Gentoo Linux (mysql-5.0.18-r30) as a
master (with one slave on another Gentoo machine).
Any ideas to debug this problem any further?
Thanks in advance,
Jorrit
By the way, there's been a previous posting to this list describing
similar problems (no solution though):
http://marc.theaimsgroup.com/?l=mysql&m=113050497323853&w=2
--
System Developer
Infopact Network Solutions
Hoogvlietsekerkweg 170
3194 AM Rotterdam Hoogvliet
tel. +31 (0)88 - 4636700
fax. +31 (0)88 - 4636799
mob. +31 (0)6 - 14105968
[EMAIL PROTECTED]
http://www.infopact.nl/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]