For all of you who are new to the world of Emulation, this is one of the first and foremost things you need to know. Installing Navicat. And how to use it. First off.
1. Go to Navicat - Download the World's Best Oracle Manager, MySQL Front End & PostgreSQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, phpmyadmin, and download Non-commercial (Free) - Lite version For whatever operating system you have ex: Windows, Linux, Mac (this guide is for windows)
2. Install it and make a desktop icon.
3. Click new connection in the top left corner.
4. Enter your My Sql information (if oyu dont have MySQL you need to download that at MySQL :: MySQL 5.0 Downloads and install it)
________________________________________________________________________________ ________________________________________
ARCEMU
5. Once that is done right click that connection (after you open it of course) and click Add New Databse and name it Login
6. Do the same thing as in step 5 except this time make the name World
7. Finally do the same as 5 & 6 but name it characters.
8. Now you have your DB's now installing it.
Right click the Login DB and click Execute Batch File, and click the ... button and find your login.sql in your repack folder and install it (should go quickly)
9. Now right click Characters DB and Execute Batch File again but on characters.sql (should also go quite quickly)
10. Now for the long part DO the same as in step 8 and 9 but right click world and execute world.sql (should take at least 15-30min)
11. Finally you have a database. Now if you're running on ArcEmu you're all done! Now go to your Configs and change the configs to your settings in mysql.
Congratz you now have a functional DB
________________________________________________________________________________ _____________________________________
MaNGoS
Follow all fo the steps as arcemu except making the databases login world and characters make it Mangos characters and realmd
Now you go to realmd table go to the table that says realmlist and change the settings there!
Now for the DB if your repack didn't come with it go to WhyDB - Revision 269: / and download it!...
I know its not very descriptive but I hope it helped. If you have an issue please post it here and I or someone else will be glad to help you out with it!
THX FOR READIN!