Has anyone setup a MySQL server recently? I've not done this in a few years and I'm stuck! 
I thought I would rebuilt my local test server on my workstation - clean OS install.
I've installed the latest MySQL Community (v8) including the shell. Last one I used was version 6!
Opened the MySQL Shell up and created a database called `risingworld` also creating a user called `rwadmin` and assigned the user all privileges to the new database. Reopened the shell and connected with new credentials to database to check working. Sure was!

I have then installed a local copy of the RW standalone server via the SteamCMD tool. I won't bore you with screenshots...
I've then gone and changed the server.properties file to reflect the MySQL server.

I run the win_startscript.bat but the server fails to start. 
Rising World - 0.9.6 - Dedicated Server
Windows 10 10.0 Java 1.8.0_251 (amd64) Memory: 1908 MB
____________________________________________________
Initialize Static Classes...
Constructions initialized!
Projectile-Definitions initialized!
Weapon-Definitions initialized!
Food-Definitions initialized!
Crafting-Definitions initialized!
Record-Definitions initialized!
Initializing world (mysql)
java.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'rwadmin'@'localhost' (using password: NO)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:173)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1113)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:503)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:155)
at org.mariadb.jdbc.Driver.connect(Driver.java:86)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at A.a$a.d(SourceFile:103)
at A.a$a.<init>(SourceFile:99)
at server.e.a(SourceFile:1125)
at server.Main.d(SourceFile:435)
at server.Main.initApplication(SourceFile:271)
at commons.JIWApplication.initialize(SourceFile:242)
at com.jme3.system.NullContext.initInThread(NullContext.java:87)
at com.jme3.system.NullContext.run(NullContext.java:130)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user 'rwadmin'@'localhost' (using password: NO)
Current charset is windows-1252. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)
2020/09/22 12:39 PM server.Main
SEVERE: Rising World - 0.9.6 - Dedicated Server
Windows 10 10.0 Java 1.8.0_251 (amd64) Memory: 1908 MB
____________________________________________________
RW SERVER: Fatal error occurred!
java.sql.SQLInvalidAuthorizationSpecException: Access denied for user rwadmin@localhost (using password: NO)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:173)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1113)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:503)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:155)
at org.mariadb.jdbc.Driver.connect(Driver.java:86)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at A.a$a.d(SourceFile:103)
at A.a$a.<init>(SourceFile:99)
at server.e.a(SourceFile:1125)
at server.Main.d(SourceFile:435)
at server.Main.initApplication(SourceFile:271)
at commons.JIWApplication.initialize(SourceFile:242)
at com.jme3.system.NullContext.initInThread(NullContext.java:87)
at com.jme3.system.NullContext.run(NullContext.java:130)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user rwadmin@localhost (using password: NO)
Current charset is windows-1252. If password has been set using other charset, consider using option passwordCharacterEncoding
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)
java.sql.SQLException: Access denied for user rwadmin@localhost (using password: NO)
Current charset is windows-1252. If password has been set using other charset, consider using option passwordCharacterEncoding
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:503)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:155)
at org.mariadb.jdbc.Driver.connect(Driver.java:86)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at A.a$a.d(SourceFile:103)
at A.a$a.<init>(SourceFile:99)
at server.e.a(SourceFile:1125)
at server.Main.d(SourceFile:435)
at server.Main.initApplication(SourceFile:271)
at commons.JIWApplication.initialize(SourceFile:242)
at com.jme3.system.NullContext.initInThread(NullContext.java:87)
at com.jme3.system.NullContext.run(NullContext.java:130)
at java.lang.Thread.run(Unknown Source)
Press any key to continue . . .
Display More
Clearly the Access denied for user 'rwadmin'@'localhost' (using password: NO) is to blame - but I don't get why the password I've supplied in the server.properties file is not being used
I'm a little lost.
