TurnKey Linux Virtual Appliance Library

mysql error '1045: Access denied - Redmine Backup?

david_3's picture

Sorry if this is just plain obvious but I'm being plagued with the mysql error '1045: Access denied for user xxx' when i try to do a mysqldump. None of my normal passwords work with 'root' as the user. Is there a manual way of backing up or is there a config file somewhere I can look at to get a hint of the password?

I installed phpmyadmin to try to work around the problem but it requires the same missing password.

Using mysqladmin -u root password xxxxx just gives me the same message (without the 1045 identifier)

Also is the database called redmine or railsapp_production by default?



DLD's picture

Answered both questions

found a solution here - http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix to reset the root password - worked a charm.

the DB is called railsapp_production.


Hope that helps someone.

Jeremy Davis's picture

Glad you got it sorted

Hope you don't mind, I added to your original topic title a little to better relect the post.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)