tinkering with this thing for a couple hours.. Searched forums.. Here's my code

[Halamafx]

I get cant continue without database connection.. How do i fix it?
<?xml version="1.0">
<server>
<world>
<shortname>halamafx</shortname>
<longname>Halamafx's private</longname>

<!-- only specify ithese two if you really think you need to. -->
<address>LocalHost</address>
<localaddress>192.161.1.107</localaddress>

<!-- loging server info. -->
<loginserver>
<host>eqemulator.net</host>
<port>5990</port>
<account></account>
<password></password>
</loginserver>

<!-- sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- enable and set the port for the http service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<database>
<host>localhost</host>
<port>5999</port>
<username>root</username>
<password>berserk</password>
<db>ax_classic</db>
</database>
</server>

just trying to set up a server for my own personal play and it just wont cooperate any suggestions?

[Amra]

Change :
database>
<port>5999</port>

TO

database>
<port>3306</port>

[Halamafx]

its still telling me the same thing.. imma try running through the setup process again and see if i can fix it

[Halamafx]

ok tracked down this error but cant find the file where it would list this as a username..

[Error] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

any info on where or how to change the user 'eq' to 'root' would be great.. i think that would fix my problem but like i said.. i can find anything in any of my documents that says eq in it.

[Amra]

You can use mysql admin to modify user settings.

[Halamafx]

ok now im getting Failed to connect to database: Error: #1045: access denied for use r'eq'@'localhpst'(using passwordd: YES)

why would it be saying this?

Btw.. for future ref. anyone reading this forum all i did was go into mysql admin options and changed the name of the root account to eq.

[Halamafx]

ok redid everything on the guide.. to the t. now getting this error..

Error 1025 Client does not support authentication protocol requested by server; consider upgrading MySQL client.

tried updating still got this problem.. any advice?

[zooilogical]

you need to run cmd and get into your database directory

once your in C:\peq_db
type in this command:
mysql -u root -p and hit enter

enter in the password you used in the instance configuration wizard
you'll get a welcome screen, and a mysql> prompt, then you need to enter the following:

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');

in the newpwd field I would use the same password you used to log in, just hit enter and you should get a response, that may fix the problem.