just to clarify:
winmysqladmin is used to create and drop databases
mysql is the tool in mysql/bin that is used to look at things and change things in the database
and mysqld is background mysql processor that puts your database out for connections.
None of the mysql stuff works until mysqld is running.
And none of the mysql db stuff can be done until you create a database.
so the sequence is like this:
-run mysqld
-created eqemu database with winmysqladmin
-in mysql
use eq
source db.sql where db.sql has been copied to mysql/bin
while you are in mysql might as well upgrade you eqemu user with:
update account set status=200 with name='eqemu';
Then modify you loginserver.ini for local addresses and also make sure your boot5zones batch file is set correctly (most people don't need to change anything).
also modify db.ini so that your name and password is the same as you mysql admin and your host is localhost.
Then its:
run minilogin, run world, run boot5zones
run your client (either as "eqgame patchme" or with eqw 2.2) with eqhost.txt pointing to your minlogin server
then login in with eqemu and password eqemu
select the only server listed and you are on your way.
***AND always work with a backup directory, never with your EQLive directory***
It may sound like a lot of work for a local single connection, but after this it is only a minor tweak here and there to get it to work with other configurations.
|