Navicat Error 2013
Contents |
No announcement yet. Lost connection to MySQL server during query Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All lost connection to mysql server at 'reading initial communication packet', system error: 0 Time Today Last Week Last Month Show All Discussions only Photos only Videos lost connection to mysql server at 'waiting for initial communication packet only Links only Polls only Filtered by: Clear All new posts Previous Next navicat Senior Member Join Date: Oct navicat lost connection to mysql server 2013 Posts: 122 #1 Lost connection to MySQL server during query 10-17-2013, 09:10 AM I’m a long term user of Navicat on Mac. Since upgrade to the latest version, I got error 2013 lost connection to mysql server at 'reading initial communication packet' “Lost connection to MySQL server during query” when running long query. This happens on all servers. I didn’t change anything and never had this problem before. Tags: None siuha Support Staff Join Date: Oct 2013 Posts: 298 #2 10-17-2013, 10:13 AM You can follow the steps below to set the Socket Timeout option for your server: 1. Close the connection. (Control-click your connection
Error 2013: Lost Connection To Mysql Server During Query
and choose Close Connection) 2. Enable and set "Socket Timeout (sec)" to a large value. If you know how long the query you would run, it is better to set a large value (e.g. query runs 120s, then set the value to 40). Otherwise, you can set it to 0. 3. Open the connection and run the query again. Comment Post Cancel Elijah Junior Member Join Date: Dec 2013 Posts: 1 #3 12-08-2013, 09:24 AM thanks that helped me. Although I needed some time to find out that I can change Socket Timeout (sec) in the connection properties Last edited by Elijah; 12-08-2013, 09:41 AM. Comment Post Cancel siuha Support Staff Join Date: Oct 2013 Posts: 298 #4 12-09-2013, 03:41 AM Originally posted by Elijah View Post thanks that helped me. Although I needed some time to find out that I can change Socket Timeout (sec) in the connection properties You can control-click the connection and select Connection Properties. The option "Socket Timeout (sec)" is under the Advanced tab. Comment Post Cancel Previous Next Go to... Help Contact Us Help Contact Us Working... Yes No OK OK Cancel X
Apparel forum Discussions forum Forum record_voice_over Laracasts Podcast forum Laravel Podcast Forum General Try to connect mysql server with navicate Try to connect mysql server with navicate vipin93 — 1 year ago Hey Buy the Digitalocean service and I
Mysql Workbench
install lamp server but when I try to connect mysql server with help of navicat its showing error lost connection to mysql server at 'reading initial communication packet' system error 0 thanks Best Answer — Thread Owner's Choice school graham — 1 year ago @vipin93 what value have you got for bind-address in /etc/mysql/my.cnf on your server? Check that it is listening on localhost (127.0.0.1) @vipin93 what value have https://community.navicat.com/forum/navicat-product/navicat-for-mysql/147-lost-connection-to-mysql-server-during-query you got for bind-address in /etc/mysql/my.cnf on your server? Check that it is listening on localhost (127.0.0.1) Cancel Update Your Reply graham — 1 year ago Is MySQL set to only allow connections from localhost? If it is you will probably want to setup an SSH connection from Navicat to your MysQL server. Is MySQL set to only allow connections from localhost? If it is you will probably want to https://laracasts.com/discuss/channels/general-discussion/try-to-connect-mysql-server-with-navicate setup an SSH connection from Navicat to your MysQL server. Cancel Update Your Reply SCC — 1 year ago Not sure if you set this up manually or with the Ubuntu LAMP application from Digital Ocean so there could be a number of issues. Could be as @Graham said, is MySQL is set to allow connection only from localhost? If there is an active IP tables firewall is the MySQL remote port (3306) open? Is your own firewall allowing access? Not sure if you set this up manually or with the Ubuntu LAMP application from Digital Ocean so there could be a number of issues. Could be as @Graham said, is MySQL is set to allow connection only from localhost? If there is an active IP tables firewall is the MySQL remote port (3306) open? Is your own firewall allowing access? Cancel Update Your Reply vipin93 — 1 year ago @HC-Lee , @Graham any solution @HC-Lee , @Graham any solution Cancel Update Your Reply graham — 1 year ago You need to give some information @vipin93 you have told us almost nothing so far. Does the machine running Navicat have a firewall running? If it does, try disabling it for a few minutes. Did you try s
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn http://stackoverflow.com/questions/28017125/navicat-lost-connection-to-mysql-server-at-reading-initial-communication-pack more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Navicat - lost connection to mysql server at 'reading initial communication packet', system error: 0 up vote 1 down vote favorite I am getting the error lost connection listed above when trying to connect to my MySQL server via SSH public key in Navicat. I have searched endlessly trying to find a solution to this. I have made sure that the AllowTCP option is enabled, and I have tried setting the hostname to localhost and 127.0.0.1 but neither of them work, it only changes the error to Connection Refused. Here are my connection properties: (General Tab) Hostname/IP Address: mydomain.com Port: 3306 Username: myusername Password: lost connection to mypassword (SSH Tab) Hostname/IP Address: mydomain.com (have also tried localhost/127.0.0.1) Port: 3850 (this is the correct port) Username: myusername Authentication Method: Public Key Private Key: C:\Path\To\My\Key Passphrase: mySSHpassword I know that probably isn't much help because there's not really any "settings" other than the ports, which I know are correct. I am running these exact same credentials on my Macbook which runs SequelPro and it works flawlessly, so I'm lost as to why I can't get it working on my PC through Navicat. Thanks for any help you can provide. mysql ssh navicat share|improve this question asked Jan 19 '15 at 2:26 DanL 1,2331024 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The General tab would be set to localhost (or 127.0.0.1) and the username and password would be the database credentials, not the host credentials. Then the SSH tab would be your host with the username password you use to ssh to the host. It should be the normal ssh port 22. share|improve this answer answered Aug 5 '15 at 15:28 Sean Lynch 656624 Thanks for the reply I'll try this solution when I get home and let you know. My SSH port is 3850 for Sequel Pro, should I still use port 22 for this? –DanL Aug 5 '15 at 18:58 For the SSH