Bit of trouble with mysql

I had it up and running for quite a while on a different host, but we've moved servers so I had to set up a new mysql server on a digitalocean droplet. I can connect to it fine from my laptop and a different linux vm:

mysql -u myuser -h xx.xx.xx.xx -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 8.0.28-0ubuntu0.20.04.3 (Ubuntu)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| rustinated         |
+--------------------+
2 rows in set (0.27 sec)

mysql> 

But playerranks doesn't like it for some reason:

 

"MySQL": {
    "useMySQL": true,
    "autoWipe": true,
    "sql_port": 3306,
    "sql_host": "xx.xx.xx.xx",
    "sql_db": "rustinated",
    "sql_user": "myuser",
    "sql_pass": "mypass",
    "tablename": "playerranksdb",
    "LBtableName": "playerranksLeaderdb"
  }

(the IP, user and pass are the same of course).

 

In my droplet I basically allowed all IP's to 3306 in UFW, but also specifically allowed the IP of the server box. I still just get this:

 

playerranks.save
[PlayerRanks] Couldn't connect to SQL. Please check config credentials and ensure that SQL host is whitelisting Rust server IP.
[PlayerRanks] PlayerRanks local database was saved.
Calling 'CmdSave' on 'PlayerRanks v2.1.9' took 590ms

 

Not sure what I'm missing...

Does the server box need mysql installed, or does this just take care of it - https://umod.org/documentation/api/database

Edited April 3, 2022 by crunch

Ok, well after trying a bazillion things, downgrading from mysql 8 to mysql 5 fixed it immediately. So I guess there's some compatability issue there somewhere. Working again now anyway

а так и не решили данную проблему?