[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

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

M

Master_Hal

Veteran Member
31
2023
4
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
 
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
 
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?
 
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
 
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
 
You must log in or register to reply here.
Back
Top