Hi
Well if you are using PHP, what we do is have one user e.g. 'PHPLOGON' that
conects to the DB.
Then when the user logis on thay enter a user name and password, php looks
this up in a table on MySQL (useing user PHPLOGON) and looks in table
faculty (username,password).....
This way users do not have direct acsess to the DB!
Simon
-----Original Message-----
From: Channon Quillen [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2001 13:37
To: mysql
Subject: MySql and PHP
Is it better to let mysql handle logins or to create a table with this
info?
I'm setting up a db that has faculty and students. Currently, all access
to the db is through user root. I read the General Security issues and
this seems to be a problem.
The db will be accessable on the web, but I only want users in a certain
IP address to be able to get it.
Is there a way to relate the user table built-in to MySql with a created
table? eg. faculty
-Channon
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php