OK, I'll tell you exactly, step-by-step, how I got mine to work and we'll go from there... I should note that I've been using version 4.4 developer release 1 with Dwarde's WorldData 1.1. beta 5 database.
Install and Patch EQ
Install EQEmu Patcher program to the EQ directory so that patcher.exe is in the same folder as eqgame.exe
Run EQEmu Patcher
Install MySQL (I'm using version 4.0)
Run WinMySQLAdmin.exe
Set up username and password (we'll use the examples of "username" and "password" for any point that the username and password otherwise need to be used).
Start MySQL Service (in XP this means right clicking on the winmysql icon in teh sys tray, selecting WinNT, and clicking on Start Service)
Close or Hide winmysqladmin so that the service is still running in teh background but the window isn't up anymore
copy all sql files and "items_44dr1.txt" to your MySQL\bin directory
Open a command line window
Use the "cd" (change directory) command to navigate to the MySQL\bin directory
Run mysql.exe
Enter the command: "create database eq;" (the semi-colon tells mysql that is the end of the command, "eq" can be replaced with pretty much anything you want the database to be called but "eq" works great because it's simple and short and doesn't require you have much of a memory or that you type ver much like I tend to)
Enter the command: "use eq;"
Enter the command: "source db.sql"
Enter the command: "source Reloaddb.sql"
Enter the command: "source items_44dr1.txt"
Enter the command: "source books.sql"
Enter the command: "INSERT INTO account SET name='eqemu', password='eqemu', status=200;" where "eqemu" can be replaced by the username and password you intend to use to connect to the minilogin authentication server program (the username and password you will use at the "connect" screen within EQ itself when trying to access the server select screen)
Enter the command: "exit" This will bring you back to the command prompt at the mysql\bin directory
Enter the command: "mysql.exe --user=root eq" where "eq" is the name of the database you created with the "create database" command just a minute ago... this will open up mysql again but with "root" user which gives you total access to all databases and tables
Enter the command: "GRANT ALL PRIVILEGES ON *.* TO username@127.0.0.1 IDENTIFIED BY 'password' WITH GRANT OPTION;" where username and password are the username and password you set up when you first launched WinMySQLAdmin
Enter the command: "exit" This will bring you back to the command prompt
Enter the command: "exit" again This will close the command line window (you can also click on teh "X" on the window)
Install EQEmu Admin Tool
Run EQEmu Admin Tool... you WILL get a couple of errors at this point, don't worry about them yet.
Once EQEmu Admin Tool is running click on the "Preferences" button at the bottum center of the program window
Change the EQ executables directory (if necessary) to point to the proper directory where eqgame.exe is located
Change the username and password fields to contain teh username and password you set up when you first launched WinMySQLAdmin
Change the database (if necessary) to match the database name you set up with mysql.exe's "create database" command
Change database host IP (if necessary) to 127.0.0.1
Click OK
At this point the EQEmu Admin Tool SHOULD properly connect to the database and load the data.
It should be noted that I've had trouble getting EQEmu Admin Tool to properly read database information using the databases I listed above and to get it to work properly I created database "eq2" and sourced the following files... db.sql from Emu version 4.3, items_44dr1.txt, books.sql... I did NOT source db.sql from version 4.4 dr 1, nor did I source reloaddb.sql. Once I did that and set EQEmu Admin Tool to connect to database "eq2" it worked fine.
Hope that info helps some.
Maranwe
|