469,106 Members | 2,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 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
3 2188
> Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)


Try using the command line "mysql" program and pass in the username you renamed
"root" too. Such as "mysql -p -u <username>" where <username> would be the
username you renamed root too.. This should let you in the database server and
access the db's. The other choice is to change the username in PHPAdmin from
"root" to what you renamed it too..

Mark
Jul 19 '05 #2
> Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)


Try using the command line "mysql" program and pass in the username you renamed
"root" too. Such as "mysql -p -u <username>" where <username> would be the
username you renamed root too.. This should let you in the database server and
access the db's. The other choice is to change the username in PHPAdmin from
"root" to what you renamed it too..

Mark
Jul 19 '05 #3
> Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)


Try using the command line "mysql" program and pass in the username you renamed
"root" too. Such as "mysql -p -u <username>" where <username> would be the
username you renamed root too.. This should let you in the database server and
access the db's. The other choice is to change the username in PHPAdmin from
"root" to what you renamed it too..

Mark
Jul 19 '05 #4

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
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.