user authentication
| From: | Alain Roger | Date: | Tue, 11 Apr 2006 15:31:25 +0000 |
| Subject: | user authentication | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-233765@lists.php.net to get a copy of this message | ||
Hi,
i'm sure that it's a stupid question but i would like to have your feedback
on it.
i have MySQL with 2 users in the "mysql" database which are root and
uimmense.
i suppose that what i see in the password field is the sha1 crypted
password.
is it correct or not ?
but lets continue...
in fact, my web application should use a database named "immense".
in this database, there is a table named "profiles".
in this table, the login "uimmense" and its MD5 password are stored.
the problem is :
when i use mysql_connect('localhost','uimmense',myMD5password); to connect
to MySQL database system, the connection is refused because the MD5 password
does not correspond to what is saved into users table within mysql
database... :-(
here is my question :
all my users registered into my "immense" database, should be also
registered as users of MySQL database system ? (which is stored into "users"
table, into "mysql" database) ?
is it clear ?
i do not see really realistic if everytime that a new user is registered to
my application, i have to create him a profile for MySQL database.
thanks a lot,
Alain