mysql upgrade.

[Hogge]

Hello, iam using the Mop v4.1 paid version, and with the orginal MySQL 5.5.9 it works great but the server iam using have MySQL 8.1.0 already installed and using it for other things so can't downgrade.

Now Authserver works and get connection but Worldserver can't connect and i get some errors.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangea' at line 1
DatabasePool mop_world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;xxxx;xxxx;mop_world

Is there anyway to fix this or do i need to use the old version of MySQL?

 

[nicalicious]

Tried upgrading mysql to 8 as well. ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password' BY 'ascent'; allowed the auth server to communicate but the worldserver.exe would give the same error as above.