I'm currently running Apache and PHP-FPM with a MariaDB server on Ubuntu 20.04 LTS.
I have multiple projects within PHP that access mysql databases. Each project has its own database. I've went through and given each project a mysql user with a random unique password with access to only the database the project uses. Is this a good measure of security?
In the off chance one project was compromised or something of the like?