Ritter: What is the effect of enter the following in /etc/my.cnf":
[client] password = mysql123 Kirt -----Original Message----- From: Jason K Larson [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 2:48 PM To: Kirti S. Bajwa Cc: [EMAIL PROTECTED] Subject: Re: Restrict connection to MySQL Server http://dev.mysql.com/doc/mysql/en/Adding_users.html mysql> GRANT ALL PRIVILEGES ON db.* -> TO mysql@'192.168.10.0/255.255.255.0' -> IDENTIFIED BY 'mysql123'; -- Ritter Kirti S. Bajwa wrote: > Hello: > > I am trying to setup a client mysql server to connect to a Master MySQL > server by MUST using a PASSWORD!! > > CURRENT SYSTEM: > ================ > Master MySQL Server: > ------------- > Name: datam > IP: 192.168.10.21 > O/S: RH9 > MySQL:4.0.18 (Source) > > Client MySQL Server: > ------------- > Name: datac > IP: 192.168.10.22 > O/S: RH9 > MySQL:4.0.18 (Source/Client installation) > > WHAT ELSE I HAVE DONE: > ====================== > All installation was done using official MySQL documentation & by consulting > MySQL by DuBois book. > > On Master MySQL server, I setup a user account "mysql". I also setup PW for > "root" and "mysql" (PW is "mysql123"). Both "root" & "mysql" can connect to > Master MySQL server "datam" locally & are forced to use PW. I also setup > "/etc/my.cnf". Then I granted privileges to all Client MySQL machine to > connect to Master MySQL server as follows: > > mysql> GRANT ALL PRIVILEGES ON db.* > -> TO mysql@'192.168.10.0/255.255.255.0'; > > So far so good. I connected from Client MySQL server: > %mysql -u mysql -h datam > > No problem. Client MySQL connects fine. > > QUESTION/SUGGESTION/PROBLEM: > ============================= > I want to force Client MySQL servers to use a PASSWORD to connect to the > Master MySQL Server "datam". Right now any Client on 192.168.10.X can > connect without using password. > > To further investigate, I changed the "/etc/my.cnf" file as follows: > > [client] > password = mysql123 > > Well, it did not make any difference. > > So, please let me know what am I doing wrong? What changes should I make so > the client machines must use a PW to connect to the Master server? > > Thanks. > > Kirt > > > -- 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]
