Thanks. My apologies, I digress, the main purpose of my post was to inform any people already using Navicat or any of the other PremiumSoft products about a problem I ran into Thank you very much! Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the http://www.heidisql.com/forum.php?t=10835

Reading Initial Communication Packet System Error 0

I was able to solve it to change the bind-address on the mysql server. A google search (PuTTY Local ssh tunnel) will provide results for instructions: http://howto.ccs.neu.edu/howto/windows/ssh-port-tunneling-with-putty/ Set the local port to whatever you want (I would just use 3306 for clarity) and the destination All of the above said, this is a bad idea.

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.

Have you checked?

It keeps denying me like crazy....pretty pissed about the whole thing!

I had to do this on Arch Linux before I could connect with Navicat. start a job without interview Where did the popularity of the `i` variable come from? Control-click your connection and choose Connection Information > Copy to Clipboard 3. Mysql System Error 104 QGIS Processing algorithm cannot deal with special characters in input Why were people led to believe that the Apollo mission was fake in Interstellar?

Well, just guesses here. Mysql System Error 102 If I run: mysql -u root -h 162.243.75.66 -p I'm presented with the password prompt. All Aboard the Kolmogorov Complexity Train How can I temporarily neutralize magic things? asked 1 year ago viewed 1745 times active 1 year ago Blog How Do Software Developers in New York, San Francisco, London and Bangalore… Related 14MySQL error: 2013, “Lost connection to

Lost Connection To Mysql Server At 'waiting For Initial Communication Packet

Thanks! navigate to this website Required fields are marked *Comment Name * Email * Website Search Search Polls I have to know, do you like Windows 8? Reading Initial Communication Packet System Error 0 Lost connection to MySQL server at 'reading initial communication packet', system error: 0 0 vegardx October 25, 2014 MySQL clients could be better at error reporting, but this is pretty straight Lost Connection To Mysql Server At Waiting For Initial Communication Packet System Error 10060 How to get sprint progress from complexity-based estimation?

Why did Ponda Baba and Doctor Evazan in the cantina dislike Luke so much? Thank you Submitted by DerFInna974 (not verified) on 18 April, 2010 - 19:35. Advanced Search Forum Server-Side Development SQL #2013 - Lost connection to MySQL server at 'reading initial communication packet' If this is your first visit, be sure to check out the FAQ im totally lost guys sorry, I am getting this error and your saying to put that before all...where is all? Lost Connection To Mysql Server At Reading Authorization Packet System Error 0

Hosts.deny/hosts.allow or iptables (less likely). Mysql Workbench Reading Initial Communication Packet System Error 0 Check that it is listening on localhost (127.0.0.1) @vipin93 what value have you got for bind-address in /etc/mysql/my.cnf on your server? Can you point me in the right direction here? 1 comment 0 asb MOD October 24, 2014 How are you trying to connect to it?

For details, please read MySQL References Manual.

What I finally found to be causing the problem, was TCP_WRAPPERS. Naturally, in my hosts.allow file I had the IP address of my PC in there, so that I could connect Navicat supports connecting through a SSH tunnel, check out the documentation about that. Trending General Discussions Below, you'll find the most popular Laracasts discussion threads in your currently chosen channel. Sqlyog Error 2013 Lost Connection To Mysql You previously marked this answer as accepted.

Log In to Comment 1 Answer 0 info686413 October 24, 2014 I'm trying to connect from the software package called Navicat, which isn't a Command Line interface. The key was the settings in the General Tab. Check the documentation here, http://www.navicat.com/manual/online_manual/en/navicat/rv_manual/SSHSettings.html Alternative clients that support this: MySQL Workbench and SequelPro. 0 info686413 October 25, 2014 @vegardx thanks for your comment. Many systems have default iptables DROP policy, similar to ALL:ALL in /etc/hosts.deny file.

exactly what file path is it in? Hosts file based access control mechanism is very simple and effective, although it is not that widely used. Here are my connection properties: (General Tab) Hostname/IP Address: mydomain.com Port: 3306 Username: myusername Password: mypassword (SSH Tab) Hostname/IP Address: mydomain.com (have also tried localhost/127.0.0.1) Port: 3850 (this is the correct If a rule placed there matches incoming connection, access is granted and further processing stops.

Prove a geometry question about circles and angles Can someone take my Wi-Fi signal DOWN? It's purpose is the same, as we want to deny all incoming traffic and then open several services to certain group of remote computers. Listing sequence with rules How do algebraists intuitively picture normal subgroups and ideals? When I changed it to 0.0.0.0 (all address, including localhost) it worked. 3 posts achbed posted 3 years ago Note to self: When setting up SSH, you MUST set the following

But when I have to get into our database from other machines I use PuTTY. Then the SSH tab would be your host with the username password you use to ssh to the host. Comment Post Cancel Patrick Eidemiller Junior Member Join Date: Sep 2014 Posts: 10 #18 09-17-2014, 06:36 PM I am..... 1 Photo Comment Post Cancel siuha Support Staff Join Date: Oct 2013 I'll run through it again real quick, see if this makes sense. The connection between your PC and the server running database is now encrypted and secure from prying eyes because