Admin Tool usage help please.

[wurmslayer2k]

Need help for using admin tool because i cannot flag myself server-op-

Access denied for user Myname@localhost

The admin tool wasn't able to connect to database "eq" at host 127.0.0.1


Any suggestions?

Thanks in advance

[Trig]

Your privileges have been messed up.

Look in and follow the sticky thread regarding #error 2006 and that should fix you problem.

[wurmslayer2k]

When i do that i get syntax error near sql.

[Trig]

**Thanks Trumpcard**

type mysql from the c:\mysql\bin directory

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

or, the less secure but more useful technique that will allow you to log on with that user name from any machine.

GRANT ALL PRIVILEGES ON eq.* TO someid@'someip'
IDENTIFIED BY 'somepass' WITH GRANT OPTION;


Stick with those rather than the % i'll happily admit i know squat about sql but both of those ways have worked for me. It sounds like you're typing something in wrong to get the syntax error response. BTW DO NOT type in the mysql> bit. just GRANT ALL .......... etc etc only go with one or the other of those GRANTS as well.... just in case.

Trig

[wurmslayer2k]

that was the thing that gave me syntax error.

But I fixed it any ways once again i figured it out by a stupid minor error.

Now, where to DL ariak's DB?? /grin

thanks again