GRANT PRIVILEGES problem

[Zace]

I am using my EQ database.
I have typed the command
GRANT ALL PRIVILEGES ON *.* TO xxxx@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

However I ALWAYS get 0 rows affected.

The problem is how do i work out which xxxx and password i use.
Am i supposed to use the oceral MySQL one ? If so (I set MySQL up last year!!) am using the name on the winmysqladmin window.
However that failed, as did root, and all the names i added as eq users. I also checked c:\winnt\my.ini and used the details stored in there too!!!

This is causing me good old 1017 error and i dont really want to have to wipe out all my other databases just to get this one running.

[joshyoowuh]

About the 0 rows effected thing, I don't think thats an error.

[Zace]

Its not an error , but in all the readme's it is telling me it should say 1 row affected!!!

Anyway - still getting 1017, and thought this was the problem - doh.

[mrea]

No tutorial tells you that you should have 1 row affected here. As for the 1017, unless you happen to find something searching, you are probably screwed (this has happened to me before)

[Zace]

Nope - nothing happens in my world.exe

[Cans]

I don't see how the grant all privileges etc thing will cause a 1017 error on your server.

Technically, to run your server, you don't have to open up a MySQL prompt and type that in - you just run world.exe and boot5zones.bat.

What will cause a 1017 error is either you not having your ports opened up, you having wrong IP Addresses in wrong places in certain files (Loginserver.ini and Boot5zones.bat mainly), or you not having the right files for the particular server you are trying to run.

The username/password it is referring to is the original one you put in for mysql when that box popped up.

[Zace]

Hmm ok thanks. Well I upgraded to DR2 and now i get an error on zone loading with the NPC Factions list loading,e xcept there is no error message, so i cant tell what is going wrong.