Geeklog Forums

Hi! I was trying to install Geeklog and I keep getting this error message.

Warning: Access denied for user: 'thushara@localhost' (Using password: YES) in /home2/thushara/public_html/geeklog/system/databases/mysql.class.php on line 108

Warning: MySQL Connection Failed: Access denied for user: 'thushara@localhost' (Using password: YES) in /home2/thushara/public_html/geeklog/system/databases/mysql.class.php on line 108
Cannnot connect to DB server

my config.php file looks like this:

When setting up Geeklog for the first time, you only need to make sure the
// settings in the following 3 sections are correct:
// (1) Database Settings
// (2) Paths
// (3) Site Settings
// You can adjust the other settings once your site is up and running.

// +---------------------------------------------------------------------------+
// | (1) Database Settings |
// +---------------------------------------------------------------------------+

$_DB_host = 'localhost'; // host name or IP address of your DB server
$_DB_name = 'thushara'; // name of your database,
// must exist before running the installer!
$_DB_user = 'thushara'; // MySQL user name
$_DB_pass = 'password'; // MySQL password

// The table prefix is prepended to each table used be Geeklog to avoid name
// collisions with other tables that may already exist in your database.
$_DB_table_prefix = 'gl_'; // e.g. 'gl_'


// +---------------------------------------------------------------------------+
// | (2) Paths |
// +---------------------------------------------------------------------------+

// Note for Windows users: It's safe to use the forward slash '/' instead of
// the backslash '' in paths. Make sure each path starts with a drive letter!

// This should point to the directory where your config.php file resides.
$_CONF['path'] = '/home2/thushara/public_html/geeklog/'; // should end in a slash

// You only need to change this if you moved or renamed the public_html
// directory. In that case, you should specify the complete path to the
// directory (i.e. without the $_CONF['path']) like this:
// $_CONF['path_html'] = '/path/to/your/public_html/';
$_CONF['path_html'] = $_CONF['path'] . 'public_html/';


// +---------------------------------------------------------------------------+
// | (3) Site Settings |
// +---------------------------------------------------------------------------+

// Make sure this is the correct URL to your site, i.e. to where Geeklog's
// index.php file resides (no trailing slash).
$_CONF['site_url'] = 'http://cgi-bin.spaceports.com/~thushara/geeklog/public_html';

// Some hosting services have a preconfigured admin directory. In that case,
// you need to rename Geeklog's admin directory to something like "myadmin"
// and change the following URL as well. Leave as is until you experience any
// problems accessing Geeklog's admin menu.
$_CONF['site_admin_url'] = $_CONF['site_url'] . '/admin';

// This is the return address for all email sent by Geeklog:
$_CONF['site_mail'] = 'thushara@ilovechocolate.com';

$_CONF['site_name'] = 'Thushara';
$_CONF['site_slogan'] = 'Another Nifty Thing Done By Thushara';

And my lib-common.php file looks like this:

* --- You only need to modify one line in this file! ---
*
* WARNING: put any custom hacks in lib-custom.php and not in here. This file is
* modified frequently by the Geeklog development team. If you put your hacks in
* lib-custom.php you will find upgrading much easier.
*
*/

/**
* Turn this on go get various debug messages from the code in this library
* @global Boolean $_COM_VERBOSE
*/

$_COM_VERBOSE = false;

/**
* Configuration Include: You should ONLY have to modify this line.
* Leave the rest of this file intact!
*
* Make sure to include the name of the config file,
* i.e. the path should end in .../config.php
*/

require_once( '/home2/thushara/public_html/geeklog/config.php' );

I only changed that one line, everything else was the same.

I checked and double checked the name of mySQL username and password, DB server, everything... but I still can't get what I did wrong! Could someone please help me out there? Thanks!

Well, the error message says it all: It can't connect to MySQL, so the problem is there somewhere.

See also http://www.geeklog.net/docs/install.html#access-denied.

bye, Dirk

try using the full name of your database and user eg.
SQLusername_dbname
SQLusername_dbpass

like my host requires the database username first eg.

DJDevon3_geeklog
DJDevon3_password