PHP 7 RC3 How to install missing MySQL PDO

Question

I am trying to setup webserver with PHP 7 RC3   Nginx on Ubuntu 14 04  for test purposes    I installed Ubuntu in Vagrant using ubuntu trusty64 and PHP 7 RC 3 from Ondrej Sur    https   launchpad net  ondrej  archive ubuntu php-7 0    I can not find the way to install MySQL PDO  PHP sees PDO class but not anything related to MySQL  like PDO  MYSQL ATTR DIRECT QUERY etc    Looks like there is no lib php7 0-mysql  by analogy with standard php5-mysqlnd and php7 0-fpm etc  from Ondrej   Section PDO in phpinfo     PDO support      enabled PDO drivers      no value   How can I get it

User · Answer

If you are on windows  and your php folder is not in your PATH  you have set the absolute directory in your php ini  for example   extension dir    C  php7 ext    and uncomment   extension php mysqli dll extension php pdo mysql dll   Restart apache2 4 and it should work   I hope it helps

User · Answer

Had the same issue  resolved by actually enabling the extension in the php ini with the right file name  It was listed as php pdo mysql so but the module name in  lib php modules was called just pdo mysql so  So just remove the  php   prefix from the php ini file and then restart the httpd service and it worked like a charm   Please note that I m using Arch and thus path names and services may be different depending on your distrubution

User · Answer

I resolved my problem on ubunto 20 4 by reinstalling php-mysql  Remove php-mysql  sudo apt purge php7 2-mysql  Then install php-mysql  sudo apt install php7 2-mysql  It will add new configurations in php ini

User · Answer

On ubuntu 18 04 following works for me type this in your terminal For php7 3 sudo apt-get install php7 3-gd php7 3-mysql  For php7 0 sudo apt-get install php7 0-gd php7 0-mysql  For php5 sudo apt-get install php5-gd php5-mysql

User · Answer

I had  pretty much  the same problem  I was able to see that PDO was enabled but I had no available drivers  using PHP 7-RC4   I managed to resolve the issue by adding the php pdo mysql extension to those which were enabled   Hope this helps

User · Answer

download the source code of php 7 and extract it  open your terminal swim to the ext mysqli directory  use  commands      phpize        configure       make      make install  as root    enable extension mysqli so in your php ini file done    This worked for me

User · Answer

class    gt   yii db Connection        dsn    gt   mysql host localhost 3306 dbname testdb        username    gt   user        password    gt   password        charset    gt   utf8      It s simple  Just provide the port number along with the host name and set default sock path to your mysql sock file path in php ini which the server is running on

User · Answer

First  check if your php ini has the extension enabled  php pdo mysql  and  php mysqli  and the path of  extension dir  is correct  If you need one of above configuration  then  you must restart the php-fpm to apply the changes   In my case  where i am using the Windows OS in the company  i really prefer OSX or Linux   i solved the problem putting this values in the php ini          extension dir    ext           extension php mysqli dll extension php pdo mysql dll          I hope this helps

User · Answer

Since eggyal didn t provided his comment as answer after he gave right advice in a comment - i am posting it here  In my case I had to install module php-mysql  See comments under the question for details

User · Answer

First install php-mysql  sudo apt-get install php7 0-mysql   change the version number based on the php version   then enable the module  sudo phpenmod pdo mysql   and restart apache  sudo service apache2 restart

User · Answer

For thoses running Linux with apache2 you need to install php-mysql  apt-get install php-mysql   or if you are running ubuntu 16 04 or higher just running the following command will be enought  no need to edit your php ini file  apt-get install php7 2-mysql     If you are running ubuntu 15 10 or below   Edit your php ini file  it s located at  etc php  version  apache2 php ini and search for pdo mysql you might found something like this   extension pdo mysql so   Change it to this  extension pdo mysql so   Save the file and restart apache  service apache2 restart   Check that it s available in your phpinfo

User · Answer

I ll start with the answer then context NOTE this fix was logged above  I m just re-stating it for anyone googling    Download the source code of php 7 and extract it  open your terminal swim to the ext pdo mysql directory use commands   phpize    configure  make  make install  as root  enable extension mysqli so in your php ini file   This is logged as an answer from here  please upvote it if it helped you too   https   stackoverflow com a 39277373 3912517  Context  I m trying to add LimeSurvey to the standard WordPress Docker   The single point holding me back is  PHP PDO driver library  which is  None found   php -i   grep PDO                                                                                   PHP Warning   PHP Startup  Unable to load dynamic library  pdo odbc   tried   usr local lib php extensions no-debug-non-zts-20170718 pdo odbc   usr local lib php extensions no-debug-non-zts-20170718 pdo odbc  cannot open shared object file  No such file or directory    usr local lib php extensions no-debug-non-zts-20170718 pdo odbc so   usr local lib php extensions no-debug-non-zts-20170718 pdo odbc so  cannot open shared object file  No such file or directory   in Unknown on line 0 PHP Warning   Module  mysqli  already loaded in Unknown on line 0 PDO PDO support   gt  enabled PDO drivers   gt  sqlite PDO Driver for SQLite 3 x   gt  enabled   Ubuntu 16  Ubuntu 7 3 0   apt-get install php7 0-mysql   Result   Package  php7 0-mysql  has no installation candidate   Get instructions saying all I have to do is run this   add-apt-repository -y ppa ondrej apache2   But then I get this   UnicodeDecodeError   ascii  codec can t decode byte 0xc5 in position 223  ordinal not in range 128    So I try and force some type of UTF  LC ALL C UTF-8 add-apt-repository -y ppa ondrej apache2 and I get this  no valid OpenPGP data found   Follow some other instructions to run this  apt-get update and I get this  Err 14 http   ppa launchpad net ondrej apache2 ubuntu cosmic main amd64 Packages   404  Not Found Err 15 http   ppa launchpad net ondrej php ubuntu cosmic main amd64 Packages   404  Not Found and - I think because of that - I then get   The repository  http   ppa launchpad net ondrej apache2 ubuntu cosmic Release  does not have a Release file    By this stage  I m still getting this on apt-get update   Package  php7 0-mysql  has no installation candidate    I start trying to add in php libraries  got Unicode issues  tried to get around that and     you get the idea    whack-a-mole   I gave up and looked to see if I could compile it and I found the answer I started with     You might be wondering why I wrote so much  So that anyone googling can find this solution  including me

[php] PHP 7 RC3: How to install missing MySQL PDO

Examples related to php

Examples related to mysql

Examples related to ubuntu

Examples related to pdo

Examples related to php-7