localhost is 127.0.0.1 in most systems unless you modify your hosts file, since 172.16.3.106 is not localhost, connecting thru that localhost will definitely not work for it's not localhost =)
it's not a bug i believe. another thing, if you grant a user with a host localhost, and you place a mysql -ublah -p -h172.16.3.106 it wouldn't also work, you need to add a user with that @172.16.3.106 address for it to be allowed to access mysql, well that's with grants and a fairly different story. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] sql, query ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 27, 2003 1:48 PM Subject: MySQL connection problem > Hi, > I really don't know whether it is a bug in mysql 4.0.12. > I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with > SPack2). I've changed the bind-address to "localhost" in my.ini and > re-started mysql. > > mysql -h localhost is working fine. > > mysql -h (ip of my machine) or mysql -h (hostname) ends with the following > error: > > ERROR 2003: Can't connect to MySQL server on '172.16.3.106' (10061) > > Earlier I had mysql 3.23.48 on the same machine. It used to work fine for > all the above three commands. > > Could you please help me out??? > > Thanx in adv, > RK > * * * The information contained in this message is legally privileged and > confidential information intended only for the use of the addressed > individual or entity indicated in this message (or responsible for > delivery of the message to such person). It must not be read, copied, > disclosed, distributed or used by any person other than the addressee. > Unauthorised use, disclosure or copying is strictly prohibited and may be > unlawful. Opinions, conclusions and other information on this message that > do not relate to the official business of any of the constituent companies > of the TATA CONSULTANCY SERVICES shall be understood as neither given nor > endorsed by the Group. If you have received this message in error, you > should destroy this message and kindly notify the sender by e-mail. Thank > you. * * * > > > -- > 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]
