Eclipse Community Forums: PHP Development Tools (PDT) » PDT, MySQL, Zend CE... it won't work :(

Help

Home

Home » Language IDEs » PHP Development Tools (PDT) » PDT, MySQL, Zend CE... it won't work :((Issues with mysql )

Show: Today's Messages :: Show Polls :: Message Navigator

PDT, MySQL, Zend CE... it won't work :( [message #529374]

Sat, 24 April 2010 09:27

Pierre

Messages: 2
Registered: April 2010

Junior Member

Hi,

I've recently installed Eclipse with PDT. To debug and use MySQL I've also installed Zend Server CE. But I can't get it to work. I'm not sure if I use the right method and configuration.
In Eclipse I set the debug path to be : "/usr/local/zend/bin/php" and the respective php.ini file: /usr/local/zend/etc/php.ini
It works fine, I can execute the PHP code and everything... but when it comes to the MySQL part it gets ugly.
I used the phpMyAdmin that comes with Zend CE to create tables, users and everything. But when I try to connect to it in my code simply with the mysql_connect method I get "mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)".
I've tried to connect to 'localhost', '128.0.0.1'... with all possible ports (3306...) and still the same error message. I know for sure that my user and pass are correct and that the MySQL server is running since I can access it with phpMyAdmin.
Shouldn't it work out of the box without further configuration? I've tried to change some setting in the php.ini, and messing with the MySQL config but it didn't help so I put everything back to default.

Or is there a simpler / better solution to test the PHP and MySQL code with PDT? I don't want to have to upload my code every time to a web server to test everything...

Thank you so much for you help!

--Pierre

Report message to a moderator