Using your text editor, open the
control/connect.php file and perform the following actions:
[
A] Edit database connection parameters to point to the database you wish to use. Contact your host if you aren`t sure. Prefix is required if you only have a single database. This might be something
with an underscore. Its fine to leave the prefix as is, so don`t change if you aren`t sure. See notes. Example:
define('DB_HOST', 'localhost');
define('DB_USER', 'joeblogs_admin');
define('DB_PASS', '12345XX');
define('DB_NAME', 'shop');
define('DB_PREFIX', 'mc_');
[
B] Specify character set for database. Can be left blank if preferred. Used for 'Set Character Set' and 'Set Names'. If you aren`t sure, utf8 should be fine. See notes:
define('DB_CHAR_SET', 'utf8');
[
C] Specify locale for your database. Only really required to be changed if your language isn`t English. This will ensure text data in dates converted by MySQL is in your local language. For English, 'en_GB' should be fine for all. See notes:
define('DB_LOCALE', 'en_GB');
[
D] Specify secret key (or salt). This is for security and is encrypted during script execution. Random numbers, letters and characters are recommended.
You can use md5 or sha1 functions for increased security if you wish. Examples:
define('SECRET_KEY', 'fd764%^]h9[-)[87fde');
define('SECRET_KEY', md5('fd764%^]h9[-)[87fde'));
define('SECRET_KEY', sha1('fd764%^]h9[-)[87fde'));
[
E] The option to display MySQL errors should only be enabled if you are having problems. This will display the possible problem. As its a security risk to
display MySQL errors because of server paths, this is disabled by default. Instead a simple message appears whenever a MySQL error occurs. Edit as required, then save file.