You must connect to the database and use the "mysql_query" function to call a MySQL stored procedure from a PHP page.

I want to show you how to install and use DBeaver to connect to your remote MySQL server. DBeaver is available for Windows, macOS, and Linux.

LibreOffice Base can make working with remote MySQL databases a snap. Jack Wallen walks you through the steps to make this happen.