[Archive] Worldserver.exe with own MySQL Server (Version 8) doesn't work
[Archive] Worldserver.exe with own MySQL Server (Version 8) doesn't work
Original source
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
rektbyfaith
11-04-2025, 05:10 PM #1Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
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
Original source
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
rektbyfaith
11-04-2025, 05:10 PM #2Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
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
Original source
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?
rektbyfaith
11-04-2025, 05:10 PM #3Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
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?
Original source
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
rektbyfaith
11-04-2025, 05:10 PM #4Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
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
Original source
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
rektbyfaith
11-04-2025, 05:10 PM #5Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
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
Original source
I recommend you to use older version of MySQL
rektbyfaith
11-04-2025, 05:10 PM #6Archived author: Master_Hal • Posted: 2025-11-04T18:10:21.230632
Original source
I recommend you to use older version of MySQL
1 Guest(s)
1 Guest(s)