I want to install OpenEMR on my WindowsXP machine. Since I do not have an Apache installation already, I want to use the Windows-XAMMP install. The problem is, I already run MySQL on this machine and don’t want to get rid of it. I installed OpenEMR from this package, but when I try to run it , I get a message saying mysqld is not running. Well, it is running, but it is my previously installed MySQL. How can I make OpenEMR aware of the currently running MySQL when I can’t even access it through the browser?
Before using your previous mysql instance, read step 1 in the following installation manual: http://www.openmedsoftware.org/wiki/OpenEMR_3.2_Windows_Installation
(Note the very important instructions in parentheses of step 1 - very common for windows to set the sql-mode which will break openemr horribly)
When deal with above, rec doing a re-install of openemr on your xampp, by simply copying the original library/sqlconf.php here on sourceforge to your instance, and then runnning openemr/setup.php in your browser following instructions in above link.
Here is original sqlconf.php file: http://openemr.cvs.sourceforge.net/viewvc/openemr/openemr/library/sqlconf.php?revision=1.6
I did take a look at that step. However, I was mainly reading the instructions for the XAMMP install, because that is what I want to do. I don’t want to have to install all the pieces separately. All I want is to be able to configure the software to use my existing MySQL, but stick with the Apache and other goodies in the XAMMP install. The download site says that is the recommended install, and since I hate getting into nasty configuration problems (which seems to happen when not doing things the recommended way), I was hoping to stick with that install.
Using my above instructions will only replace your current mysql with the one included in xampp. You’re still gonna use the apache and php that’s included with xampp package. By replacing sqlconf.php file (basically turning the config flag in it to 0), you’re then gonna use setup.php to create the database on your mysql that is already installed. You don’t need to worry about the additional steps discussed in setup (apache and php configuration since your using these form the xampp package).