Does anyone think I would have better luck installing MySQL with something other than an RPM??
-----Original Message----- From: James M Kupernik [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:59 AM To: 'mos' Cc: [EMAIL PROTECTED] Subject: RE: random access denied Thank you, I have checked all of the above. I have set the max connections to 200, but that didn't help any. The connection per hour is not a factor because it doesn't lock out the user, it just fails to authenticate, but as soon as you refresh the page or try to connect via the command line to goes through. Jamie -----Original Message----- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:37 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: random access denied At 11:17 AM 9/18/2003, you wrote: >It's not a continued access denied, because it can accept connections >all day long, but randomly it will just deny one, but the accept it on >the next try. > >I've googled this problem to death, I don't know what else I can do James, Are you sure it's not something simple like exceeding the Max_Connections? (Default is 100) I'm sure you've checked this but there's no harm in asking. For something a little more esoteric, check out the user's Grant properties. It is possible to define Max_Connections_Per_Hour, Max_Updates_Per_Hour or Max_Queries_Per_Hour for the user. So he could be prohibited one hour, but next hour he regains access. Mike >-----Original Message----- >From: mos [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 17, 2003 5:20 PM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: RE: random access denied > > >At 03:09 PM 9/17/2003, you wrote: > >Anything that anyone can suggest that might point me in some > >direction would be very helpful. I'm just at a complete lose right > >now ... > >James, > >See the Google Group search: >http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&q=m >ysql+ >%22Access+denied+for+user%22&btnG=Google+Search > >There are quite a few suggestions listed there. > >Mike > > > >-----Original Message----- > >From: James M Kupernik [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, September 16, 2003 3:58 PM > >To: [EMAIL PROTECTED] > >Subject: random access denied > > > > > >Hello, > > > >I am having a frustrating problem with MySQL. I don't consider myself > >a newbie, nor am I a master, but either way I can't figure out this > >problem and I'm hoping someone here has an idea of what is going > >wrong. > > > >Every so often MySQL decides it doesn't want to authenticate a user, >doesn't > >matter on the user/db, etc;. The error message is: 030916 16:10:50 39 > >Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > >I have a whole log full of these messages. Now and soon as the page > >is refreshed or you try logging in again (from the command line) it > >goes through. It's only a temp error. > > > >If anyone has any suggestion I'm more than willing to try them. This > >server was supposed to be in production about a week ago and I can't > >let it go like this. > > > > > >Thanks very much!! > > > >Jamie > > > > > >-- > >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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
