Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    13

    Question Unanswered: Unable to generate snapshot using mysqldump - Got error: 1045

    I am trying to create a snapshot (backup) of my MySQL database (INNODB) using the mysqldump tool as follows:
    mysqldump -p bank > bank.sql;
    Where bank is the name of the database I wish to backup.

    When I run the command I get prompted for a password "pass" which then generates the following error:
    mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: YES) when trying to connect

    To logon to the database I typically use the MySQL Command Line Client (Windows Start-> Program -> MySql -> MYSQL Server 5.1 -> MySQL Command Line). When I select this it prompts me for the password ("pass") which I enter and then can load my database and perform whatever operations are needed.

    So my question is - why does the same password not working for mysqldump? I don't recall ever setting a different one nor do I recall doing anything with a username...
    This is all done locally (on my pc) under an account with admin rights...

    Anyone have an idea?
    Any help would be greatly appreciated...

    Thanks,

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what permissions does the user account you are using have?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2006
    Posts
    13
    Administrator...
    My own personal user account on my PC

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    no such thing as "adminstrator" permissions, accounts maybe, permissions no
    unless you are using the root account I'd guess its a permissions problem, either you don't have permission to lock the DB or something similar
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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