Report this

What is the reason for this report?

Enable MySql for PHP on NGINX after upgrade to Ubuntu 22

Posted on October 1, 2022

I just upgraded my ubuntu from 21 to 22, and everything seemed to go pretty well except for one thing. I have two PHP websites that use MySql databases, but I can’t get PHP to talk to MySql. Both services are up and running, but MySql is not listed when I do a php_info().

I went into /etc/php/7.4/fpm/php.ini and uncommented the following line:

extension=mysqli

and restarted php using

sudo service php7.4-fpm restart

which returned no errors. It also didn’t change anything in the output from the php_info()

Am I missing something completely obvious here?



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi there,

Have you tried also installing the PHP MySQL extension before uncommenting the line in the php.ini file?

apt install php7.4-mysql

Let me know how it goes!

Best,

Bobby

Hi @kimblim,

The MySQLI extension is to let your PHP connect to MySQL and execute actions like CREATE, READ, UPDATE and DELETE.

How are you trying to connect to your Databases? Are you sure it’s not a configuration error?

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.