Last post Apr 16, 2013 02:27 AM by jktiwari2010
Participant
1285 Points
436 Posts
Apr 09, 2013 07:57 AM|jktiwari2010|LINK
select command denied to user for table proc mysql
All-Star
191057 Points
20907 Posts
ASPInsiders
Moderator
MVP
Apr 09, 2013 08:21 AM|XIII|LINK
Hi,
does the user account have enough privileges to actually query the database?
Grz, Kris.
Contributor
6622 Points
1742 Posts
Apr 16, 2013 02:15 AM|Ajay2707|LINK
please check, (As above sir said, Check permission first)
http://knowledge.3essentials.com/web-hosting/article/990/ERROR-SELECT-command-denied-to-user-user-x-for-table-proc.html
http://stackoverflow.com/questions/4767055/error-select-command-denied-to-user-useridip-address-for-table-table
http://stackoverflow.com/questions/4167110/protect-stored-procedure
http://www.daniweb.com/software-development/csharp/threads/265992/mysql-database-error-select-command-denied-to-user-for-table-proc
http://toadformysql.com/thread.jspa?threadID=25933
Apr 16, 2013 02:27 AM|jktiwari2010|LINK
Hi
Thanks to all for reply.
I make a silly mistake...:)
I have resolved this issue making a samll correction in my query.
I have used database name with table name in my query like
SELECT * FROM dbname.tablename;
Now I am change this query like this (This is working fine.)
SELECT * FROM tablename;
Thanks
Participant
1285 Points
436 Posts
MySqlConnector Issue
Apr 09, 2013 07:57 AM|jktiwari2010|LINK
select command denied to user for table proc mysql
Linked In
All-Star
191057 Points
20907 Posts
ASPInsiders
Moderator
MVP
Re: MySqlConnector Issue
Apr 09, 2013 08:21 AM|XIII|LINK
Hi,
does the user account have enough privileges to actually query the database?
Grz, Kris.
Working with Azure, chatbots, ASP.NET MVC, Web API, EF, MS SQL, ...
Keep the forums clean: report to the moderation team!
Contributor
6622 Points
1742 Posts
Re: MySqlConnector Issue
Apr 16, 2013 02:15 AM|Ajay2707|LINK
Hi,
please check, (As above sir said, Check permission first)
http://knowledge.3essentials.com/web-hosting/article/990/ERROR-SELECT-command-denied-to-user-user-x-for-table-proc.html
http://stackoverflow.com/questions/4767055/error-select-command-denied-to-user-useridip-address-for-table-table
http://stackoverflow.com/questions/4167110/protect-stored-procedure
http://www.daniweb.com/software-development/csharp/threads/265992/mysql-database-error-select-command-denied-to-user-for-table-proc
http://toadformysql.com/thread.jspa?threadID=25933
Participant
1285 Points
436 Posts
Re: MySqlConnector Issue
Apr 16, 2013 02:27 AM|jktiwari2010|LINK
Hi
Thanks to all for reply.
I make a silly mistake...:)
I have resolved this issue making a samll correction in my query.
I have used database name with table name in my query like
Now I am change this query like this (This is working fine.)
Thanks
Linked In