[BUG] MySQL 8 does not work with Prism about prism-bukkit HOT 4 CLOSED

Does the error happen to feature a line similar to:
[08:12:30 ERROR]: [Prism] Hikari Pool did not Initialize: Failed to initialize pool: Public Key Retrieval is not allowed
If so then you have the same issue as me

from prism-bukkit.

Namely, the solution to this problem is to install MySQL 5

from prism-bukkit.

MySQL 8 works perfectly fine when configured properly.

If you are getting "Public Key Retrieval is not allowed" here are several solutions, most secure to least secure.

1. Enable SSL (add useSSL=true to the jdbcUrl) and configure it correctly.
2. Store the server's public key somewhere prism can access it and add serverRsaPublicKeyFile=<path to the key file> to the jdbcUrl.
3. Change the db user to use mysql_native_password instead of the default caching_sha2_password (which became the default in 8).
4. Add useSSL=false&allowPublicKeyRetrieval=true to the jdbcUrl.

All of the jcbcUrl changes can be made in the hikari.properties file

from prism-bukkit.

This is not a bug iits a config issue.

from prism-bukkit.