Log in

View Full Version : EQadmin tool Access denied


zupancic
07-04-2003, 08:39 PM
I get this error when trying to use eqadmin tool 4.7

Exception:Access denied for user:test@main (using password:YES)
Then admin tool wasnt able to connect to
Database "eq" at host 192.168.1.100
Please go to the preferences dialog and set the username, password, database, and host values.

Well i have the username and pass set to test and test. this is the way it is for mysql. I have no idea why it is using password YES?
also my Database is named eq, WTF is up? :cry:

Bigpull
07-04-2003, 11:24 PM
run mysql from the command line, mysql database_name -h 192.168.1.100 -u username -p
You should get a 1045, from using the 192 ip when you used localhost in the grant command

09-07-2003, 06:07 AM
ERROR: When I click on eqadmin.exe I get an error where it says: "Access denied for user: 'mysqlname@127.0.0.1' (Using password: YES) The admin tool wasn't able to connect to database "eq" at host 127.0.0.1. Please go to the Preferences dialog and set the username, password, database, and host values.

SOLUTION: First open the admin folder and edit FQADMIN.INI to the right prompts and commands. Then, click START, RUN, type in mysql -uroot, then type in, GRANT ALL PRIVILEGES ON eq.* TO mysqlname@localhost IDENTIFIED BY 'mysqlpassword' WITH GRANT OPTION;