Database Error 1064 while executing a SELECT query in CodeIgniter

Question

I am trying to code CodeIgniter authentication, but when I try, I make an error like this

A Database Error Occurred

Error Number: 1046

No database selected

SELECT * FROM (user) WHERE user_username = 'amanda' AND user_passwordMD5("12345") =

Filename: C:\xampp\htdocs\codeigniter\system\database\DB_driver.php

Line Number: 330

My database.php file:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = 'authtentication';
$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;

can you please make sure you have setup database configuration in config/database.php file — user3470953
– user3470953, Commented Apr 5, 2014 at 6:08
Please refer to the Codeignitor documentation before jumping to the coding. — dikesh
– dikesh, Commented Apr 5, 2014 at 6:13

Laukik Patel · Accepted Answer · 2014-04-05 06:10:26Z

3

please make sure you have setup database configuration in application/config/database.php file

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'my_database';

answered Apr 5, 2014 at 6:10

Laukik Patel

7437 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Revoir Hz Over a year ago

thx, I have tried it and then appear again error like this A Database Error Occurred Unable to select the specified database: authtentication Filename: C:\xampp\htdocs\codeigniter\system\database\DB_driver.php Line Number: 140

Laukik Patel Over a year ago

Please check your MySql Server it's running?

Laukik Patel Over a year ago

Make sure your database is exists

ReNiSh AR · Accepted Answer · 2014-04-05 06:12:33Z

2

Check the database.php file in application/config/

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'mypassword';
$db['default']['database'] = 'my_database'; // here is the database selection

answered Apr 5, 2014 at 6:12

ReNiSh AR

2,8623 gold badges34 silver badges43 bronze badges

3 Comments

Revoir Hz Over a year ago

I have tried it and then appear again error like this A Database Error Occurred Unable to select the specified database: authtentication Filename: C:\xampp\htdocs\codeigniter\system\database\DB_driver.php Line Number: 140

ReNiSh AR Over a year ago

have you specified the db on database.php

Revoir Hz Over a year ago

$db['default']['hostname'] = 'localhost'; $db['default']['username'] = ''; $db['default']['password'] = ''; $db['default']['database'] = 'authtentication'; $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; sorry

martianwars · Accepted Answer · 2016-12-10 23:06:06Z

0

Open the file application/config/database.php file and change the following line:

$db['default']['dbdriver'] = 'mysql';

To:

$db['default']['dbdriver'] = 'mysqli';

This shift to mysqli saved by day.

edited Dec 10, 2016 at 23:06

martianwars

6,5205 gold badges37 silver badges45 bronze badges

answered Dec 10, 2016 at 18:50

Mizuhashi Akito

1

Comments

mickmackusa · Accepted Answer · 2025-04-17 16:49:31Z

-1

$config['hostname'] = "localhost";
$config['username'] = "username";
$config['password'] = "password";
$config['database'] = "database";
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = FALSE;
$config['db_debug'] = TRUE;
$config['cache_on'] = FALSE;
$config['cachedir'] = "";
$config['char_set'] = "utf8";
$config['dbcollat'] = "utf8_general_ci";

edited Apr 17 at 16:49

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Apr 5, 2014 at 14:53

user3470953

11.4k2 gold badges19 silver badges18 bronze badges

Collectives™ on Stack Overflow

Database Error 1064 while executing a SELECT query in CodeIgniter

4 Answers 4

3 Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related