Jeremy: Yes I tried the "GRANT ... " and few others. Finally it HIT me (after two weeks). I installed the MySQL master server on "data" server, which can't be accessed from the Class C IP addresses (see my setup below). I used "mysqlcc" GUI display and changed the server to "datal" and I started accesses it from all servers on 192.168.6.%! What a trip.
Thank you for your response. You are always very helpful. Kirti -----Original Message----- From: Jeremy March [mailto:[EMAIL PROTECTED] Sent: Sunday, March 14, 2004 6:23 PM To: [EMAIL PROTECTED] Subject: re: Basic Setup Questions!!!! Have you tried: GRANT privileges ON database.* TO 'jupiter'@'192.168.6.%' IDENTIFIED BY 'sunrise'; See: http://www.mysql.com/doc/en/GRANT.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -----Original Message----- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Sunday, March 14, 2004 4:37 PM To: [EMAIL PROTECTED] Subject: Basic Setup Questions!!!! Hello List: After two weeks of struggling, I need help!! My setup: T1 to Internet Backbone | Cisco 26XX 12.21.237.1 | --------------------------- | | 12.21.237.10 12.21.237.11 -------------- -------------- | Firewall | | Firewall | | DNS1(NS1) | | DNS2(NS2) | -------------- -------------- 192.168.21.10 192.168.21.11 | | --------------------------- DMZ |Hub| DMZ --------------------------------------------- | | | | 12.21.237.15 12.21.237.16 12.21.237.17 12.21.237.17 rdx mail Web data ------------ ------------ ------------ ------------ | RADIUS | | Mail | | Web/HTTP | | DATA | | Server | | Server | | Hosting | | MySQL | ------------ ------------ ------------ ------------ 192.168.6.15 192.168.6.16 192.168.6.17 192.168.6.18 rdxl maill webl datal | | | | -------------------|Hub|--------------------- In the above setup, I have setup a MySQL master server called "data". This master server (my plan) can only be accessed from MySQL client servers rdxl, maill, webl & datal (IP's 192.168.6.%). I have read MySQL documentation & MySQL by Paul DuBois (several times). I can test and access "data" server as explained in the documentation DuBois book. My Problem: ----------- (1) How do I setup so that servers on 192.168.6.? can (are allowed) access the master MySQL server? (2) I want to create an account "jupiter" password "sunrise" which can access data "custdata" on master MySQL server? Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
