We are using SFS2X 2.17.0 and MySQL 8.0.28.
We are migrating our game to another server. We installed SFS2X and Mysql database. Put out mysql connector named 'mysql-connector-java-8.0.23.jar' in jre/lib/ext folder (also placed under SFS2X/extensions/__lib__ and still no luck, but in our previous server we didn't need to do even that), and set all settings just like as in our previous server. Our Database Manager settings in Zone Configurator screen are attached to this post.
But we are getting this error message in smartflox.log when SFS starts:
Code: Select all
18 Jan 2022 | 21:49:00,240 | ERROR | main | v2.db.SFSDBManager | | java.sql.SQLSyntaxErrorException:
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: java.sql.SQLSyntaxErrorException
Message: Access denied for user 'mysql_user'@'127.0.0.1' to database 'my_db'
Description: The DBManager Test SQL failed: SELECT id FROM test LIMIT 1
Please double check your SQL code and make sure that Database server is running.
We tried to log in with our given Mysql user and password in Mysql Terminal Console to run our test query, it runs without a problem. How can we detect the reason of this error message and make SFS to connect our database?