Illuminate\Database\QueryException : could not find driver

Question

My Laravel Project is working fine on localhost, but when I hosting this on cpanel and try to login or register. it's through me this error like could not find driver (SQL: select * fromuserswhereemail= [email protected] limit 1). What Should I do..??

Did you configure your environment using the .env file? What value did you use for DB_CONNECTION? — MaartenDev
– MaartenDev, Commented Aug 18, 2019 at 19:24
Yes, this my connection DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=nextnir_next DB_USERNAME=nextnir_nexto DB_PASSWORD=nextnir@next — Shekh Saifuddin
– Shekh Saifuddin, Commented Aug 18, 2019 at 19:27
Are you sure mysql is installed on that environment? Could you add a route that executes phpinfo(); to further debug this issue? — MaartenDev
– MaartenDev, Commented Aug 18, 2019 at 19:32
Actually I don't know how to install mysql on live server, and where I find this phpinfo(); ? — Shekh Saifuddin
– Shekh Saifuddin, Commented Aug 18, 2019 at 19:38
Possible duplicate of Laravel 5 PDOException Could Not Find Driver There are already plenty of this type of questions with correct answers that a simple research can find. — dparoli
– dparoli, Commented Aug 18, 2019 at 20:10

Anurag Srivastava · Accepted Answer · 2024-01-16 07:15:42Z

18

You probably didn't enable PDO extension. In your cpanel select

SOFTWARE > Select PHP Version

You see all extensions there, enable these extensions :

pdo
mysqlnd
ndmysqli
nd_pdo_mysql

edited Jan 16, 2024 at 7:15

Anurag Srivastava

14.5k4 gold badges39 silver badges47 bronze badges

answered Aug 20, 2019 at 16:38

Mnikoei

1914 bronze badges

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

2 Comments

Ivar Mortulev Over a year ago

had almost the same problem, nd_pdo_mysql was not enabled by default in cPanel on the hosting server. Thanks @Mnikoei

bito_ Over a year ago

Well done @Mnikoei

Shekh Saifuddin · Accepted Answer · 2019-08-20 16:17:55Z

0

First of all, I want to thank all of you guys, I find another solution to solve this kind problem, What I have done just in my .htaccess file this line of code

# php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php71” package as the default “PHP” programming language. <IfModule mime_module> AddHandler application/x-httpd-ea-php71 .php .php7 .phtml </IfModule> # php -- END cPanel-generated handler, do not edit and change

DB_USERNAME=something DB_PASSWORD=something

and my problem is solved, this is enabled mysql also, Thank you guys Happy Coding....

edited Aug 20, 2019 at 16:17

answered Aug 19, 2019 at 17:33

Shekh Saifuddin

5293 gold badges8 silver badges33 bronze badges

Collectives™ on Stack Overflow

Illuminate\Database\QueryException : could not find driver

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related