469,326 Members | 1,601 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 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:

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 1197

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

33 posts views Thread by JamesB | last post: by
4 posts views Thread by Don Calloway | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.