List:General Discussion« Previous MessageNext Message »
From:James M Kupernik Date:September 19 2003 6:59am
Subject:RE: random access denied
View as plain text  
Does anyone think I would have better luck installing MySQL with something
other than an RPM??



-----Original Message-----
From: James M Kupernik [mailto:james.kupernik@stripped] 
Sent: Thursday, September 18, 2003 11:59 AM
To: 'mos'
Cc: mysql@stripped
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:mos99@stripped] 
Sent: Thursday, September 18, 2003 11:37 AM
To: james.kupernik@stripped
Cc: mysql@stripped
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:mos99@stripped]
>Sent: Wednesday, September 17, 2003 5:20 PM
>To: james.kupernik@stripped
>Cc: mysql@stripped
>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:james.kupernik@stripped]
> >Sent: Tuesday, September 16, 2003 3:58 PM
> >To: mysql@stripped
> >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: 'phpBB@localhost' (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/mysql?unsub=1
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

Thread
random access deniedJames M Kupernik16 Sep
  • RE: random access deniedJames M Kupernik17 Sep
    • RE: random access deniedmos18 Sep
      • RE: random access deniedJames M Kupernik18 Sep
        • RE: random access deniedmos18 Sep
          • RE: random access deniedJames M Kupernik18 Sep
            • RE: random access deniedJames M Kupernik19 Sep