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 + MY

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 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

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 ta

RE: error 1045 happened randomly

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

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

RE: error 1045 happened randomly

2003-12-01 Thread Francis Mak
-TW&lr=&ie=UTF-8&oe=UTF-8&threadm=bkeab v%241bq6%241%40FreeBSD.csie.NCTU.edu.tw -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:16 PM To: 'Francis Mak'; [EMAIL PROTECTED] Subject: RE: error 1045 happened

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

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??? > > R

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
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 > >

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

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 privil