[SOLVED]  PHP Runner Database on a Raspberry Pi

This topic is locked

[SOLVED] PHP Runner Database on a Raspberry Pi	10/11/2013 11:39:35 AM
PHPRunner General questions
C crhys author Hi, I am attempting to create a local database for very simple data collection, ideally I would like this to run on a Pi (to keep costs to a minimum), I am having a few issues connecting to the MySQL when creating a new PHPRunner project, keep getting HTTP Code: 500 Internal Server Error when trying to connect. Installed the usual LAMP modules, Apache2, PHP5 and SQL with PHPMyAdmin - also installed a FTP client (all these work great). Possibly a permissions or port issue, opened up 3306, 80, 22, 21 etc. etc. Any thoughts appreciated.


C	crhys author 10/11/2013
	Hi, I am attempting to create a local database for very simple data collection, ideally I would like this to run on a Pi (to keep costs to a minimum), I am having a few issues connecting to the MySQL when creating a new PHPRunner project, keep getting HTTP Code: 500 Internal Server Error when trying to connect. Installed the usual LAMP modules, Apache2, PHP5 and SQL with PHPMyAdmin - also installed a FTP client (all these work great). Possibly a permissions or port issue, opened up 3306, 80, 22, 21 etc. etc. Any thoughts appreciated. Found the solution, Raspberry Pi MySQL only accepts local connections, to enable remote connections the mysql config file must be edited. Have a look in /etc/mysql for a file called my.cnf Comment out this line :- bind-address = 127.0.0.1