Mac OS High Sierra 10.13.6 - the connection to the database could not be established

Even though I have downloaded the most compatible version of Java I keep getting this message when trying to create a database: No Java installation could be found. Please check your installation.

Please advise if anyone has encountered / resolved this issue

Might be this helps:

Seems Mac needs not only JRE, but whole JDK …

Thank you for your reply.