@stephenwaite, therein lies the problem. I can’t create a user for the openemr database because the openemr database doesn’t exist. I’m relying on the installation script to do that for me, but the database creation step is where the installation is halting when attempting to install version 5.0.2 on Ubuntu Server 18.04. The error message received is that it can’t connect to MySQL with the root account (I’ve eliminated the obvious like verifying the root password I’m entering for step 2 is right, caps lock key is off, no interfering firewall rules, etc.). However, I can connect to MySQL with the root account just fine from the command line.
I downloaded the latest stable release of openemr from this page: https://www.open-emr.org/wiki/index.php/OpenEMR_Downloads I followed the installation instructions available for Linux including installation of all dependencies. The only difference is that I installed Ubuntu Server 18.04 as opposed to Ubuntu Server 16.04 which is the OS version referenced in the installation guide.
I saw your post regarding an install of openemr-php_5.0.1-4_all.deb on Ubuntu Server version 18.04 and then upgraded to 5.0.2. Where do you go to download previous versions of openEMR?
I should point out that I’m not a Linux guru, but I’m no slouch either. I’ve had experience installing and administering several other open source solutions that run on Linux (Alfresco, SugarCRM, Drupal, etc.). I’m encouraged there is a community out there that wants to help physicians regain control of an aspect of their practice that has been lost (documentation of encounter and workflow). I have worked with traditional EMR systems for over 10 years, and in my opinion, they have failed to deliver on their promises. The merger/acquisition activity in the healthcare IT space has only resulted in more confusion and disruption to those trying to deliver medicine in a safe and cost-effective manner. Sorry for the soapbox, but I suspect the reality I describe above drives many “entrepreneurial physicians” to explore alternatives like openEMR. In my experience, most folks don’t have the tenacity or discipline to stay the course when they encounter an obstacle like this (i.e. installation woes), so I greatly appreciate your assistance. I hope the frustration I am currently experiencing with the installation process will be an opportunity to learn and potentially produce a better guide for those that want to test drive the software.