Keep in mind you need 2 things to happen: A) the mysql server has to be bound/listening on the ip/interface you need it to be. This is typically configured in my.cnf configuration file.
B) you need to ensure the mysql privlidges will allow access from other hostnames/ip addresses. If mysql isn't listening on the required interface there is no a way tcp/ip connection can be established... It is very possible that the application running on the same server is using mysql sockets to connect to the sql server instead of using tcp/ip... Start with ensuring the server is listing tcp/ip on the correct interface.. If you can send us your my.cnf,it would help.. Unless mysql was perhaps configured without networking (I think that is a valid configure option if I'm not mistaken) On Thu, 17 Jul 2003, zafar rizvi wrote: > hi > No its not listening and giving same error > > ERROR 2013: Lost connection to MySQL server during query > > how can i allow a ip to connect mysql database from other system. > plz explain me little (i have not yet idea to use mysql fully) > > Thanks > ZafAr > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "zafar rizvi" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 10:11 AM > Subject: Re: mysql connection error > > > > > > It says lost error during query.. but I'd be suspect if it even > > succesfully connected/authenticated.. > > > > I'd do a quick check first to ensure your mysql server is listening on the > > 192.xxx interface.. if it's unix, netstat -atn > > > > > > > > > > On Thu, 17 Jul 2003, zafar rizvi wrote: > > > > > hi > > > I am running one centralized mysql server, its runnig fine and conneded > with > > > localhost and his own ip very fine. > > > But when i want to connect him from remote system or other lan system > > > it give me errror like that. > > > > > > [EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql > > > ERROR 2013: Lost connection to MySQL server during query > > > > > > Anybody has idea what's wrong and where is ? > > > I get no answer from searching on google with that error. > > > > > > Waiting for reply > > > ThAnks > > > > > > ZaFAr > > > > > > > > > -- > > > 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] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
