could not find driver (SQL: select * from product) code example

Example: could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

You might need to comment out the following in your php.ini file.
;extension=pdo_mysql.so

############# OR ##############
Other solution might be you may have a missing dependency

If you can, run :
composer update

composer require doctrine/dbal