Re: Restrict connection to MySQL Server
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 24 May 2004 02:01 pm, Kirti S. Bajwa wrote: > [client] > password Is there some reason you cant look in the manual for this? http://teaching.cs.uml.edu/MySQLdocs/MySQL_Manual/Connecting.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAskbrld4MRA3gEwYRAhesAJwIX61EU5NWUtvOMIy9QsNx+mEJTwCfYdsH /4utbqqVT1TjZaP29mDzjns= =3KOy -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restrict connection to MySQL Server
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]
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]