Hello,
I'm having 2 problems using MySQL on my personal computer.

The first problem is, sometimes the command line client accepts my password, othertimes it does not. I am not sure what I am doing to cause this but I would like to avoid being lockout of my own databases.

The second problem concerns using mysqldump. When I am able to access my databases using my password, and I try to use mysqldump like this:

I get the following error message:

I have no idea what is going on. Any assistance will be appreciated. Thanks in advance.

what permissions have been GRANTed to MyUsername.
you can review the permissions easily enough in MySQLAdministrator

Thank you for your reply healdem. I finally figured out the cause of my two problems:

1. Regarding my passwords not being accepted sometimes, the reason was the MySQL service was either uninstalled or the service was not running. So from now on I'll make sure the MySQL service is installed and running.

2. Regarding the mysqldump problem, I did not use the correct user name, which is root. So the correct commands in the Windows Command Prompt are as follows:

If after entering your password, nothing happens, then it worked.

I hope this helps anyone else who had the same problem!