I am in the process of setting up OpenEMR for use in clinics in a developing nation. I downloaded the xampp package and everything was working fine. Today when I went to make some final changes to the setup, the localhost page is now showing the message “check that mysqld is running”. It’s never done this before, and according to the control panel both mysql and apache are running. I haven’t changed anything in xampp, so I’m hoping this is something simple. We are leaving the US saturday morning so any help would be greatly appreciated.
Hi Jen,
Can you please check on the OpenEMR SQL configuration file for Username, password and the database name. The file can be found under openemr home folder -> Sites -> default (sitename)-> sqlconf.php.
According to the php file, the settings are as follows:
$host = ‘localhost’;
$port = ‘3306’;
$login = ‘openemr’;
$pass = ‘escargot’;
$dbase = ‘openemr’;
As I said, I’ve never changed any of these settings. The program has always worked perfectly, until I attempted to go to the localhost website today and got the error message. I checked the services list, and both apache and mysql are showing up (The mysql is a lowecase m, which I believe someone asked in a similar discussion). The services are both running in the xampp control panel, with apache on ports 80 and 443, and mysql on port 3306.
Unfortunately, this program has me at the extreme edge of what I know about this type of software. I’m a medical student, and we’re setting up this system for use in a rural clinic setting. We’re trying to increase the continuity of care for this patient population.
Can you try restarting mysql and check if your able to login in OpenEMR. Further if this fails, login into sql and check if the database and the users exists in mysql (Screenshot attached) as per the configurations you have done.
I performed a recommended system update and the restarted the computer, and for some reason it now works. I still have no idea what the problem was. As for the php files, none of the configurations were done by me. They were all left as is from when I installed the xampp package. Since we’re not using a net based setup, I’m using local network encryption to ensure security so I didn’t really mess with any software settings. If this happens again, I will check the things you suggested.
Thank you so much for responding so quickly!! I’m really excited about getting this program running, because we think it’ll really make a difference for our patient population.