Question

Enable MySql for PHP on NGINX after upgrade to Ubuntu 22

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?


Submit an answer
Answer a question...

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!

Sign In or Sign Up to Answer

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.

Bobby Iliev
Site Moderator
Site Moderator badge
October 2, 2022
Accepted Answer

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

KFSys
Site Moderator
Site Moderator badge
October 2, 2022

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?

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.