PHP web application can't connect mysql installed with Zend Server CE on Mac OSX

0

I'm setting up development environment on Mac OSX.

However the PHP web application can't connect the mysql server installed with Zend Server CE.

The error information is below,

[Type] dbnot_connect
[2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 61

Mysql database can be accessed via phpAdmin installed with Zend Server CE as well.

The same code works well on Windows or Linux in Zend Server CE.

Kane

Posted 2012-03-25T06:15:04.413

Reputation: 305

Is the phpMyAdmin installed on the server or on your development environment? It could be an issue with your bind not allowing outside of localhost access. If this is not the case then check your connection string to make sure that it's coded properly. – kobaltz – 2012-03-25T06:19:57.917

phpMyAdmin is installed my Mac as well. It can access mysql server(installed on Mac). And the code is checked out from source control, it works well to linux/windows to access the mysql installed with Zend Server on linux/windows. – Kane – 2012-03-25T06:50:31.687

Answers

0

Try connecting on the command line to mysql - perhaps you need to specify a different port? Also there is the issue of the file /var/mysql/mysql.sock in Lion - you have to link this file. Here's a list of instructions: http://akrabat.com/php/setting-up-php-mysql-on-os-x-10-7-lion/

Scott C Wilson

Posted 2012-03-25T06:15:04.413

Reputation: 2 210

Asked: 2012-03-25T06:15:04.413

Viewed: 1 221 times

Active: 2012-03-25T11:17:07.323