Find the answer to your Linux question:
Results 1 to 2 of 2
Hi, I'm trying to export my MySQL databases but this keeps happening: [root@sftrhost sftr]# mysqldump -u mysql -p formyeyesonly sftr > FILE.sql Enter password: mysqldump: Got error: 1045: Access denied ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2005
    Posts
    54

    Exporting MySQL


    Hi,
    I'm trying to export my MySQL databases but this keeps happening:
    [root@sftrhost sftr]# mysqldump -u mysql -p formyeyesonly sftr > FILE.sql
    Enter password:
    mysqldump: Got error: 1045: Access denied for user: 'mysql@localhost' (Using password: YES) when trying to connect
    What am I doing wrong?

  2. #2
    scm
    scm is offline
    Linux Engineer
    Join Date
    Feb 2005
    Posts
    1,044

    Re: Exporting MySQL

    Quote Originally Posted by sixfoottallrabbit
    Hi,
    I'm trying to export my MySQL databases but this keeps happening:
    [root@sftrhost sftr]# mysqldump -u mysql -p formyeyesonly sftr > FILE.sql
    Enter password:
    mysqldump: Got error: 1045: Access denied for user: 'mysql@localhost' (Using password: YES) when trying to connect
    What am I doing wrong?
    You're leaving a space between the -p and the password. It has to be typed as a single argument "mysqldump -u mysql -pformyeyesonly sftr".

Posting Permissions

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