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

Reply via email to