I using php5, IIS 5.1 and mySQL 5 in developing a web application. There is password for mySQL. I also using phpMyAdmin to manage mySQL5. PhpMyAdmin running fine using IIS but my web application running weird. My web application use to hav a login authentication before can be access and use by user. When I try to login the web application, the web application didn't accept the username and password,even the username and password are right.
think that there are other places on this board where you will have more luck getting help.
Here's the lounge, we drink coffee and TALK about our work but we don't work at all
lilyminako wrote:When I try to login the web application, the web application didn't accept the username and password,even the username and password are right.
What does the application test to decide wether it's a valid login or not (please relevant code if possible).
lilyminako wrote:I using php5, IIS 5.1 and mySQL 5 in developing a web application. There is password for mySQL. I also using phpMyAdmin to manage mySQL5. PhpMyAdmin running fine using IIS but my web application running weird. My web application use to hav a login authentication before can be access and use by user. When I try to login the web application, the web application didn't accept the username and password,even the username and password are right.
Can some one help me?
thank alot
Posting the error message would be helpful to us, but it sounds like your MySQL Client API version might be outdated and that your MySQL server is using the new 46 bit hash of the password instead of the 16 bit hash.
Easy thing to do is run a phpinfo() page and see what the MySQL client API version is. If it is anything 3.XX you are hosed unless you modify your my.conf to use old-passwords in the [mysqld] section.
Until I see the error message, though, this is just a guess.