mysql problem with root password

whoooops

[ukgimp]

Like a proper tool I have managed to install a user and password in the mysql table and now I am locked out of all but one table. This is a local development server on a windows box running apache from firepages.

What the hell can I do now? I have tried using a dos command but that did not work and short of reinstalling the whole thing I appear to have racked it big time.

Puzzled…..

Cheers

[ppg]

>Like a proper tool

hehe, sounds like me when I'm working with MySQL :)

I'm not sure I get what you've done - have you just added a new user? then you should still be able to connect as root? Or did you change the root prvileges?

Have you tried connecting as root from the command line?

or if you can't connect at all, try this:
stop mysql then start it again with the option --skip-grant-tables - this will bypass the privilege system so anyone can connect with full access, maybe then you can sort out what went wrong with the root user by looking in the user table.

[edited by: ppg at 10:44 am (utc) on Oct. 7, 2003]

[ukgimp]

I was trying to get the security sorted on my local machine to learn how to do it on my host (which is working bazaarly).

I am not altogether sure. I am just alocked out of all but one database. When I try to connect to the mysql table I get a 1044 error.

phpmyadmin is out the window also as that is locked into one database only.

[ppg]

1044 is an access denied error I think, somethings up with the privileges from the sound of things - I edited my post above, try that. At least you'll be able to get in.

[ukgimp]

dont really know how. Tried a million things. Got it working.

FYI

[mysql.us.themoes.org...]

Also mess with the config.inc.php file with phpmyadmin.