Installing Textpattern: Setting up a MySQL Database

Textpattern CMS uses a MySQL database to store articles, preferences, language strings and more. The installer for Textpattern runs from a browser. This installer will ask you for your database details, specifically:

  • Hostname
  • Database name
  • Database user
  • Database user password

Your Arvixe web server also acts as a database server, so this setup process is a cinch. It all takes place from your server control panel and should take a few minutes or less. Don’t worry if it takes longer, there’s nothing time-sensitive to this process. This is the order in which I recommend you follow to set the database up correctly:

  • Create the database
  • Create the user
  • Associate the two, giving appropriate rights

From your server Cpanel, scroll down to the Databases pane and choose MySQL (not the MySQL Wizard, let’s do this the old school way) from the left:

You may already have databases and users already set up; I don’t, in this instance. The first thing to do is create the database. Your database name will be prepended with your Arvixe username then an underscore (_):

All you have to do is to think of the bit after the underscore. I suggest using something that relates to the site and/or Textpattern so you avoid getting confused. I’m using ‘textpattern’ as the suffix:

Confirm your details are correct and click Create Database. Assuming nothing went wrong, you’ll be shown confirmation that it worked:

You can click Go Back and you’ll be taken back to your MySQL summary page. Your new database is now listed in a table:

That’s step one complete. You have a database. Now, let’s create a MySQL user. Further down the MySQL page is a section for database users. Again, the prefix will be your Arvixe username, then an underscore. Choose something sensible, ideally that relates to the website and/or Textpattern. I chose ‘txpuser’.

Now, choose a password. It’s important that this is not a trivial password. If you’re stuck for a good password, you can use the Password Generator to help you out. Make a note of this password in a text editor. You should have your username and password filled, and a green bar to say you can proceed:

If you’re good to go, click Create User. Voila!:

You’ve just created a user. Click Go Back to take you back to your summary page. The final part of the process is to essentially glue the two new things together and assign the user to the database, giving it appropriate user rights. The table of databases has a column called Users; note that your new Textpattern database doesn’t yet have a user. This is where we fix that.

Choose the Textpattern database and user from the dropdown menu toward the bottom of the page. If you don’t have any other databases or users they should already be selected, like this:

Click Add. You’ll be asked what privileges you want to give this user: allow the user All Privileges by clicking the top check box:

Click Make Changes. Assuming you saw no errors, your changes have been made:

Click Go Back one final time to return you to your MySQL page. From there, you can see your database table with the new user added to your new database:

Congratulations! Note down your Textpattern database name, user and password as they are all needed for the Textpattern installation. I’m going to walk you through that in the next article.

Looking for quality Textpattern Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , | Posted under Textpattern | RSS 2.0

Author Spotlight

Pete Cooper

Pete Cooper

Pete Cooper has been using Textpattern since 2005. Textpattern is his preferred CMS weapon of choice. Its logical and flexible approach to content management makes Pete happy, as does its lightweight core and helpful user community. Pete's website - petecooper.org - runs on top of Textpattern and chronicles his day-to-day experiences from his home near the Atlantic in north Cornwall, United Kingdom.

Leave a Reply

Your email address will not be published. Required fields are marked *


8 − = 5

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>