I am trying to install OpenMRS on my MacBook, however, during the installation wizard I get the following error:
“Unable to create the database. The password might be incorrect or the database is not started.
???Error executing sql: create database if not exists ? default character set utf8 - Could not create connection to database server. Attempted reconnect 3 times. Giving up.???”
I remember facing a similar issue a while ago, downgrading my Mysql to the right version worked for me. In the link that I have provided, the versions mentioned are that for an older version of OpenMRS. Based on your platform version, kindly do ensure that you have the correct versions of Mysql, Tomcat etc. installed. If you still face an issue, kindly do paste your logs like Daniel has mentioned.
I tried downgrading everything, still, I get the same error. I downgraded to Java 8u65, Tomcat 8.5.32, MySQL Server 5.6.40 and OpenMRS 2.0.5. I am currently trying to install OpenMRS on a MacBook Pro 10.13.5. Our plan is to configure the network tomorrow and, afterwards, install OpenMRS on a Windows Server 2016. Please find the Tomcat log here: https://pastebin.com/MdizBqzz
Would it maybe be possible to help us via Teamviewer?