MySQL problem...

[Fargonstuff]

Ok, now here is my problem... I downloaded an made a username and a password for my SQL a long time ago, when my EQEMU server was active... Then, i had family issues so i had to take the server down...

Now im trying to put it back up... i deleted MySQL and all of the nessessary things that i needed for the server to run.

Now, in trying to get the server back up, i downloaded mySQL and Dwanes worlddata and all of that.

Were it says open winmysqladmin.exe, instead of asking for a username and password... it just opens and closes as if i ALREADY have a username and password... and it used to old username and password when its running... BUT I DELETED MY SQL LIKE 5 MONTHS AGO. how is it recodnizeing my username and password?

anyway.. your probubly going to say just use the useername and pass that it gives me, but no, when i open world.exe and boot5zones.bat it says that the myaql name and pass is invalid... were do i get a copy of myaql that does not already have my username and pass on it!

This is driveing me crazy! HELP/.

Thanks.

In the Mysql prog that opens up there should be a tab that says My.ini at the bottom of that tap you should see text in that text there should be

Username=(yourusername)
Password=(Password)

To fix that all you have to do is change the username and password ect

But next time use search lol

[Fargonstuff]

*bonks* thanks man.

[Fargonstuff]

sorry for the double post but when i do the GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%'; after seting up the DB i egt a 1045 access denied for user error...

whats wrong?

I get the same thing i am only a Newbie to the fourms Do some digging and i am sure you will find the answer
If you don't repost your prob

[wize_one]

the % wildcard does not work you have to suply a name

[Fargonstuff]

supply what kinda name? uhm... like my mysql and and pass? what?

[wize_one]

from the server guide

grant all privileges on *.* to test@localhost identified by 'test' with grant option;

change the test@localhost to your dbname@localhost and change the 'test' to 'yourpassword' you need the tick's there

[Fargonstuff]

thank you muchies!