Problem/Bug World Guard Help - 1.18

Previously on 1.17 the server was running fine with worldguard and mysql.
However after updating to 1.18, and updating java to the latest for 1.18 I cannot now connect worldguard to mysql using jbdc.
The database is working, and I can connect to using mysql-workbench.

This is the error I get, also the config hasn't changed and is still set to connect via sql

Code:

[10:42:45 WARN]: [WorldGuard] Failed to load the region data for 'earth' (periodic attempts will be made to load the data until success)
com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to migrate database tables
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.initialize(SQLDriver.java:110) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.initialize(SQLRegionDatabase.java:86) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLRegionDatabase.loadAll(SQLRegionDatabase.java:203) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.RegionManager.load(RegionManager.java:100) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.RegionContainerImpl.createAndLoad(RegionContainerImpl.java:138) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.RegionContainerImpl.load(RegionContainerImpl.java:115) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.bukkit.BukkitRegionContainer.load(BukkitRegionContainer.java:117) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.regions.RegionContainer.loadWorlds(RegionContainer.java:175) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.protection.regions.RegionContainer.reload(RegionContainer.java:97) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.worldguard.commands.WorldGuardCommands.reload(WorldGuardCommands.java:115) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.invokeMethod(CommandsManager.java:525) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:513) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:468) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.execute(CommandsManager.java:406) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onCommand(WorldGuardPlugin.java:278) ~[worldguard-bukkit-7.0.6-dist.jar:?]
        at com.sk89q.bukkit.util.DynamicPluginCommand.execute(DynamicPluginCommand.java:55) ~[worldedit-bukkit-7.2.9.jar:?]
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:159) ~[paper-api-1.18.2-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:905) ~[paper-1.18.2.jar:git-Paper-231]
        at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchServerCommand(CraftServer.java:868) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:510) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:484) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1458) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1227) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:317) ~[paper-1.18.2.jar:git-Paper-231]
        at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: java.sql.SQLException: Failed to get a SQL connection due to an error

 

I have and still the same issue

 

Code:

[13:18:11 WARN]: [WorldGuard] Failed to migrate
com.sk89q.worldguard.protection.managers.migration.MigrationException: Migration failed because the process of getting a list of all the worlds to migrate failed
        at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:65) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.regions.RegionContainer.migrate(RegionContainer.java:160) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.commands.region.RegionCommands.migrateDB(RegionCommands.java:1039) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.invokeMethod(CommandsManager.java:525) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:513) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.executeMethod(CommandsManager.java:468) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.minecraft.util.commands.CommandsManager.execute(CommandsManager.java:406) ~[worldedit-bukkit-7.2.9.jar:?]
        at com.sk89q.worldguard.bukkit.WorldGuardPlugin.onCommand(WorldGuardPlugin.java:276) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.bukkit.util.DynamicPluginCommand.execute(DynamicPluginCommand.java:55) ~[worldedit-bukkit-7.2.9.jar:?]
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:159) ~[paper-api-1.18.2-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:905) ~[paper-1.18.2.jar:git-Paper-231]
        at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchServerCommand(CraftServer.java:868) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:510) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:484) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1458) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1227) ~[paper-1.18.2.jar:git-Paper-231]
        at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:317) ~[paper-1.18.2.jar:git-Paper-231]
        at java.lang.Thread.run(Thread.java:833) ~[?:?]
Caused by: com.sk89q.worldguard.protection.managers.storage.StorageException: Failed to fetch list of worlds
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:94) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        ... 21 more
Caused by: java.sql.SQLException: Failed to get a SQL connection due to an error
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getConnection(SQLDriver.java:250) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:86) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        ... 21 more
Caused by: java.util.concurrent.ExecutionException: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:?]
        at java.util.concurrent.FutureTask.get(FutureTask.java:205) ~[?:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getConnection(SQLDriver.java:246) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver.getAll(SQLDriver.java:86) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.migration.AbstractMigration.migrate(AbstractMigration.java:55) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        ... 21 more
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at java.sql.DriverManager.getConnection(DriverManager.java:681) ~[java.sql:?]
        at java.sql.DriverManager.getConnection(DriverManager.java:229) ~[java.sql:?]
        at com.sk89q.worldguard.util.sql.DataSourceConfig.getConnection(DataSourceConfig.java:141) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver$1.call(SQLDriver.java:241) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at com.sk89q.worldguard.protection.managers.storage.sql.SQLDriver$1.call(SQLDriver.java:238) ~[worldguard-bukkit-7.0.7-dist.jar:?]
        at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
        ... 1 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure