ok, I have tried giving a blank password and after 15mins of refreshing(previously it give me error in just around 2-3 mins.) I don't see the Access Denied message anymore.
Duncan, Wouter, thanks!! though "blank password" is not a good solution, but at least it fix the issue. I think I have to go back to previous version, :( and I am looking forward to use 4.1 stable in my next project, since the full unicode support. does mysql team know this issue? I wanna report this to make this product better. did you, Duncan? and Duncan said the problem occur when user hits the DB 100 times. how could you monitor the number of hits?? by using what tools? thank you guys! -----Original Message----- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:52 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened randomly Yes, I replied quick. That's because I'm at work and have nothing better to do :D. When I'm at home it usually takes me a bit longer. Anyways, this error, does it ONLY occur on index.php? Or also on other pages? Now that I have read Duncan's remarks (also quick in his replies), it may be a bug in the alpha version. Though I still don't believe in the random part, since there must be something internal in MySQL that does it with some kind of pattern. Before you 'regrant', I'd advice you to first clear the previous grant. You'd probably do that out of instinct, .. though. If that doesn't solve, you might go with Duncan's thing. The No Password. But be carefull you don't do that on your production server. Or, in my eyes better yet, downgrade to the latest stable verion of MySQL. And compile it yourself, .. always better since it's totally fit for your system then. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]