h1Go Away!/h1;
echo You are not authorized to view this resource.;
die();
}
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Norman Zhang' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 11:29 AM
Subject: RE: database setup
First, I assume
Hi,
I am setting up a mysql database, with two tables. One keeps the user
authentication info such as user name, password and user level. The other
table with contains files for upload and download. Is there a good way to
setup the user authentication table so it can check appropriate user
Hi,
I have setup a table with user login name and password. The password is
encrypted with the MySQL's password(). How do I compare these info with the
user's input.
I had
$query = select * from auth where
usrname='$logname' and usrpass=password('$logpass');
mysql_query($query);
But I can't
Hi,
I have a table with username and password. The password is encrypted using
mySQL's password function. But when I try to perform a match using PHP,
e.g.,
$query = select count(*) from auth
where usrname='$logname' and usrpass=password('$logpass');
$result = mysql_query($query) or exit
Hi,
I assigned rights to a user in mysql,
mysql grant all on books.* to bookorama@localhost identified by
'bookorama123';
Then I tried to access mysql in as a regular user,
[bookorama@a177 bookorama]$ mysql -u bookorama books -p;
Enter password: bookorama123
And I get the following error