EQEmulator Forums - world and mysql in diff comps

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - world and mysql in diff comps (https://www.eqemulator.org/forums/showthread.php?t=17923)

world and mysql in diff comps

Is it possible to setup mysql on a different computer than the one that is running EQEmu?

Quote:

Is it possible to setup mysql on a different computer than the one that is running EQEmu?

Yes, it is. You will need to do two things:

Edit db.ini so that your database will point to the IP address of the computer running MySQL, instead of "localhost". You will also need to update permissions on the computer running MySQL if you wish to edit your database from a different machine.

Quote:

GRANT ALL PRIVILEGES ON *.* TO 'username'@'ipaddressyouareaccessingfrom' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

This should work for you, it worked for me in the past. Good luck.

Regards,
SI

It's possible but I don't advise it if it can be avoided. The zone servers do a hell of a lot more querying than you think and the extra time going across a network connection can be noticeable if your server has any traffic at all on it.

this is just for testing servers

This is just for testing, I have a couple P4 comps, 2.4 and 1.7, just want to see the diff in the load on the comps.