+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: data base settings (/showthread.php?tid=52667)
data base settings - El Forum - 06-20-2012
[eluser]Unknown[/eluser]
hy i'm new to codeigniter, and i have a problem, i get this error:"
Unable to select the specified database: saydix10_clone
Filename: core/Loader.php
Line Number: 346.
I'm using codeigniter with this settings:
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'saydix10_saydi';
$db['default']['password'] = '';
$db['default']['database'] = 'saydix10_clone';
$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;
HELP ME PLS.
data base settings - El Forum - 06-20-2012
[eluser]MRosenello[/eluser]
A few things you can check (some of them may seem obvious).
1) Does that DB exist?
2) Are the user name and password correct that you are trying to use?
3) Does the user that you are using have access to that DB?
-Mike
data base settings - El Forum - 06-20-2012
[eluser]InsiteFX[/eluser]
Set pconnect to FALSE, it causes problems.
data base settings - El Forum - 06-20-2012
[eluser]Narf[/eluser]
It's deffinately not a bug. I'd add another suggestion to those by @mrosenello - are you sure that this user is not password-protected?
@InsiteFX If you're talking about this problem: #793 (which is really a rare case), then I guess you should also take a look at this one, that solves it: #1265.
data base settings - El Forum - 06-20-2012
[eluser]Unknown[/eluser]
[quote author="MRosenello" date="1340214677"]A few things you can check (some of them may seem obvious).
1) Does that DB exist?
2) Are the user name and password correct that you are trying to use?
3) Does the user that you are using have access to that DB?
-Mike[/quote]
You were right the user doesn't have access to the DB, thank you very much.
And thank you all for helping me. Now is working fine!