Hello,
I am very new to openEMR, but very interested in using it. I downloaded and installed all the necessary components (Apache, PHP, mysql, and openEMR). I believe that Apache, PHP, and mysql are all successfully installed. However, when I run the openEMR setup script, I get the following error at Step 3:
OpenEMR Setup
Step 3
Connecting to MySQL Server…
Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (2) in /Library/WebServer/Documents/openemr/setup.php on line 159
ERROR. Check your login credentials.
Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (2) (#2002)
I am attempting to run this on a Macintosh G4 running OS X (10.4.4). From the command line, I can sucessfully login to mysql. I would greatly appreciate any help that you can give me. Thanks…
Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (2)
This is an error message that usually is generated by MySQL and is not related to OpenEMR per se. It likely means that the MySQL server is not running.
Check that MySQL has been installed correctly and that the server has actually been started.
On a command prompt you shoulde be able to connect with
shell# mysql -u root -p
This will work only if the user root password has already been set.
If you have not set the MySQL root password, running:
shell# mysql -u root
Should result in you connecting to the MySQL command interpreter it should look like this:
mysql>
The OpenEMR setup routine won’t work if you can’t connect like this.