View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ Need someone quickly to backup my MySQL database.
Log in to Ask a Question

Need someone quickly to backup my MySQL database.

general

Need someone quickly to backup my MySQL database. I keep getting permissions errors.

Here's the error (password removed):

root@aquarius:~# mysqldump -u root -p -h localhost pressflow > /var/www/maxhealthlabs/fri2backup.sql2

Enter password:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

root@aquarius:~#

5 Replies

First of all it seems that you do not have the correct root password. You can try Change MySQL Root Password in Ubuntu or something similar if you have a different flavour of Linux.

We did change the password via the Linode dashboard. I am still getting this error.

@Maxhealthlabs:

We did change the password via the Linode dashboard. I am still getting this error.

You changed the MySQL root password from the Linode dashboard? I am not sure that is possible.

http://www.cyberciti.biz/tips/recover-m … sword.html">http://www.cyberciti.biz/tips/recover-mysql-root-password.html

that should do the trick.

system root password and mysql root password are not the same animal, they may be exactly the same character wise they may not be exactly the same character wise. Important thing is they are not the same entity.

That's just what I needed!

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct