Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    4

    Unanswered: Password? mysqldump?

    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:

    mysqldump -u myUserName -p myDatabaseName > "C:\myDatabaseName.sql"
    I get the following error message:

    mysqldump: Got error: 1045:Access denied for user 'myUserName'@localhost' (using password: YES) WHEN TRYING TO CONNECT
    I have no idea what is going on. Any assistance will be appreciated. Thanks in advance.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what permissions have been GRANTed to MyUsername.
    you can review the permissions easily enough in MySQLAdministrator
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2009
    Posts
    4
    Quote Originally Posted by healdem View Post
    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:

    mysqldump -u root -p databaseName > "C:\MySQLBackupFolder\databaseName.sql"
    If after entering your password, nothing happens, then it worked.

    I hope this helps anyone else who had the same problem!
    Last edited by 01010011; 11-29-09 at 14:56. Reason: Typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •