Use a MySql Sandbox instance with Apache2 Webserver

Asked by Kyle on 2016-02-13

I'm working on a web application that uses a LAMP stack with MySQL 5.6 but I can't update to 5.6 because Muon (my package manager) requires 5.5. Is it possible to have my web application use the 5.6 sandbox instance instead of the 5.5 version that I have installed? I just need this for local development on my machine.

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Sandbox Edit question
Assignee:
No assignee Edit question
Solved by:
Kyle
Solved:
2016-02-13
Last query:
2016-02-13
Last reply:
2016-02-13

It is possible.
However, note that MySQL Sandbox was designed for testing. Thus it is by default less secure than a standard installation. You need to enable all needed security features on your own.
Also, you should disable the 'clear' script, which can remove all your contents without confirmation.

Kyle (kcbusdieker) said : #2

I figured it out! I was inspired by this https://github.com/hijarian/DB-sandbox . I had to change the place that PHP was looking for the database. Instead of 'localhost' I switched to '127.0.0.1' and needed to include the port that my sandbox instance was using.