Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-04-2003, 09:37 PM
TwoSock
Fire Beetle
 
Join Date: Feb 2003
Posts: 20
Default MySQL Access Denied.

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

Code:
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
Code:
[Database]

host=192.168.1.6

user=eq

password=monks

database=eq2

compression=off
This is what i did in MySql.
Code:
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
Code:
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?
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:55 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3