Unable to create the database. The password might be incorrect or the database is not started.

1

Hi, I’m running Ubuntu 16.04.7, mysql 5.7.33-0ubuntu0.16.04.1 (Ubuntu), openjdk version “1.8.0_292”, tomcat7 and OpenMRS Core 2.3.0 Installation Wizard . The error message indicates: 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.???

mysql server is running and I carefully typed in the correct root password during initialization. I have previously booted up the system with the same tech stack without any issues.

The partial dump of catalina.out is found here

2

On which port is your MySQL server running?

3

It’s running on 3306

4

Are you able to connect to it from command line?

5

yes, no problem

6

Can you connect to it on command line while specifying a port?

7

yes, here’s the command that I used: mysql -h localhost -P 3306 -u root -p

8

For the OpenMRS setup wizard, did you choose the Simple installation method?

9

I used the advanced option

10

Does the Simple setup work?

11

I’ll try it now

12

I still get the same error with the cataline.out dump

13

Can you upgrade your Java version to the latest in the 1.8 series?

14

Or you can try this: https://youtu.be/xSejtYOh4C0

15

We used to recommend this, though it’s been a while so I don’t recall if it fixes things. IIRC, 2.3.x was designed with MySQL 5.6 and earlier versions of MySQL 5.7 that didn’t enforce TLSv1.3.

16

I had installed the latest openjdk 8 via sudo apt-get install openjdk-8-jdk