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]