The config file below:
// mysql, postgres or any db supported by adodb
//
$engine = 'mysql';
//
// the database user
//
$user = 'root';
//
// the password for the database user
//
$password = '?';
//
// the host (machine) for the database. this is 'localhost' in most of the cases
//
$host = 'localhost';
//
// The name of the database.
//
$database = 'brim';
?>
NEVER USE THE ROOT ACCOUNT FOR APPLICATIONS(Sorry for yelling, but it seems hard to get that this is a big security issue, and not done also because of the special features the root account has on a SME Server).
Instead create a seperate user which has the neccessarry priviliges to access the database:
Login by terminal access as root without a password:
mysql -u root
Get hold of the database name,, think of a username and a password so we can create it using the following statements:
grant all privileges on database.* to 'username'@'localhost' identified by 'password';
flush privileges;
quit
(Mind the ticks around the username and the password).