Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2010-05-02 14:57:49
- artbsnss
- New Member
- Registered: 2010-05-01
- Posts: 2
newbie: database setup screen problems
This refers to the detailed instructions at:
<http://textpattern.net/wiki/index.php?title=Detailed_Installation_Instructions#Step_2.29__Database_Setup_Screen>
I’ve tried about every combination of prefixes and login combinations in order to make the initial connection between Textpattern and MySQL. The problems might be the ambiguity of “yourhostID_” in the setup instructions, though I’m not positive. It could also be the term “localhost”. (SEE BELOW). My provider has not been of much help.
I’ve tried IP addresses, my username for the service, et.al. to no avail.
Can anyone give me some clues as to what I should use?
Thank you.
MySQL login: yourhostID_databaseUserID
MySQL password: databasePassword
MySQL server: localhost (If “localhost” does not work, check with your host provider about what to use.)
MySQL database: yourhostID_datbaseName
Table prefix: prefix_ (e.g., txp_, txp2_, cats_, whatever_)
Offline
#2 2010-05-02 16:27:07
- rsilletti
- Moderator
- From: Spokane WA
- Registered: 2004-04-28
- Posts: 707
Re: newbie: database setup screen problems
If you are prefixing yourhostID as text, that would be incorrect and it would continuously fail.
MySQL login: yourhostID_databaseUserID entry for database user name “parkling”
MySQL password: databasePassword entry of your choosing
MySQL server: localhost (If “localhost” does not work, check with your host provider about what to use.) almost always “localhost”
MySQL database: yourhostID_datbaseName entry for database name “yellowstonewell”
Table prefix: prefix_ (e.g., txp_, txp2_, cats_, whatever_) allows you to prefix table names if you have more than one TXP install using the same database. No entry works fine for a single install.
This would be a sample config.php from a testing site (xxxx is blanked for security reasons) I’m using, these are values that are already being used by TXP to access it’s assigned DB, the xxxx for password will be one you assign, TXP will provide you with txpath at the appropriate step.
$txpcfg[‘db’] = ‘yellowstonewell’;
$txpcfg[‘user’] = ‘parkling’;
$txpcfg[‘pass’] = ‘xxxx’;
$txpcfg[‘host’] = ‘localhost’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] = ‘/-xxxx-’;
$txpcfg[‘dbcharset’] = ‘utf8’;
Last edited by rsilletti (2010-05-02 16:30:19)
Offline
Re: newbie: database setup screen problems
Going one step further back if it’s not clear: you first need to create an empty database via your provider’s admin area or phpmyadmin database tool. Check your provider’s FAQ, support-documentation or sign-up mail for further details on how to do that.
For example, prior to installing txp, I have to set up a new database through my provider’s admin area and the database name is automatically generated. I also received a database user/pass combination when I signed up with my provider. I use these three items for $txpcfg['db'], $txpcfg['user'], and $txpcfg['pass']. localhost only ever needs changing if your provider especially says so. The rest I leave as is.
TXP Builders – finely-crafted code, design and txp
Offline
Re: newbie: database setup screen problems
My host provider shows a particular IP address for each user to use, instead of localhost, on the database creaton page. This is within Cpanel -> MySQL Database.
For textpattern I had to do all of the mysql creation by hand.
When I go to mysql it automatically adds my domain name to it.
domainname_nameofdatabase
below there is an area called ‘Add new user’.
So I create a username, I’ll call it joestamps
create a password
click on create user.
Below that is ‘add user to database’.
So I add joestamps to the above database.
In the config.php file, I add the above info. Upload the php file, and then I connect to the database.
For the cwahi.net free host I use for my other sites, just click on the ‘Databases’ tab after login to the user area, and it creates all the above for you automatically. Just fill in the config.php and upload it.
All done.
Last edited by JimJoe (2010-05-02 20:47:10)
Offline
#5 2010-05-03 05:53:28
- artbsnss
- New Member
- Registered: 2010-05-01
- Posts: 2
Re: newbie: database setup screen problems
I’m up and running. Thank you all for your help.
Offline