How to activate PHP7.0 PDO in 16.04 LTS?

Question

I upgraded from 14.04LTS to 16.04LTS; php5 to php7.0; MySQL to 5.7. Apache and PHP are working but when trying to access MySQL databases, I get the following:

fatal error: could not find driver

phpinfo() shows "no value" under PDO Drivers Enabled. Tried to compare php.ini from PHP5 but couldn't see anything obvious. Where do I go from here?

score 39 · Accepted Answer · edited Jul 15 '21 at 11:12

39

Installing php7.0-mysql should be enough:

sudo apt-get install php7.0-mysql

You will then need to ensure the module is enabled:

sudo phpenmod pdo_mysql

Then restart Apache to load the new modules:

sudo service apache2 restart

edited Jul 15 '21 at 11:12

BeastOfCaerbannog

14,585

answered Sep 13 '16 at 18:33

NGRhodes

9,490

I am using nginx. Shall I follow same steps and then restart nginx ? – Vivek Sadh Jul 10 '17 at 08:55
1

@VivekSadh On nginx you probably use php-fpm and therefore need to restart the php server: /etc/init.d/php7.0-fpm restart – Simon Fakir Aug 10 '17 at 19:51
Yeah I figured it out that day. Thx! – Vivek Sadh Aug 17 '17 at 07:47
works for php 7.2 too. sudo apt-get install php7.2-mysql – boroboris Feb 03 '19 at 22:16

score 2 · Answer 2 · edited Jul 15 '21 at 11:11

2

If the problem persists, do:

sudo apt install php7.0-sqlite3

edited Jul 15 '21 at 11:11

BeastOfCaerbannog

14,585

answered Aug 31 '17 at 19:23

Patrick Mutwiri

129

E: Package 'php7.-0-sqlite3' has no installation candidate – DevOpsSauce Sep 10 '20 at 14:50

score 0 · Answer 3 · edited Jul 15 '21 at 11:10

0

For earlier versions:

sudo apt-get install php7.4-pdo

edited Jul 15 '21 at 11:10

BeastOfCaerbannog

14,585

answered Jul 14 '21 at 17:40

Begoodpy

111

score 0 · Answer 4 · edited Oct 24 '17 at 23:05

0

Also try changing the file core/lib/vendor/symfony/lib/response/sfWebResponse.class.php.

You need to change preg_replace to preg_replace_callback for php7.0.

edited Oct 24 '17 at 23:05

Eliah Kagan

117,780

answered Oct 24 '17 at 20:34

Leving Tinoco

11

How to activate PHP7.0 PDO in 16.04 LTS?

4 Answers4