error 1045 happened randomly

2003-12-01 Thread Francis Mak
Hi, sorry if this has been answered previously, however I tried to google, I found a few people having this issue, but no solutions provided. I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 all I did is: grant all on

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 11:46, Francis Mak wrote: it works successfully, however, sometimes it just give me Error 1045: Access Denied for user '[EMAIL PROTECTED]' it happens RANDOMLY. Could anybody please let me know how to fix this??? Remove the password from the login and

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: Hi, sorry if this has been answered previously, however I tried to google, I found a few people having this issue, but no solutions provided. I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 all I

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
Duncan, thanks for your tips. I will give it a try. so this is a known bug in mysql? and for sure using blank password is not a long term solutions, what if it is a share hosting env.? any answer from mysql team? many thanks. francis On Monday 01 December 2003 11:46, Francis Mak wrote:

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Duncan Hill wrote: On Monday 01 December 2003 11:46, Francis Mak wrote: it works successfully, however, sometimes it just give me Error 1045: Access Denied for user '[EMAIL PROTECTED]' it happens RANDOMLY. Could anybody please let me know how to fix this??? Remove the

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 12:24, Wouter van Vliet wrote: Duncan Hill wrote: Remove the password from the login and the problem appears to go away. I've hammered my test DBs with thousands of serial logins, and the problem only shows when a login has a password. I'm sory, and I don't

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
PROTECTED] Sent: Monday, December 01, 2003 8:16 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened randomly First of all, there was no reason for the flush privileges; call. This is automatically handled by MySQL when you use the GRANT and REVOKE statements. Doesn't do any harm

RE: error 1045 happened randomly

2003-12-01 Thread Wouter van Vliet
Francis Mak wrote: - I am 100% sure that all scripts are using include (db.php); so all pages are using the same login and password and hostname - since I am using password, so it shows Using Password YES as well. - The error indeed occured on the same page. e.g. when you are viewing

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
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

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 12:51, Wouter van Vliet wrote: 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. And there I was, hoping to take

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 13:08, Francis Mak wrote: 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

Re: error 1045 happened randomly

2003-12-01 Thread Duncan Hill
On Monday 01 December 2003 11:46, Francis Mak wrote: I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and not compiled by myself) + REDHAT 9 Hmm, I just read this part again.. RedHat 9 is the consistent part between your systems and mine. Wonder if glibc or openssl is at

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
am self compiled: openssl-0.9.7c -Original Message- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:02 AM To: [EMAIL PROTECTED] Subject: Re: error 1045 happened randomly On Monday 01 December 2003 11:46, Francis Mak wrote: I am using PHP4.3.4 + MYSQL