共享主机中的存储过程 [英] Stored procedure in shared hosting

问题描述

我在共享服务器中托管了一个网站，并在我的应用程序的数据库中创建了存储过程。但是存储过程显示错误（通过托管应用程序）。

i have hosted a website in shared server and created stored procedure in database for my application.But stored procedure in showing error(through hosted application).

SELECT command denied to user 'localscorespps'@'localhost' for table 'proc'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'localscorespps'@'localhost' for table 'proc'

我尝试过：



我本地电脑中的应用程序和存储过程相同。它的工作

What I have tried:

same application and stored procedure in my local pc . its working

推荐答案

您需要查看SP的内容以及与您连接的MySql用户的权限级别。特别是在共享主机上，您没有完全的管理员权限，很可能是您正在尝试访问您的用户无权访问的表（甚至是数据库）。

You need to look at the content of the SP, and permission levels given to the MySql user that you connected with. Particularly on shared hosting, you do not have full admin rights, and it may well be that you SP is trying to access tables (or even DB's) that your user does not have permission for.

这篇关于共享主机中的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！