execute command denied to user 'tisegoco_goitse'@'localhost' for routine 'tisegoco_tisego.offices

Question

Hi

I tried to upload my project on my machine and the error that I get from mysql is:

execute command denied to user 'tisegoco_goitse'@'localhost' for routine 'tisegoco_tisego.offices

I granted this user all privileges on the db.

Now I am trying to access this procedure:

delimiter //
create procedure sample()
begin
      select * from tblusers;
end
delimiter ;

and the php code is as follows:

require ("db.php");
$db = dbConnect();

$result = $db->query("CALL sample()");
echo $db->error;
while(list($id, $city, $address) = $result->fetch_array())
echo "($id) $city: $address <br />";

Please help thank you.

Answer 1

You're probably on a shared-server.

Cpanel/PHPMyAdmin does not allows user to give execute permission on cPanel based shared-servers. The issue can only be fixed by your webhost company having root access. Ask them to grant required permissions.

Even if you grant all permissions yourself, you are not going to get the execute permissions.

Answer 2

Forget the stored procedures for now and try to do a simple query to see like so.

Take it in small steps.

<?php

    require ("db.php");

    $db = dbConnect();

    echo 'Doing query...';

    $result = $db->query("SELECT * FROM offices");

    if (!(is_object($result)))
      {
      echo 'No result returned from query';
      //echo $db->error;
      }
    else 
      {

      while(list($id, $city, $address) = $result->fetch_array())
        {
        echo "($id) $city: $address \n";
        }
      }


    ?>