CakePHP 3 is NOT able to connect to the database due to a missing PHP extension

Question

I am trying to install cakePHP 3.0.0 with WT-NMP, but i got this message:

CakePHP is NOT able to connect to the database.

Database driver Cake\Database\Driver\Mysql cannot be used due to a missing PHP extension or unmet dependency

my php.ini has this:

extension = php_bz2.dll
extension = php_curl.dll
extension = php_gd2.dll
extension = php_imap.dll
extension = php_mbstring.dll
extension = php_exif.dll
extension = php_mysql.dll
extension = php_mysqli.dll
extension = php_pdo_mysql.dll
extension = php_pdo.dll
extension = php_soap.dll
extension = php_sockets.dll
extension = php_sqlite3.dll
extension = php_openssl.dll
extension = php_fileinfo.dll
extension = php_intl.dll

the app.php has this

    'default' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'persistent' => false,
        'host' => 'localhost',
        /**
         * CakePHP will use the default DB port based on the driver selected
         * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
         * the following line and set the port accordingly
         */
        'port' => '3306',
        'username' => 'root',
        'password' => '',
        'database' => 'test',
        'encoding' => 'utf8',
        'timezone' => 'UTC',
        'cacheMetadata' => true,

What am I missing? or this is cakePHP 3.0 bug? OR anything to do with WT-NMP. I have been stuck for whole day.

score 14 · Accepted Answer · answered Apr 02 '15 at 04:40

14

Solved this by luck!:

extension = php_intl.dll
extension = php_pdo_mysql.dll
intl.default_locale = en_utf8
intl.error_level = E_WARNING

answered Apr 02 '15 at 04:40

Le Duy Khanh

1,339
3
17
36

6

Please explain with more steps. – Karthik Keyan Dec 12 '16 at 09:24
3

More explanation would be better. – Bagus Aji Santoso Aug 30 '18 at 06:13
Specifically the extension = php_pdo_mysql.dll did it for me. – Jage Mar 12 '21 at 12:45

Ash · Answer 2 · 2016-02-29T01:58:45.357

13

Installing the modules for MySQL database connections solved it for me:

#Install the package
sudo apt-get install php5-mysql
#Restart Apache
sudo service apache2 restart

Source: http://guru4cakephp.blogspot.nl/2015/04/install-cakephp-3-on-ubuntu.html

Package details: https://packages.debian.org/sid/php5-mysql

edited Feb 29 '16 at 01:58

answered Feb 09 '16 at 04:41

Ash

8,583
10
39
52

score 9 · Answer 3 · edited Jan 23 '17 at 16:49

9

Try this:

For PHP 7.0

sudo apt-get install php7.0-mysql

For PHP 5:

sudo apt-get install php5-mysql

edited Jan 23 '17 at 16:49

Undo

25,519
37
106
129

answered Jan 23 '17 at 11:02

Amit Dangwal

421
1
4
10

Worked for me on php7.3 sudo apt-get install php7.3-mysql – mark.nz Jun 03 '19 at 02:20

score 5 · Answer 4 · answered Apr 19 '15 at 14:24

The error message is because of extension = php_pdo_mysql.dll not being installed and enabled in php.ini. If you don't have php_intl.dll enabled you will get an error before checking the database connection.

Your php.ini indicates that you have got php_pdo_mysql.dll enabled, however it may have been that you needed to restart the CakePHP server bin/cake server.

score 1 · Answer 5 · answered Aug 07 '15 at 01:51

Don't just depend on the php.ini reading. Just check if you have installed php[v]-mysql extension. You can check if php_mysql.dll exist in the php extension directory(most probably <path to your php installation>/ext) in your windows based server. In linux you can use the following command check if it is installed.

yum list installed | grep php

It will list down all the php extensions installed.

score 0 · Answer 6 · edited Mar 30 '23 at 13:55

0

For Windows:

extension=pdo_sqlite
extension=sqlite3

edited Mar 30 '23 at 13:55

user16217248

3,119
19
19
37

answered Mar 29 '23 at 12:58

Silverworm

1
2

Please add some kind of explanation addressing the thing you used in your answer or documentation mentioning the same. – Archit Gargi Apr 04 '23 at 07:31

CakePHP 3 is NOT able to connect to the database due to a missing PHP extension

6 Answers6

Linked