EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   MySQL problem... (https://www.eqemulator.org/forums/showthread.php?t=11585)

Fargonstuff 01-26-2004 12:40 PM

MySQL problem...
 
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.

01-26-2004 12:59 PM

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
Code:

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 01-26-2004 01:33 PM

*bonks* thanks man.

Fargonstuff 01-26-2004 01:45 PM

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?

01-26-2004 02:25 PM

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 :D
If you don't repost your prob

wize_one 01-26-2004 03:52 PM

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

Fargonstuff 01-27-2004 08:24 AM

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

wize_one 01-27-2004 08:27 AM

from the server guide
Quote:

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 01-27-2004 09:00 AM

thank you muchies!


All times are GMT -4. The time now is 08:30 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.