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

[NotGiven]

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!

[Mojo Man]

> 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

[Mojo Man]

> 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

[Mojo Man]

> 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