MySQL Error#: 2013 Lost Connection to MySQL server during query

Report · Nov 11, 2012

Hi all,

I am trying to create a 'MySQL Connection' to a server I have on the local network but receive the following message:

MySQL Error#: 2013

Lost Connection to MySQL server during query

I am using a trial Dreamweaver 5.5 Version 11.5 Build 5354 on a MacBookPro Mac OS X 10.8.2

MySQL resides on a PowerMac G4 Mac OS X Server 10.4.11

MAMP Pro Version 1.9.6.1

MySQL Server version: 5.5.9

PHP version 5.2.17

I have set default ports on MAMP for Apache and MySQL and have opened port 3306 on the router

I have deleted and recreated the server connection and the MySQL connection in Dreamweaver many times, I have set MAMP to run Apache and MySQL on MAMP's ports, and both as www/mysql user and as www/www

I have added privileges for % and localhost Hosts in MySQL for both the MySQL db and the test one I have created

I have set the MySQL connection in Dreamweaver to connect to computername.local and to its IP address, I have tried using MySQL db root user ID and password as well as a newly created test db user with and without password

Still no joy, I get this 2013 error message all the time

Any suggestions? Many thanks in advance for your help

Francesco

Report · Nov 14, 2012

Did you see any error on mysql_error_ log ?

-Harshit