Getting a issue with a VM using fastpanel CP, and MYSQL 8.0, but I have been reading that it works on mysql 5.7?
My exact issue is below thanks!
mysql -u myuser -h xx.xx.xx.xx -p
After entering the password, I get:
```
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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| rust 112 |
+--------------------+
2 rows in set (0.27 sec)
However, the `playerranks` plugin is unable to connect, despite using the correct configuration:
```json
"MySQL": {
"useMySQL": true,
"autoWipe": true,
"sql_port": 3306,
"sql_host": "xx.xx.xx.xx",
"sql_db": "rust112",
"sql_user": "myuser",
"sql_pass": "mypass",
"tablename": "playerranksdb",
"LBtableName": "playerranksLeaderdb"
}
```
(The IP, username, and password are identical to those used successfully elsewhere.)
On the new, I configured UFW and also the edge firewall to allow all IPs to port 3306 and explicitly permitted the Rust server’s IP. Despite this, I receive the following error:
```
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
```
I’m unsure what’s causing the issue! I have tried this now on 3 different web hosts with different IP's and setups and they all have the same error.
