Connection Refused and Server does not create MySQL database

Thanks for this great software,

I am stuck somewhere kindly help
before i write this i read all of mysql issue related traccar forums and try to figure the issue but still no luck

I'am unable to run traccar using mysql server,
With H2 database it's working fine.

I'm under windows Server 2016 Amazone AWS
double check all firewall and ports are open and work fine

First i use JDBC viewer to check connection with same database URL (in DBeaver Version 4.2.5 install in same saver ) it's work fine

Screen image : https://filehost.net/b6f2c3a2c07a0ba0

I use remote mysql db hosted in my Hostgater Server, From Cpanel i allow Remote db Access Hosts all ip and server ip wildcard

Here are the logs :

tracker-server.txt - 0 no data

wrapper.log.20171208 - 3kb

WARNING|wrapper|Service traccar|17-12-08 03:55:36|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-12-08 03:55:36|OS   : Windows Server 2016/10.0/amd64
WARNING|wrapper|Service traccar|17-12-08 03:55:36|JVM  : Oracle Corporation/1.8.0_151/C:\Program Files\Java\jre1.8.0_151/64
INFO|wrapper|Service traccar|17-12-08 03:55:36|start delay: 0
INFO|wrapper|Service traccar|17-12-08 03:55:37|started process with pid 3632
INFO|3632/0|Service traccar|17-12-08 03:55:38|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|3632/0|Service traccar|17-12-08 03:55:39|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|3632/0|Service traccar|17-12-08 03:55:40|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|wrapper|Service traccar|17-12-08 04:36:41|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|17-12-08 04:36:41|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|17-12-08 04:36:41|stopping process with pid/timeout 3632 45000
INFO|3632/0|Service traccar|17-12-08 04:36:41|wrapper manager received stop command
INFO|wrapper|Service traccar|17-12-08 04:36:43|process exit code: 0
INFO|wrapper|Service traccar|17-12-08 04:36:43|Win service stop - after shutdown
INFO|wrapper|Service traccar|17-12-08 04:36:43|Win service stop - before notify
INFO|wrapper|Service traccar|17-12-08 04:36:43|Win service terminated
WARNING|wrapper|Service traccar|17-12-08 04:36:47|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-12-08 04:36:47|OS   : Windows Server 2016/10.0/amd64
WARNING|wrapper|Service traccar|17-12-08 04:36:47|JVM  : Oracle Corporation/1.8.0_151/C:\Program Files\Java\jre1.8.0_151/64
INFO|wrapper|Service traccar|17-12-08 04:36:47|start delay: 0
INFO|wrapper|Service traccar|17-12-08 04:36:47|started process with pid 3384
INFO|3384/0|Service traccar|17-12-08 04:36:50|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|3384/0|Service traccar|17-12-08 04:36:51|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|3384/0|Service traccar|17-12-08 04:36:52|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.

my traccar.xml

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <!--

    This is ....etc
    -->

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://myserverip:3306/dbname?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>dbuser</entry> 
<entry key='database.password'>password</entry>

</properties>

kindly tell me how to use mysql

Looks like server is not able to connect to your database which probably means that URL is wrong.

Dear Anton

I know you're extremely busy person, if you got any free time kindly check my issue
i mailed you server information

Put this

<properties>
<entry key="config.default">./conf/default.xml</entry>

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://myserverip:3306/dbname?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>dbuser</entry> 
<entry key='database.password'>password</entry>
</properties>

Dear Maruti

Thanks for Help me,

Yes it's work like a charm after put my missing line