MySQL Access Denied.

[TwoSock]

I keep getting the access Denied when starting world.exe.


Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
@unimatrix-102' (Using password: YES) #1045: Access denied for user: 'eq
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4
Loading Variables, zone names & items...
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
EMuShareMem.dll loaded.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #2006: MySQL
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data. But ignoring
...done.
LoginServer.ini read.
Loading guild ranks...Database Error: Lost connection, attempting to recover....

DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
done.
Loading EQ time of day...done.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Deleted -1 stale player corpses from database.
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Deleted -1 stale player backups from database.
You may already be a winner... of the darwin award.
:9000istening on: 82.42.42.10
:9000 server listening on: 82.42.42.10
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1


This is what i have in db.ini

[Database]

host=192.168.1.6

user=eq

password=monks

database=eq2

compression=off


This is what i did in MySql.

E:\>c:

C:\>cd eqemu

C:\EqEmu>cd..

C:\>cd mysql

C:\mysql>cd bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq2;
Database changed
mysql> grant all privileges on *.* to eq@localhost identified by 'monks' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye


I also tried
grant all privileges on *.* to eq@192.168.1.1 identified by 'monks' with grant option;

grant all privileges on *.* to eq@"%" identified by 'monks' with grant option;

And no matter what i try i seem to be getting the same error =/

Had it working just the other day before i formatted.

Am i doing something wrong?
And yes i used the search feature before i posted. They all give the same info which is what i tried here =(

Now if i change the ip in db.ini to localhost i get this instead

Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
Failed to connect to database: Error: #2005: Unknown MySQL Server Host 'localhos
' (11001)
Got signal 0


Any ideas?

[Trumpcard]

My guess is you have whitespace in your ini files.

Make sure to delete them..

[TwoSock]

Forgot to mention that.. I already checked and have no spaces in the file... except the line space between the sections.

[adamtech]

Hey Did you get it fixed? Im having the same problem. Please someone post a solution.

[Kgaul]

try retyping on a clean txt file the db.ini also change your host to 'localhost'. that should fix the prob...


Kgaul