CodeIgniter database error when opening the website

Question

The website works fine for a while but in a few days returns this error :

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Filename: mysqli/mysqli_driver.php

Line Number: 202

Backtrace:

File: /var/www/html/application/controllers/Login.php Line: 8 Function: database

File: /var/www/html/index.php Line: 289 Function: require_once

A Database Error Occurred

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

Filename: core/CodeIgniter.php

Line Number: 500

Help will be appreciated

Thanks

Nipun

Is the database still running and accepting new connections when this error occurs? — aynber
– aynber, Commented Aug 9, 2016 at 16:39

middlestump · Accepted Answer · 2016-08-09 16:48:35Z

1

Three things possible. Your database has been shut down (or it has died). You have not setup database to use a unix socket when both client and server are on the same machine. Or socket is not readable and writable by web user.

answered Aug 9, 2016 at 16:48

middlestump

1,0559 silver badges23 bronze badges

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

Comments

JobSam · Accepted Answer · 2016-08-09 20:13:27Z

0

The warning is being thrown by mysqli driver. I would recommend that you use PDO driver to connect to the Database.It's simpler and a bit universal (You don't need to change Database settings once you change the DB)

answered Aug 9, 2016 at 20:13

JobSam

3175 silver badges13 bronze badges

Comments

sen · Accepted Answer · 2019-01-04 13:31:25Z

0

you need confirm the database config file:application/config/database.php ensure the confirm item is correct

answered Jan 4, 2019 at 13:31

sen

1238 bronze badges

Comments

Sandeep Banerjee · Accepted Answer · 2019-03-15 06:35:28Z

0

Please check your mysql server connectivity
If you run the app using your pc name i.e. sahil-pc/recruitement or http://85.215.963.104:81/recruitement you need to define it in index.php of root.
please check the permission of your db socket if you are using linux you need to make it in read and write mod.

note: ip details are fake don't try it

answered Mar 15, 2019 at 6:35

Sandeep Banerjee

91 gold badge1 silver badge5 bronze badges

Collectives™ on Stack Overflow

CodeIgniter database error when opening the website

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related