the best way to do mysql, from start to finish, and easier

[Geno Breaker]

since i had fun trying to login, played with a few tools, heres the best way to set this thing up

get mysql, eqemu, etc.

download a copy of premiumsoft's navicat (aka mysqlstudio) from http://www.mysqlstudio.com and install it

run winmysqladmin to get the server up

(no quotes are used in any of these commands)

create a connection by clicking the "connections" button, host will be "localhost", port "3306", user is "root", password is left blank

click "test connection" to see if it works

press "manage users" to get the user account manager

the "add user" button has 3 fields, "user name", "host, and "password", and a large number of checkboxes for priveleges

create your user and password with host "%" and another account with host as "localhost", give both accounts all priveleges

right click on the "localhost" connection and select "new database", name the db "eq"

then go to the mysql command line and add to your db as follows (this includes all responses from mysql and the prompts)

mysql>use eq
database changed

mysql>source E:\Sony\EQEMu-0.4.3-Win32\EQEMu-0.4.3-Win32\db.sql (your actual path will be different, i used mine for ease of understanding)
a bunch of lines that say "Query OK, 1 row affected (0.00) sec"

mysql>INSERT INTO account SET name='eqemu', password='eqemu', status=200;
Query OK, 1 row affected (0.00) sec

mysql>exit;
bye

E:\mysql\bin>