Quote:
|
If that is all you done is the grant option and source the DB you will have to set a password and username in your DB via the insert command.
|
If I am understanding what you are saying correctly, then that is NOT true. When he installed MySQL and then ran winmysqladmin.exe THAT is when he created the UN and PW for use with his DB. The GRANT command simply allows him the proper access to whatever DB he chooses to use in MySQL, with that particular UN/PW instead of having to use -root (which is the default UN without a PW)... The INSERT command is generally used to flag an account for status in game... And this can be accomplished in more than one way.. You could use the INSERT command or you could open a dos prompt and change to the world.exe directory and type:
Code:
world flag <username> 200
You could also put in the PW you would want flagged as 200 status....
In other words 'INSERT INTO account' is simply a way of forcing the eq db to make an account before you actually log into the game and do it that way .... It has nothing to do with the UN/PW that is used to access MySQL in general... That is why he got it to work (once he found that he was using caps where he shouldnt have been)... Hope this helps clear some things up a little....
