# Unable to create the database. Giving up.??? **URL:** \ **Category:** Development\ **Created:** [July 9, 2020, 4:44pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378 "2020-07-09T16:44:41Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![iactusmedia](https://talk.openmrs.org/letter_avatar/iactusmedia/32/5_5575768a8748004e209b776fc1b2916d.png) [@iactusmedia](https://talk.openmrs.org/u/iactusmedia)\ **Post date:** [July 9, 2020, 4:44pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/1 "2020-07-09T16:44:41Z")
Guys, I’m totally fedup with this installation process. I can’t able to get any guide lines. Installation that i follow - 1. Install Xampp 2. Start Apache & Mysql 3. Set password for root in my phpmyadmin. (user : root | pass : root) 4. Copy paste the openmrs.war in /tomcat/webapps 5. Started the tomcat in console server start sucessfully prompt came. 6. Load the url localhost:8080/openmrs 7. Selected Simple 8. Enter mysql password as root (Which was config in step 3) 9. After next 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.??? what could be the solution or i’m missing anything during installation. ALL LATEST VERSIONS i’m using Regards, MATHAN ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 4:55pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/2 "2020-07-09T16:55:36Z")
For some reason,i have faced this a few days back and almost had every thing ok,i was using platform 2.4 snapshot,which openmrs version are you using?? ---
**Author:** ![iactusmedia](https://talk.openmrs.org/letter_avatar/iactusmedia/32/5_5575768a8748004e209b776fc1b2916d.png) [@iactusmedia](https://talk.openmrs.org/u/iactusmedia)\ **Post date:** [July 9, 2020, 5:02pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/3 "2020-07-09T17:02:54Z")
# Reference Application 2.10.0 ### Individual Components for Advanced Installation Released 06-April-2020 Linux, Mac OS X, Windows · [Release Notes](https://wiki.openmrs.org/display/RES/Release+Notes) For production use of the Reference Application, you must install an OpenMRS Platform WAR, which requires an existing Java servlet container such as Apache Tomcat, and an existing database such as MySQL. Download these individual components here: [Download Platform 2.3.0 WAR](https://sourceforge.net/projects/openmrs/files/releases/OpenMRS_Platform_2.3.0/openmrs.war/download) using this ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 5:05pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/4 "2020-07-09T17:05:36Z")
And the java version and mysql version? ---
**Author:** ![iactusmedia](https://talk.openmrs.org/letter_avatar/iactusmedia/32/5_5575768a8748004e209b776fc1b2916d.png) [@iactusmedia](https://talk.openmrs.org/u/iactusmedia)\ **Post date:** [July 9, 2020, 5:07pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/5 "2020-07-09T17:07:41Z")
C:\Users\Maddy\>java -version java version “1.8.0\_251” Java™ SE Runtime Environment (build 1.8.0\_251-b08) Java HotSpot™ 64-Bit Server VM (build 25.251-b08, mixed mode) Mysql version - Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.4.5 - Database client version: libmysql - mysqlnd 7.4.5 - PHP extension: mysqli - PHP version: 7.4.5 ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 5:12pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/6 "2020-07-09T17:12:45Z")
try using mysql 5.7 and apache tomcat 8.5.5!! ---
**Author:** ![iactusmedia](https://talk.openmrs.org/letter_avatar/iactusmedia/32/5_5575768a8748004e209b776fc1b2916d.png) [@iactusmedia](https://talk.openmrs.org/u/iactusmedia)\ **Post date:** [July 9, 2020, 5:15pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/7 "2020-07-09T17:15:56Z")
could you please ping me in whatsapp +918248175266. I think i’m using Xampp latest version XAMPP for Windows 7.4.5 ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 5:18pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/8 "2020-07-09T17:18:01Z")
you could actually get me here [https://webchat.freenode.net/](https://webchat.freenode.net/) ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 5:20pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/9 "2020-07-09T17:20:21Z")
at that channel i use yherbert. ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 9, 2020, 6:16pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/10 "2020-07-09T18:16:36Z")
@iactusmedia kindly add steps that we have went through to solve this here so as to help others,thanks ---
**Author:** ![bad.mike](https://talk.openmrs.org/user_avatar/talk.openmrs.org/bad.mike/32/12378_2.png) [@bad.mike](https://talk.openmrs.org/u/bad.mike)\ **Post date:** [July 9, 2020, 11:14pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/11 "2020-07-09T23:14:23Z")
Hello guys, I don’t want to start another topic with the same case. I am a freshman strugling with database creation during the initial start. I already downgraded MySQL to 5.7 and Tomcat to 8.5.5. Do you think that having jdk-14.0.1 may cause issues with openmrs test database creation? Slowly I am running out of ideas. ---
**Author:** ![reagan](https://talk.openmrs.org/user_avatar/talk.openmrs.org/reagan/32/10652_2.png) [@reagan](https://talk.openmrs.org/u/reagan)\ **Post date:** [July 9, 2020, 11:35pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/12 "2020-07-09T23:35:20Z")
@bad.mike I am not sure if we have hit java14, Am certain of at least [java 11](https://talk.openmrs.org/t/upgrading-from-jdk-8-to-openjdk-11/23181/) so you could try downgrading just to be sure.@dkayiwa , @mksd , @ibacher could have a more concrete answer. ---
**Author:** ![herbert24](https://talk.openmrs.org/user_avatar/talk.openmrs.org/herbert24/32/8178_2.png) [@herbert24](https://talk.openmrs.org/u/herbert24)\ **Post date:** [July 10, 2020, 4:49am UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/13 "2020-07-10T04:49:05Z")
@bad.mike could you use java 8 ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [July 10, 2020, 8:11am UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/14 "2020-07-10T08:11:50Z")
> [@reagan](#): > > I am not sure if we have hit java14 The master branch of the OpenMRS platform runs all these Java versions 8,9,10,11,12,13,14 as you can see here: [Travis CI - Test and Deploy with Confidence](https://travis-ci.org/github/openmrs/openmrs-core/builds/706757480) And so is there reference application version 2.11.0-SNAPSHOT ---
**Author:** ![bad.mike](https://talk.openmrs.org/user_avatar/talk.openmrs.org/bad.mike/32/12378_2.png) [@bad.mike](https://talk.openmrs.org/u/bad.mike)\ **Post date:** [July 10, 2020, 8:42pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/16 "2020-07-10T20:42:25Z")
Currently I downgraded to jdk 8.0.251, tomcat 8.5.5, MySQL 5.6.47 and still cannot create the test database. Additionally IntelliJ shows some problems within the main openmrs-core pom.xml: lines 1030-1031 (org.codehaus.sonar-plugins.java, sonar-jacoco-listeners), 1055-1056 (maven-jxr-plugin, 2.3), 1099-1102 (all parameters eg. parsedVerson.majorVersion…). But the second one may stay for another topic since maven showed no problems during compilation. ---
**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\ **Post date:** [July 11, 2020, 8:08pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/17 "2020-07-11T20:08:24Z")
Can you share the full log via [pastebin.com](http://pastebin.com)? ---
**Author:** ![bad.mike](https://talk.openmrs.org/user_avatar/talk.openmrs.org/bad.mike/32/12378_2.png) [@bad.mike](https://talk.openmrs.org/u/bad.mike)\ **Post date:** [July 13, 2020, 8:51pm UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/18 "2020-07-13T20:51:43Z")
@dkayiwa could you please specify which log you have in mind? IJ was used just for the source code check then I complied it with maven using command line so I am not sure if its log will help. ---
**Author:** ![jwnasambu](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jwnasambu/32/13543_2.png) [@jwnasambu](https://talk.openmrs.org/u/jwnasambu)\ **Post date:** [July 14, 2020, 5:05am UTC](https://talk.openmrs.org/t/unable-to-create-the-database-giving-up/29378/19 "2020-07-14T05:05:23Z")
> [@dkayiwa](#): > > Can you share the full log via [pastebin.com](http://pastebin.com) Copy the error you are getting into [pastebin](https://pastebin.com/) and share the link.