469,631 Members | 1,298 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

changed user privileges and now I can't log in - please help

I read several web sites and O'Reilly's book on MySQL about securing the
system tables.

I removed several users and, as advised inthe book and web sites, changed
the user "root" to another name with another password.

I removed the site name as a host but kept the IP address.

Now when I use phpMySdmin to get back in, it let's me past the login popup
BUT it gives me the message:

Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)
The data in the database is not important but the database
structure/definition is. I'd like to find a way to back up or dump that.
Then I can reload MySQL and start over.

Any ideas?

Shoudl I be able to get to it using shell login?

Many, many thanks for any help!
Jul 19 '05 #1
0 1260

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Taber, Mark | last post: by
33 posts views Thread by JamesB | last post: by
4 posts views Thread by Don Calloway | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.