During the last week I have asked couple of questions regarding setting up
MySQL & have gotten good answers. Since my knowledge of MySQL is in the
beginer level, and I am very close to finishing up working with MySQL, I
have several questions still un answered. I will try asking one question at
a time so I do not confuse anything.
My setup:
T1 to Internet Backbone
|
---------------------------
| |
12.21.237.10 12.21.237.11
-------------- --------------
| Firewall | | Firewall |
| DNS (NS1) | | DNS (NS2) |
-------------- --------------
192.168.21.10 192.168.21.10
| |
---------------------------
DMZ |Hub| DMZ
---------------------------------------------
| | |
192.168.5.15 192.168.5.16 192.168.5.17
rdx mail mails
------------ ------------ ------------ ------------
| 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 mailsl datal
| | | |
-------------------|Hub|---------------------
The four servers sit behind a firewall & communicate with each other on
private 192.168.6.XX network. Data Server (datal) is a MySQL Master Server
RH9,DUAL CPU, 1.5GB Mem & RAID1) & it is accessable only by servers in the
DMZ over 192.168.5.XX network. I have file "/etc/my.cnf" in the "data1",
which I copied from "my-large.cnf" and have made no changed to it.
/etc/hosts table in each server resolves all other servers in the DMZ & I
can PING any one of them from any one of them.
RADIUS Server (rdxl) is a client MySQL Server and reads authentication data
from DATA Server (datal). My INTENT is to setup Client MySQL Server (rdxl)
so
that(if possible)it is permanently connected to the MySQL Master Server
(datal)!
---------
I use the following command in Client MySQL Server (rdxl) to connect to the
Master MySQL Server:
shell> mysql -h datal -u root password=mysqlpw
Where "root" password (mysqlpw) is setup using "mysqladmin" command.
Question:
(1) What is the norm UID when connecting from a Client MySQL Server?
I am using "root" as UID, should I use "mysql" as UID & why? If UID
"mysql" is used then how do I setup PW for it? Is it by "mysqladmin"
command or by changing the PW is the User Manager?
(2) I am told not to expose the password. In this situation, where
RADIUS server will be connecting to the Master MySQL server every
few seconds, how would I setup the connection to the "datal" server?
(2) In Clinet/Master MySQL setup, do I also need to create a "/etc/my.cnf"
file on the Client MySQL Server?
(3) What changes do I need in "/etc/my.cnf" file?
---------
Thanks.
Kirti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
