Joomla 1.7Joomla Setup

Joomla 1.7 RC1 uses Random Table Prefix in Database Configuration

Joomla 1.7 – Database Configuration Screen

I found the first New Feature in Joomla 1.7 while going through my initial steps of installation. The table prefix field is now prefilled with a randomly generated alphanumeric string instead of a static ‘jos_’.  Random table prefixes help prevent unwanted visitors hacking into your site and retrieving vital username and password information ie your Super Administrator password.  Typically hackers use SQL injections to hack into your Joomla website from the jos_users table.  By simply changing the default prefix to a random string prevents most SQL injections and hacks.

The description says:

Choose a table prefix or use the randomly generated. Ideally, three or four characters long, contain only alphanumeric characters, and MUST end in an underscore.

Joomla 1.7 Database Configuration
Joomla 1.7 Database Configuration

This is not a huge thing but it is a big plus to me because it is important to security of your database. Of course this is only one of many things you can do to protect and secure your Joomla website.


  1. Will

    Thats a nice change.
    Doesn’t unfortunately help in all the previous sites made with Joomla. Any idea how we can change the previous sites, or even the current ones we are working on.
    eg: I have a site being created with 1.6 and will upgrade to 1.7, but therefore wont be going through the installation steps. How do we then change that.
    That would be a good tutorial.

    Great post and as always, great site!

  2. issay

    I know a menual method.
    In SQL query write this:

    ALTER TABLE jos_tablename RENAME TO xxx_tablename

    that means change ‘jos_tablename’ and ‘xxx_tablename’ with your old prefix and new prefix.

    final step is to change database prefix in configuration.php file

Leave a Reply

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

Captcha Captcha Reload