View Single Post
  #1  
Old 11-30-2004, 09:09 AM
calranthe
Sarnak
 
Join Date: Nov 2004
Posts: 35
Default mysql -u root mysql why does my system need it

Okay, I've been trying to install EQ emulator for days.

I've followed all the Howto's and I am now asking for help.

I have even clean formated and reinstalled
even tried without xp sp2 incase it caused problems.

No matter what I try, I get the 1405 or 2001 error when I run World.exe.

Starts with Got signal 0
Current world versiob 0.6.0-dr2
Database Error: lost connection, attempting to recover ..
error 2006


Now i am wondering if the fact my system gives access denied if I try mysql.exe (grant etc)

it all seems to work but if i test

mysql -u <user id> -p

access denied when i input password.

Why does my system need the mysql -u root mysql

to be able to do the GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

I am just trying to get a handle on this because I have read the Howto's i've spent the last 48 hours trying different ways.


Any suggestions or help would be very happily recieved as would any links to something i missed to make me look dumb.
Reply With Quote