PDA

View Full Version : Access denied for user...


DeletedUser
06-04-2002, 01:35 AM
This is for people who keep getting access denied errors, first, take your db.ini...


[Database]
host=133.133.13.13
user=image
password=bleh
database=eq
timestamp=4-9-2002 1640

I assume that your MySQL db is on the same computer your hosting, if its not, the ip to grant @ will be the one of the computer connecting to the mysql server.

Taking this make this to type into MySQL:

What this does below is give image at the ip 133.133.13.13 all access to eq when authorized with password bleh.

GRANT ALL PRIVILEGES ON eq.* TO image@133.133.13.13 IDENTIFIED BY 'bleh' WITH GRANT OPTION;

This should help out, I noticed some on HQ talking about having this problem with EQEMu :P

Shawn319
06-04-2002, 08:20 AM
been there, posted that =P http://www.eqemu.net/forums/showthread.php?s=&threadid=1169

DeletedUser
06-04-2002, 08:33 AM
not labeled as well as mine :)

Keletones
06-13-2002, 05:41 AM
I keep getting access denied. Do I go into the bin in mysql and open mysql? I typed something like
GRANT ALL PRIVILEGES ON eq.* TO username@localhost IDENTIFIED BY password

Is that correct I am new to all this. Would appreciate some advice.
Just want to play on my on PC.

Lurker_005
06-13-2002, 11:03 AM
Originally posted by image
This is for people who keep getting access denied errors, first, take your db.ini...


[Database]
host=133.133.13.13
user=image
password=bleh
database=eq
timestamp=4-9-2002 1640

I assume that your MySQL db is on the same computer your hosting, if its not, the ip to grant @ will be the one of the computer connecting to the mysql server.

Taking this make this to type into MySQL:

What this does below is give image at the ip 133.133.13.13 all access to eq when authorized with password bleh.

GRANT ALL PRIVILEGES ON eq.* TO image@133.133.13.13 IDENTIFIED BY 'bleh' WITH GRANT OPTION;

This should help out, I noticed some on HQ talking about having this problem with EQEMu :P


The bold text you replace with your own info. so for me it might be lurker, 95.34.13.19, eq33, and hmph You can use a % as a wildcard so I could use 95.34.13.% to allow the last part of the number to be anything. Same goes for the username password and database fields.

And yes this is a sql command that you type into mysql.