Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Where does TXP store MYSQL password in database?
Accidentally deleted config.php during upgrade, now can’t find MYSQL password anywhere.
Where does TXP store MYSQL password in database?
(I’m upgrading from 4.05 to 4.30)
Thanx for any insights!
Last edited by jayrope (2011-01-31 11:22:57)
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: Where does TXP store MYSQL password in database?
jayrope wrote:
Where does TXP store MYSQL password in database?
In the txp_users table alongside each user row. If you’ve lost the password and don’t know it, the easiest thing to do is to reset it and then create a new config.php:
<?php
$txpcfg['db'] = 'name_of_DB';
$txpcfg['user'] = 'user_name';
$txpcfg['pass'] = 'password';
$txpcfg['host'] = 'localhost';
$txpcfg['table_prefix'] = '';
$txpcfg['txpath'] = '/path/to/textpattern';
$txpcfg['dbcharset'] = 'utf8';
?>The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
Re: Where does TXP store MYSQL password in database?
Bloke, thank you at first.
txp_user table seems to store only the TXP user passwords, but not the database password itself.
I’d have reset the database password already, but can’t find that option neither in Cpanel nor in PHPmyAdmin.
Generally could i set up a fresh install of TXP 4.30 by creating a new database first and then reimporting the old database content from a 4.05 SQL backup without running into glitches?
Thanx again!
Last edited by jayrope (2011-01-31 11:43:38)
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: Where does TXP store MYSQL password in database?
Dunno where my head is this morning. made a new mysql user and assigned to database. works. Thanx Bloke, sorry for the stupid question.
EDIT: Issue solved. Answer: TXP doesn’t store any mysql passwords, besides uses them in the config.pgp file. If one looses this, it is an easy workaround to simply create a new DB user and password in your Cpanel and assign this with full priviledges to the database used before.
Last edited by jayrope (2011-02-01 00:00:35)
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: Where does TXP store MYSQL password in database?
jayrope wrote:
txp_user table seems to store only the TXP user passwords, but not the database password itself.
Ah, sorry I confused things by introducing the link to resetting the TXP password. D’oh!
TXP does not store the MySQL password anywhere other than in config.php. As far as I’m aware, from cpanel you cannot reset a password once it’s created. You can, however, delete the account that is assigned to your TXP database, create a new account and reassign that one to the TXP DB. Then rewrite your config.php.
Hope that helps.
EDIT: Too late! I see you already did that.
Last edited by Bloke (2011-01-31 12:12:02)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline