Re: mysql connection error
On Thursday 17 July 2003 12:59, zafar rizvi wrote: > hi > i have running MySQL version 3.23.52. > and using Linux 8.0 Does your MySQL server crash when you try to connect remotely? Linux 8.0 - SuSe? Red Hat? > > Tx > ZafAr > - Original Message - > From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 2:36 PM > Subject: Re: mysql connection error > > > "zafar rizvi" <[EMAIL PROTECTED]> 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. > > > > What is the version of MySQL server? What OS do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql connection error
"zafar rizvi" <[EMAIL PROTECTED]> 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. What is the version of MySQL server? What OS do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql connection error
Also make sure that the port is not firewalled. Cheers /rudy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 9:56 To: zafar rizvi Cc: [EMAIL PROTECTED] Subject: Re: mysql connection error 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql connection error
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]
Re: mysql connection error
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]
mysql connection error
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]
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]
Re: MySQL Connection error
You might want to look in the crontab to see if rotatelogs is rotating the logs for mysql. If it is, the mysql database is bounced. The easy thing to do is just to check the connection and make sure it is open before using it. i.e. if (conn.isClosed()) { conn=db.getConnection() } On Wed, 2002-03-27 at 00:58, Foo Yong Choon wrote: > But my program works fine and all those java code i > used to connect to mysql is what i have been taught by > my lecturer it works fine..only things is that i never > leave my application up for more than a day and that > when i discover this problem. > Usually i restart tomcat and it works again but the > problem resurface the next day. > > > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Connection error
But my program works fine and all those java code i used to connect to mysql is what i have been taught by my lecturer it works fine..only things is that i never leave my application up for more than a day and that when i discover this problem. Usually i restart tomcat and it works again but the problem resurface the next day. __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php