CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Where does Civi store the password for its access to mysql
Pages: [1]

Author Topic: Where does Civi store the password for its access to mysql  (Read 402 times)

civieric

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
  • CiviCRM version: 4.3.5
  • CMS version: WordPress
  • MySQL version: 5.5.32
  • PHP version: 5.4.17
Where does Civi store the password for its access to mysql
January 19, 2015, 07:34:57 pm
When I try to access Civi in a WP installation I'm getting a DB connect fail because of "access denied for user." I'm presuming that somehow the password for that user in mysql got changed or the password in the Civi install got changed. (It used to work.)  I can go into mysql and set a new password there for the user. I'm not having luck finding where I would change the password in the existing Civi files.

Thanks.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Where does Civi store the password for its access to mysql
January 19, 2015, 11:16:09 pm
That will be stored in the civicrm.settings.php file, but I am not sure where that would be located in Wordpress installs? Does that help?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Where does Civi store the password for its access to mysql
January 19, 2015, 11:29:41 pm
Took me a while to spot it on the WordPress CiviCRM wiki page (mentioned under Locate and Backup the CiviCRM settings file), it should be at wp-content/plugins/civicrm/civicrm.settings.php.

In that file you should see some define statements with MySQL DB URLs in.
@xurizaemon ● www.fuzion.co.nz

civieric

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
  • CiviCRM version: 4.3.5
  • CMS version: WordPress
  • MySQL version: 5.5.32
  • PHP version: 5.4.17
Re: Where does Civi store the password for its access to mysql
January 20, 2015, 05:38:59 am
Found it. I was there once and looked right over it. My bad. Reset the password for the CIVICRM_DSN user and I'm in.

Thanks.





Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Where does Civi store the password for its access to mysql

This forum was archived on 2017-11-26.