I am using Windows XP and using EasyPHP as a server. I have integrated Codeigniter with TankAuth. But, when I try to open my assignment folder, it shows error as follows:
Unable to select the specified database: project
Filename: C:\Program Files\EasyPHP-12.1\www\assignment\system\database\DB_driver.php
Line Number: 140
The code inside my database .php is as follows"
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'root123';
$db['default']['database'] = 'project';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
I have checked my database.php, inside it I have database name as 'project'.
I have tried with hostname both as 'localhost' and as '127.0.0.1', but none worked.
I have set my default controller to 'auth' i.e. default controller of TankAuth.
And have initialized 'database' library in the construct in 'auth' controller.
Just now I have tried the same thing using Wamp Server. But, got the same result.
Somewhere I read that I should try making $db['default']['pconnect'] and
$db['default']['db_debug'] to FALSE. But it didn't work.
And all the access permissions have been granted to database 'project'.
Is there anything that I should try to make it work?
Thanks in advance...
The error is stating that it has successfully connected to your database software, but it cannot find the specified DB named project. Check your DB connections and make sure they are all correct -- it sounds like your database name should be assignment instead.
Edit: Check to make sure the DB user your are logging in as has permission to access the specified database, also.