EQEmulator Forums - Access Denid but y!

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Access Denid but y! (https://www.eqemulator.org/forums/showthread.php?t=6333)

Access Denid but y!

mysql> GRANT ALL PRIVILEGES ON eq.* TO test@localhost IDENTIFIED BY 'test' WITH GRANT OPTION;

ERROR 1044: Access denied for user: '@127.0.0.1' to database 'eq'

l: test
p: test
db: eq
localhost/127.0.0.1

Never usually have problems setting up emulator.. but the fix keeps denying me. :roll:

help help help me!! :x

Might wanna try this:

Code:

GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

This will let any user on the local machine access any SQL database. Worked for me when the line you're using didn't.

Try this before you enter the GRANT...

c:\mysql\bin\mysql.exe --user=root eq

Mysql has the default server admin as root no matter what OS you're running. This is deep in the MySQL web docs.

Quote:

user: '@127.0.0.1' to database 'eq'

yea i noticed.. user is messed. I tried for about 10 minutes and lost interest.. going to try to fix it right now.

Quote:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Darkyth>cd c:\mysql\bin

C:\mysql\bin>mysql.exe --user=root eq
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 127 to server version: 4.0.12-nt

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

mysql> GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT
OPTION;
Query OK, 0 rows affected (0.05 sec)

Run minilogin.
Run world.exe

Quote:

Failed to connect to database: Error: #1045: Access denied for user: 'test@127.0
.0.1' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
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

Are you using MySQL 4.0 by chance? I was getting the same thing, couldn't figure it out. I got frustrated and just went back to 3.23.

try using

test@127.0.0.1 as the user field, and test@localhost

also , manually log into mysql with the test username and password, you might not be using the right password...

not working =\

I reinstalled mysql earlier to make sure it was test/test (didn't know you could login manually).

I was using easyphp (so I could use php on localhost, it had mysql in it so it interfered with my older mysql) - I uninstalled it but it might still be affecting it somehow. But either way it was still test/test.

I had Exactly the same problem with mysql 4, went back to 3.23 and all problems dissapeared! :)