Worldserver.exe with own MySQL Server (Version 8) doesn't work

[Master_Hal]

Hi Buddys,

I've tried to import all databases into my mysql server Vers. 8. The authserver.exe connected well to the database, but the worldserver.exe gave me an error:
"Cannot connect to world database 127.0.0.1;3306;root;XXXXXXXX;emucoach_v17_vip_world"

I've tried both libmysql.dll files...for version 8 and 5.

Does have anyone have an idea?

Thanks
Master Hal

 

[Master_Hal]

I've uploaded the database twice...same issue:

DatabasePool emucoach_v17_vip_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;root;XXXXXXX;emucoach_v17_vip_world

Does anyone know where the SQLDriverLogFile is?

Thanks
Master HAL

 

[Master_Hal]

I've tried several databases and got the same issue. Is it possible that there's something hard coded with the mysql connection in the worldserver.exe?

 

[Master_Hal]

I've got this error too:

ERROR In mysql_stmt_prepare() id: 57, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, speed_swim, speed_fly, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
ERROR 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

I don't know if it has also something to do with the opening of the sql server connection...maybe?

Master HAL

 

[Master_Hal]

As I heard the current Cata V17 isn't compatible with MySQL Version 8....

Is there anything planned on your side for version 8?

Master HAL

 

[Inc]

I recommend you to use older version of MySQL