Geno Breaker
06-03-2003, 07:59 PM
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>
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>