Can you show us the code that checks the username and password to see if
they're correct?
Is this a custom admin page that you created?
If your page is authenticating against the "mysql" database, then you should
know that MySQL encrypts the password and stores the encrypted password.
So if you use the GRANT statement to create a new user that looks like:
User: admin
Pass: Secrets
...MySQL will store this as:
User: admin
Pass: Ata91230t!44
So if you try to login and your login code looks like:
if($PasswordEntered == $DatabasePassword)
{
...
}
So even if $PasswordEntered equals "Secrets", it won't be the same, because
it won't match the encrypted password.
- Jonathan
-----Original Message-----
From: Michael Elliott [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 5:54 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Connecting to MySQL Database
I am trying to create an admin page to administer my database. I used a
file .sql to create my database. In the file, I included:
grant select, insert, update, delete
on database.*
to admin@localhost identified by 'password';
Why can I not log in successfully using admin and password?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
