Textpattern CMS

#1 2011-01-04 08:06:35

dreamer

Member

Registered: 2007-06-08

Posts: 242

Installing a Database via Phpmyadmin

So I’m used to installing TXP via cpanel. But this hosting company I’m working with only allows via phpmyadmin which seems weird unto itself.

If I’m reading this tutorial properly , it seems I have to manually create each table for a DB??? If so, that seems like alot of work. Is there some quicker way for to create a DB so I can install TXP?

#2 2011-01-04 08:49:28

jelle

Member

Registered: 2006-06-07

Posts: 165

Re: Installing a Database via Phpmyadmin

dreamer wrote:

If I’m reading this tutorial properly , it seems I have to manually create each table for a DB??? If so, that seems like alot of work. Is there some quicker way for to create a DB so I can install TXP?

You only have to create the database and provide textpattern setup with the appropriate details (databasename, username, password) during setup. Textpattern setup will create all the required tables.

#3 2011-01-04 22:07:24

dreamer

Member

Registered: 2007-06-08

Posts: 242

Re: Installing a Database via Phpmyadmin

Hmm…I can’t find anywhere I would create a username?

#4 2011-01-04 23:32:00

jakob

Admin

From: Germany

Registered: 2005-01-20

Posts: 5,000

Website GitHub

Re: Installing a Database via Phpmyadmin

In the screenshot below (from the detailed instructions in the textbook) you can see the details you will need to install textpattern. Usually you create your database from your hosts admin panel and in many cases that already provides you with all the necessary information.

If your host allows you to create new databases from within phpmyadmin, you can create a new database there and you will see the server and database name listed at the top of the window. The login/pass details will usually be what you needed to access phpmyadmin. You do not need to create any tables at all.

---

TXP Builders – finely-crafted code, design and txp

#5 2011-01-05 05:28:10

~cXc~

Plugin Author

Registered: 2010-12-27

Posts: 39

Re: Installing a Database via Phpmyadmin

Get the link to phpMyAdmin from your host if you don’t have it already and then use the username and password your host gave you for phpMyAdmin, after logging in, create a new database to use.

http://www.homeandlearn.co.uk/php/php12p2.html

The above link shows how to create a new database using phpMyAdmin (not my site, it came as #2 in my google search results)

For MySQL login, you will use the username you use to log into phpMyAdmin.
For MySQL password, enter the password you use to log into phpMyAdmin.
For MySQL server, it is most likely localhost (I don’t remember where info about this is and I rarely use anything else o.O)
For MySQL database, enter in the name of the database you created in phpMyAdmin for TXP.

That explains how to get the information and where it goes ;)

Last edited by ~cXc~ (2011-01-05 05:31:17)