The "%" in the first command to User table spoils it all. It means logging from ffrom
any host is valid .
Remove that command. It'll work
Cheers
Donald
----- Original Message -----
From: David Hulka
To: [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 1:28 AM
Subject: Setting access rights
Hi everyone,
I have problem with Database inteded for setting access rights.
The problem is that IP addresses set in table 'db' dont affect access rights.
With no problem I accessed database from IP 147.229.177.57.
Dumping data for this database are as follows:
# DATABASE mysql
#
# Dumping data for table 'user'
#
INSERT INTO user VALUES
('%','YYY','passwd','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES
('localhost','root','passwd','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'
,'Y');
#
# Dumping data for table 'db'
#
INSERT INTO db VALUES
('localhost','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.193','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.194','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.195','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.196','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.197','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
INSERT INTO db VALUES
('193.179.240.198','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N');
Server Configuration is:
RedHat v7.0 + Apache 1.3.14 + PHP 4.0.4pl1(patched zend_list.c) + MySQL v
3.23.33.
Can somebody help me? What is wrong?
Best regards
Dave.
---------------------------------------------------------------------
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