Clearing MySQL...

[smuggler]

For some reason or another MySQL is fuxxored on my machine. It won't let me create new databases or edit existing ones. I can't give myself the privilages to do so, because MySQL isn't recognizing the syntax to do so (??).

At any rate, a completely fresh install is just what the doctor ordered. However, I gave it a shot and no dice...

I get the feeling there are some configuration files or dlls hidden in my Windows folder. Anyone out there have any pointers? I'm pretty much fuxxored until i can get SQL working again. =/

I run on WinXp and have had both SQL 3.8 and 4.0 installed on this machine.

Thanks in advance, there were no matches when I searched previous forum posts.

[Derision]

There is a file in c:\windows called my.ini which holds some config info for mysql (e..g passwords). You could try deleting that, then re-installing.

[smuggler]

Sadly, that was something I had already attempted as part of my original course of action.

Thanks for your help though...

I don't understand what I could have done to make it so angry at me... It was working just fine for me earlier.

~~Edit~~

I was taking a look at the My.ini file from a fresh installation and there was an option in there that wasn't set...


language=C:/MySQL/share/ your language here


I searched to the folder and low and behold, there were folders of practically every language. I set it to english, and now It's working again.

language=C:/MySQL/share/english/

I guess the language I chose changed the syntax of the mysql.exe file or something... Make any sense to you