MySqlConnector Issue [Answered]RSS

• • Reply
  jktiwari2010

  Participant

  1285 Points

  436 Posts

  MySqlConnector Issue

  Apr 09, 2013 07:57 AM|jktiwari2010|LINK

  select command denied to user for table proc mysql

  Please mark as Answer if help
  
  Linked In
  
• • Reply
  XIII

  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.

  Read my blog | Twitter
  Working with Azure, chatbots, ASP.NET MVC, Web API, EF, MS SQL, ...
  Keep the forums clean: report to the moderation team!
• • Reply
  Ajay2707

  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

  Please, Mark as Answer if this reply helped you.
  
• • Reply
  jktiwari2010

  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

  SELECT * FROM dbname.tablename;

  Now I am change this query like this (This is working fine.)

  SELECT * FROM tablename;

  Thanks
  
  
  

  Please mark as Answer if help
  
  Linked In