View Full Version : Access Denid but y!
DeletedUser
03-31-2003, 06:16 PM
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:
DeletedUser
03-31-2003, 07:53 PM
help help help me!! :x
EnFuego98
03-31-2003, 09:06 PM
Might wanna try this:
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.
brit4shains
04-01-2003, 03:03 AM
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.
Bigpull
04-01-2003, 03:38 AM
user: '@127.0.0.1' to database 'eq'
DeletedUser
04-01-2003, 10:27 AM
yea i noticed.. user is messed. I tried for about 10 minutes and lost interest.. going to try to fix it right now.
DeletedUser
04-01-2003, 10:36 AM
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
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
EnFuego98
04-01-2003, 08:08 PM
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.
Trumpcard
04-01-2003, 09:57 PM
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...
DeletedUser
04-02-2003, 06:47 AM
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.
monitor
04-08-2003, 02:08 PM
I had Exactly the same problem with mysql 4, went back to 3.23 and all problems dissapeared! :)
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.