Apache authentication via sql in fedora/rhel/almalinux/rocky linux

Question

on fedora I installed apache and mysql, I created the user with certain privileges and I populated the database, but I can't connect apache with sql. Can anyone help me on how to do it?

I've tried editing my httpd.conf file but nothing, I would expect when I put my ip address on the browser it looks for my credentials, I enter my database credentials and access the page