PDA

View Full Version : EQ Emu Admin help


yandiyen
06-07-2002, 02:46 PM
I keep getting error's when i want to edit by DB....
i have my SQL BD set up
the info in my prefs in Admin is:

Database: eq01
Host: 127.0.0.1
Username: MYSQL one
Password: MYSQL one

now what do i do?

stormgod
06-07-2002, 02:54 PM
try changing your host by localhost
"it may help"

Baron Sprite
06-08-2002, 11:17 AM
If it still doesn't work, make sure you granted yourself rights in sql :D


GRANT ALL ON *.* TO '%'@localhost IDENTIFIED BY '%';

Drizzt40
06-25-2002, 07:52 AM
I had the same error and tried it in Mysql and then said access denied.So I typed in the line in Mysql.exe that was supposed to grant all acess...should it say this if done right:

Query OK, 0 rows affected <0.06 Sec>

Windcatcher
06-25-2002, 01:21 PM
When I do it I use an actual username and pw, e.g:

GRANT ALL ON *.* TO monty@localhost IDENTIFIED BY some_pass;

That's what they say to do on the MySQL website. Try it and see if it helps (make sure to set the username and pw in the admin tool to be the same as what you use in the GRANT line)

Wind