Mysql error

FlitTastic · #1 08-22-2008, 07:56 PM

Lets try again....

Here is my config file contents:

<?xml version="1.0">
<server>
<world>
<shortname>Oasis</shortname>
<longname>Oasis Revisited</longname>






<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>






<tcp ip="localhost" port="9000" telnet="disable"/>


<key>some long random string</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>********</password>
<db>peq</db>
</database>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

I was having trouble and completely un-installed and re-installed everything. Anyway, I click on the Start.bat and a couple windows flash so fast that I cant see them. Here are the error logs:

---------------------------------------------
[08.22. - 16:39:08] Starting Log: logs/eqemu_error_world_3516.log
[08.22. - 16:39:08] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

So then I also used the cmd line to try to get world.exe to start that way, after reading about the thousandth+ post on here....

Any idea's what's going on?

**hayward6** · #2 08-22-2008, 08:08 PM

Looks like you didn't grant yourself access to the database. Try this

Code:

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

I think that's right... you can look it up if t isn't
root and password can be changed to your username and password for mysql

FlitTastic · #3 08-22-2008, 08:33 PM

Ok, tried that, with and without the quotes on the first on root@localhost. Still does the same thing with the same error messages

**hayward6** · #4 08-22-2008, 08:49 PM

You have your config file using eq as the user name? Change it to root. Or I guess you could grant privileges to the eq user...

Access denied for user 'eq'@'localhost' (using password: YES)

... oh yeah, be careful who you show that password too

FlitTastic · #5 08-22-2008, 09:06 PM

no, my user name isnt eq, its root. i even used the find function to see where every reference to eq was, and it isnt in any of the places that would cause an error, as far as i can tell.

The password is unique and will be changed. password is the least of my worries.

**hayward6** · #6 08-22-2008, 09:09 PM

This is the place I was talking about, in the config file

Code:

<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>******</password>
		<db>peq</db>