Hi, can you check the catalina or tomcat LOG to see what the error is? I'm not sure in mysql but at least in postgres you have to make two adjustments: make the server "listen" to all ports and allow connections from the IP where Joget was installed. On the other hand, it is highly recommended that you generate a specific user (other than root) 

Hi - MySql is most likely listening on port 3306 - trying changing the port from 3307 to 3306 on the URL string.

Cheers - Tony

Hi Camilo,

Thanks for your comment, I created multiple users in mysql and I used the image root to indicate that even the root account did not work.

Both Joget and MySQL are installed locally and I have checked that MySQL server is listening to port 3306.

But unfortunately I can not connect to the external database yet.

Hoi Anthony, I have also tried that but unfortunately it did not work.

Maybe you can use MySQL client like HeidiSQL to test a connection from Joget server to the external database first. Check if any firewall running on the external db server.

And the URL should be in this format:

jdbc:mysql://{external_db_ip_address}:{mysql_port}/{database_name}?characterEncoding=UTF-8

Hi Lee, I use this url: jdbc:mysql://127.0.0.1:3306/ivedis?characterEncoding=UTF-8, because Joget WorkFlow Professional and MySQL Workbench are running on the same local PC.

I have also used HeidiSQL to test my connection without any problems. Networktype : MySQL (TCP/IP) Hostnaam/IP: 127.0.0.1 Port: 3306 Database: Ivedis

As Camilo suggested, try checking the tomcat logs first. There should be details on the exception that might identify the actual error.

Cor- just pointing out that you are trying to connect on port 3307 from joget and server is listening on port 3306. be sure to change your url accordingly.... Cheers - Tony

I think we need log file to see the error.