Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Fri Mar 09, 2012 11:22 am 
Offline
Newbie

Joined: Fri Mar 09, 2012 11:19 am
Posts: 3
Website: http://maxhealthlabs.com
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:~#


Top
   
 Post subject:
PostPosted: Fri Mar 09, 2012 11:38 am 
Offline
Senior Member

Joined: Fri Jan 20, 2012 11:19 am
Posts: 100
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.

_________________
If all else fails, reboot...
PHP Tutorials and MySQL Tutorials


Top
   
 Post subject: MySQL backup
PostPosted: Fri Mar 09, 2012 11:40 am 
Offline
Newbie

Joined: Fri Mar 09, 2012 11:19 am
Posts: 3
Website: http://maxhealthlabs.com
We did change the password via the Linode dashboard. I am still getting this error.


Top
   
 Post subject: Re: MySQL backup
PostPosted: Fri Mar 09, 2012 11:59 am 
Offline
Senior Member

Joined: Fri Jan 20, 2012 11:19 am
Posts: 100
Maxhealthlabs wrote:
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.

_________________
If all else fails, reboot...

PHP Tutorials and MySQL Tutorials


Top
   
 Post subject:
PostPosted: Fri Mar 09, 2012 12:06 pm 
Offline
Senior Newbie
User avatar

Joined: Thu Oct 23, 2008 9:25 pm
Posts: 16
Website: http://bofh.hosscomm.com
http://www.cyberciti.biz/tips/recover-m ... sword.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.


Top
   
 Post subject: Perfect!
PostPosted: Fri Mar 09, 2012 12:44 pm 
Offline
Newbie

Joined: Fri Mar 09, 2012 11:19 am
Posts: 3
Website: http://maxhealthlabs.com
That's just what I needed!


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: nqservices and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group