could not find driver (SQL: select * from information_schema.tables where table_schema = ecommerce a | Laravel | Page 1

errant basin Apr 13, 2023, 6:12 PM

#

I tried every solution but still not working, If anyone know about this please help me out
Thank you

strange robin Apr 13, 2023, 6:23 PM

#

Share your whole error.

errant basin Apr 13, 2023, 6:36 PM

#

Illuminate\Database\QueryException

could not find driver (SQL: select * from information_schema.tables where table_schema = ecommerce and table_name = migrations and table_type = 'BASE TABLE')

at F:\xampp\htdocs\ecommerce\vendor\laravel\framework\src\Illuminate\Database\Connection.php:712
708▕ // If an exception occurs when attempting to run a query, we'll format the error
709▕ // message to include the bindings with SQL, which will make this exception a
710▕ // lot more helpful to the developer instead of just the database's errors.
711▕ catch (Exception $e) {
➜ 712▕ throw new QueryException(
715▕ }
716▕ }

1 F:\xampp\htdocs\ecommerce\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
PDOException::("could not find driver")

2 F:\xampp\htdocs\ecommerce\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
PDO::__construct()
@strange robin

strange robin Apr 13, 2023, 6:37 PM

#

What driver are you using? Can you share your sanitized .env config settings?

errant basin Apr 13, 2023, 6:38 PM

#

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:fj751kNkXOm9FWMPkXMBF/5iU50G6k6ofY29Q8sYczM=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=ecommerce
DB_USERNAME=root
DB_PASSWORD=

BROADCAST_DRIVER=log
CACHE_DRIVER=file
FILESYSTEM_DRIVER=local
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=mailhog
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=
AWS_USE_PATH_STYLE_ENDPOINT=false

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

#

@strange robin

strange robin Apr 13, 2023, 6:39 PM

#

So you most likely don't have the mysql driver installed.

errant basin Apr 13, 2023, 6:39 PM

#

But already have in php.ini

strange robin Apr 13, 2023, 6:39 PM

#

Also remove your encryption key

#

Have you restarted apache?

#

Or nginx if you're using that

errant basin Apr 13, 2023, 6:40 PM

#

Yes

#

I have previously used migration but it was working fine

strange robin Apr 13, 2023, 6:41 PM

#

Run php -m | grep -i mysql

errant basin Apr 13, 2023, 6:41 PM

#

grep : The term 'grep' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that
the path is correct and try again.
At line:1 char:10

php -m | grep -i mysql
```
     ~~~~
```
- CategoryInfo : ObjectNotFound: (grep:String) [], CommandNotFoundException
- FullyQualifiedErrorId : CommandNotFoundException

#

Saying this

strange robin Apr 13, 2023, 6:41 PM

#

Ah, windows?

#

php -m | findstr -i mysql

errant basin Apr 13, 2023, 6:42 PM

#

Yes brother

#

Please help me

strange robin Apr 13, 2023, 6:44 PM

#

Run that and see what it outputs.

errant basin Apr 13, 2023, 6:48 PM

#

mysqlnd

#

this is saying

#

What i have to do now?

strange robin Apr 13, 2023, 6:49 PM

#

So it doesn't look like pdo_mysql is installed.

errant basin Apr 13, 2023, 6:49 PM

#

Yes brother

strange robin Apr 13, 2023, 6:49 PM

#

In your PHP ini file uncomment pdo_mysql

errant basin Apr 13, 2023, 6:49 PM

#

But still now working

#

Already done

strange robin Apr 13, 2023, 6:49 PM

#

Then you need to restart php and apache.

errant basin Apr 13, 2023, 6:50 PM

#

Yes already did

strange robin Apr 13, 2023, 6:50 PM

#

Are you sure? If it was installed we'd see it there.

#

I'd think.

errant basin Apr 13, 2023, 6:50 PM

#

#

See

#

@strange robin

strange robin Apr 13, 2023, 6:51 PM

#

Okay, now go to the xampp control panel and stop/restart the apache process again

errant basin Apr 13, 2023, 6:53 PM

#

I use wampp, also tried in xampp

#

giving sam error

#

Restarted

#

Not working

strange robin Apr 13, 2023, 6:54 PM

#

Check php_info() and see if pdo_mysql is in there.

errant basin Apr 13, 2023, 6:57 PM

#

#

Please check

strange robin Apr 13, 2023, 6:57 PM

#

pdo_mysql would be further down under modules.

errant basin Apr 13, 2023, 6:58 PM

#

Then how can i fix it?

strange robin Apr 13, 2023, 6:58 PM

#

Is it not there?

#

Did you actually edit F:\wamp64\bin\apache\apache2.4.51\bin\php.ini?

errant basin Apr 13, 2023, 7:03 PM

#

strange robin Apr 13, 2023, 7:03 PM

#

Where is it symlinked to?

errant basin Apr 13, 2023, 7:03 PM

#

Yes

#

strange robin Apr 13, 2023, 7:04 PM

#

Did you search for pdo_mysql in your php_info() and find it?

errant basin Apr 13, 2023, 7:04 PM

#

Yes brother

strange robin Apr 13, 2023, 7:04 PM

#

So it was there?

errant basin Apr 13, 2023, 7:05 PM

#

#

Yes brother

strange robin Apr 13, 2023, 7:05 PM

#

That isn't php_info lol

errant basin Apr 13, 2023, 7:05 PM

#

Then how will i find?

#

If you dont mind

#

can we seat on google meet?

strange robin Apr 13, 2023, 7:06 PM

#

You linked the php_info above, just go to that page and ctrl+f and type in pdo_mysql

#

No.

errant basin Apr 13, 2023, 7:06 PM

#

Or any other way?

strange robin Apr 13, 2023, 7:06 PM

#

No I don't do screen share.

errant basin Apr 13, 2023, 7:07 PM

#

No i will do mine

#

You will just guide me

strange robin Apr 13, 2023, 7:07 PM

#

No, sorry. Just through this channel.

errant basin Apr 13, 2023, 7:07 PM

#

Yeah sure

#

Where i have to join?

strange robin Apr 13, 2023, 7:08 PM

#

No you misunderstand, just through text in here.

errant basin Apr 13, 2023, 7:08 PM

#

Oh ok

#

this one?

#

#

right?

strange robin Apr 13, 2023, 7:09 PM

#

Load php_info() and find pdo_mysql there.

#

That will confirm that it is installed.

errant basin Apr 13, 2023, 7:09 PM

#

Oh ok wait

errant basin Apr 13, 2023, 7:42 PM

#

#

see this brother @strange robin

#

Its here

#

#

Still not working

strange robin Apr 13, 2023, 7:43 PM

#

Alright try this - go into your website and type php artisan optimize:clear

errant basin Apr 13, 2023, 7:44 PM

#

No same result brother

strange robin Apr 13, 2023, 7:55 PM

#

I'm not sure then Sakib.

#could not find driver (SQL: select * from information_schema.tables where table_schema = ecommerce a