by mikekehrli » 7:25pm, Tue 15 Sep, 2009
I get this message: "Fatal Error: Cannot connect to database, access denied. Please contact the administrator ". I can't seem to get beyond this impasse.
I am relatively familiar with setting up php systems. I have several sophisticated php systems running currently. I've never had trouble creating and connecting to databases before. I have a linux host php version 5.2.10 and MySql version 5.0.67. I created the database and named it SysPrefix_phpLists. I used an existing user name, but gave it full permissions for the new db. I've double checked that the db name and user name are spelled correctly. Below is the db section from my phpList config.php:
# what is your Mysql database server
$database_host = "localhost";
# what is the name of the database we are using
$database_name = "SysPrefix_phpLists";
# who do we log in as?
$database_user = "SysPrefix_admin";
# and what password do we use
$database_password = 'xxxxxxxxxx';
Here is the setup from another (working) php appication for comparison:
// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'SysPrefix_admin');
define('DB_SERVER_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'SysPrefix_forum');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');