Where can I find the MySQL database password using phpMyAdmin? [SOLVED]

[chunter]

I [stupidly] changed the password for the mySQL database through my hosting control panel, and can no longer access my CMS admin panel. Is it possible to find where the dB username password using phpMyAdmin and update it to the new password? Or find the old password and I'll update the hosting control panel to match the old password.

[owr_bgld]

http://forum.cmsmadesimple.org/index.php?action=search

You can find several threads with the solutions

[chunter]

I'm searching for "mysql password" "lost database password" etc. and haven't seen anything that instructs you on changing / or finding the database password using phpMyAdmin. I despise people who ask stupid questions without searching previous threads first, but I've looked through about a dozen threads and I'm not seeing anything. If you know a specific thread that resolves this question and could link to it that would be incredibly awesome and I would really, really appreciate and be extremely grateful.

[chunter]

Just to clarify, I'm not looking for the CMS users passwords, but rather the main MySQL database password that was entered when the CMS was first installed, as configured by the Database management in my hosting account on GoDaddy.

[uniqu3]

Change the config.php?

[chunter]

Thanks for the reply, much appreciated.

So if I was to change this section:

#This is your database connection information.  Name of the server,
#username, password and a database with proper permissions should
#all be setup before CMS Made Simple is installed.
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'xxxxxx';
$config['db_username'] = 'xxxxxx';
$config['db_password'] = 'xxxxxx';
$config['db_name'] = 'ctmcmsms';
#Change this param only if you know what you are doing
$config["db_port"] = '';


to reflect the new password as set in my dB management console, that should be the only place where it would need to be updated?

[NaN]

Yepp.

[chunter]

Thanks again for the replies, I've updated the config.php and the dB password just now, I'm positive they both ahve the same username and password - still getting the same connection error:

__________________________________________________

Database Connection Failed
Error: Access denied for user 'ctmcmsms'@'97.74.144.135' (using password: YES) (1045)
Function Performed: CONNECT
Host/DB: ctmcmsms.db.5110772.hostedresource.com/ctmcmsms
Database Type: mysql

Fatal error: Attempt to connect to database ctmcmsms on ctmcmsms@ctmcmsms.db.5110772.hostedresource.com failed in /home/content/c/t/m/ctmedia/html/lib/adodb.functions.php on line 69

___________________________________________________

I'm going to give the dB console time to update the password, if that doesn't work I'll have to get my developer partner to fix it.

Again thanks for the replies, much appreciated.

[chunter]

dB password updated, everything is back and running. Thanks again,

Chris Hunter
Creative Services

http://www.CollectiveThoughtMedia.com | http://www.NewportRIphotos.com
401.297.7383 | Middletown, RI | chunter@collectivethoughtmedia.com