Setting up MySQL server - help needed!

yahwho · Sep 22nd 2020

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.

Code

Rising World - 0.9.6 - Dedicated Server
Windows 10 10.0  Java 1.8.0_251 (amd64)  Memory: 1908 MB
2020/09/22   00:39 PM
____________________________________________________

Start context...
Items initialized!
Plants initialized!
NPCs initialized!
Initialize Static Classes...
Constructions initialized!
Projectile-Definitions initialized!
Weapon-Definitions initialized!
Objects initialized!
Clothing initialized!
Picking initialized!
Food-Definitions initialized!
Storages initialized!
Vehicles initialized!
Crafting-Definitions initialized!
Record-Definitions initialized!
Initializing world (mysql)
MySQL Connections: 10
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)
        ... 14 more
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
2020/09/22   00:39 PM
____________________________________________________
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)
        ... 14 more
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)

EXIT
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.

yahwho · Sep 22nd 2020

Haha fixed it.

Anyone else using the latest MySQL server build you will need to set the password as native via the shell.

Code

\sql ALTER USER 'rwadmin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'thisissillypassword';
\sql FLUSH PRIVELEGES;

Participate now!