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

Example 1: 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

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

If your php.ini file exists then in configuration file simply uncomment the extension:

;extension=php_pdo_mysql.dll 

Else follow below steps

step1:php -v

step2: Install php mysql extension

php 7.0 sudo apt-get install php7.0-mysql

php 7.1 sudo apt-get install php7.1-mysql

php 7.2 sudo apt-get install php7.2-mysql

php 7.3 sudo apt-get install php7.3-mysql

step3: service apache2 restart

step4: php artisan migrate

Example 3: In Connection.php line 664: could not find driver (SQL: select * from information_schema.tables where table_schema = news and table_name = migrations) In Connector.php line 67: could not find driver

;extension=php_pdo_mysql.dll