Good day,

After talking to support, I have a working example for a procedure that can be executed from another account besides the domain account.

The easiest thing to do is create a .php file that has the code to create the procedure.

Here is the code for a very simple procedure:

<?php
$sql = "
CREATE PROCEDURE `test`()
Begin
select *
from testtable;
End";

echo $sql;

$mysqli = new mysqli('localhost','user','password','database');
echo mysqli_error($mysqli);
$mysqli->query($sql);
echo mysqli_error($mysqli);
$mysqli->close();
?>

When you change the user for the connection, make sure to use the user that you want to call the procedure.

Once you have the file uploaded to the ftp site, go to the php from a web browser and when it runs, it will then create the procedure. You can verify that the correct user has access to it by looking at information_schema.routines.

I'd like to thank bh support again on this for pointing me in the right direction.