codeigniter - cannot connect to MySQL database

Question

Error that is getting printed out

Unable to connect to your database server using the provided settings.

Filename: core/Loader.php

Line Number: 346

I have been looking through all the other questions and nothing seems to work. Still getting this error. All the info in my database.php file matched up to my info on the mysql server that I am running on the command line. I am also using mysqld and mysql.server start. I have tested the connection on the command line with

mysql -h localhost -uroot -p dbname

And that seems to work on my command line, but it is giving me the error above when I am referencing it on a localhost server I have set up with the codeigniter project. What am i doing wrong? I have double and triple checked naming conventions to make sure that it isn't the issue.

Also, I am on OS X Mavericks

my code in the config file is as follows:

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

Your database credentials are likely wrong. What code are you using to connect to it? — Pekka
– Pekka, Commented Jan 9, 2014 at 19:48
When connecting to the mysql server, are you specifying the IP or the Hostname as the database server host? What version of CI are you using? Can you show your config file obfuscating the password? — Justin E
– Justin E, Commented Jan 9, 2014 at 19:49
Have you checked the php error log, and the mysql connection log? — Justin E
– Justin E, Commented Jan 9, 2014 at 19:53
Could be as simple as PHP or CI not looking for the mysql socket in the right place. — Marc B
– Marc B, Commented Jan 9, 2014 at 19:56

Tim Jones · Accepted Answer · 2014-01-09 22:08:24Z

6

I have run into this problem frequently myself with CodeIgniter. The usual solution (for me!) is to set 'pconnect' and 'db_debug' to FALSE:

$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = FALSE;

answered Jan 9, 2014 at 22:08

Tim Jones

611 bronze badge

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

Comments

Community · Accepted Answer · 2017-05-23 12:16:07Z

3

I tried to change the following line in my config/database.php file and it worked. (The error your getting means something is wrong with your config/database.php)

'hostname' => '/Applications/MAMP/tmp/mysql/mysql.sock',

Explanation for this behaviour is written here (MySQL on OSX finds mysql.sock wrongly).

Cheers!

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Aug 27, 2015 at 9:45

Aden Aldous Wright

413 bronze badges

Collectives™ on Stack Overflow

codeigniter - cannot connect to MySQL database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related