HostwareSupport-Linux Hosting technical support for cPanel, Plesk, Directadmin servers

Linux Hosting technical support for cPanel, Plesk, Directadmin and No control panel servers offers and listing
http://hostwaresupport.com/

Sep 25, 2010

Mysql dump error Re: ERROR 1044 (42000): Access denied for user

Mysql dump error Re: ERROR 1044 (42000): Access denied for user

When i tried to create the backup .sql file of database through shell with mysqldump command i got the following error:

Mysqldump error:
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name'

This error mean that the problem with lock table into the database of that user so simply fetch the following command to resolve.
the issue..
# mysqldump --skip-lock-tables -u mysqluser -p password mysqldbname > mysqlfile.sql

After issue this command it will ask you the password, so provide there mysql Database password there after it will take minimum 30 min to create databse.sql file ( it's depend on database size..)

Note: make sure that at which directory you fired this command .sql file location should be the same

No comments:

Post a Comment