Unable to select the specified database:mydb

[eluser]Tracker[/eluser]
I am using codigniter version 1.7.1 and mysql database.

i just create a table user in mysql using phpmyadmin and want to fetch record using query then following message arise:


A Database Error Occurred

Unable to select the specified database:mydb



How i can solve this???

[eluser]Mike Ryan[/eluser]
Hi,

Did you create a database called "mydb"? Does the user you are connecting to the database as have the required privileges?

[eluser]Tracker[/eluser]
Thanks ryan for your reply. problem is solved i was just forget to give default db username

old
$db['default']['username'] = "";

new
$db['default']['username'] = "root";


Thanks