Hi.
The error message pretty much says it all. The user you are using to connect is being denied access.
Based on the username it is showing, I am guessing you are using the Windows Command Prompt and that you left out the -u and -p parameters in the
mysqldump command.
The command should look something like:
-
mysqldump -u userName -p --databases test > dumpfile.sql
-
Where "userName" is the name of the user you use to connect.
When you do this, you will be prompted for you password.
If you would rather *inline* your password into the command (which I recommend against unless you have a good reason for it), then you simply enter it after the -p parameter.
Like:
-
mysqldump -u userName -pmyPass --databases test > dumpfile.sql
-
Where "myPass" is the password. (Note the lack of a space between -p and the password. If you add a space this will not work!)
