Error: select command denied to user ‘‘@’‘ for table ‘‘

database user does not have the permission to do select query.

you can grant the permission to the user if you have root access to mysql

http://dev.mysql.com/doc/refman/5.1/en/grant.html

Your second query is on different database on different table.

 String newSQL = "Select `Strike`,`LongShort`,`Current`,`TPLevel`,`SLLevel` from `json`.`tbl_Position` where `TradeID` = '" + i + "'";

And the user you are connecting with does not have permission to access data from this database or this particular table.

Have you consider this thing?

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL string replace
  4. MySQL error 2006: mysql server has gone away
  5. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  8. How to restart remote MySQL server running on Ubuntu linux?
  9. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  10. what does “/index.php?admin/admin_dashboard” in my url mean
  11. How to join two tables by multiple columns in SQL?
  12. How to get size of mysql database?
  13. SQL – Update multiple records in one query
  14. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  15. MySQL: Invalid use of group function
  16. mysqladmin: connect to server at ‘localhost’ failed
  17. mysql update multiple columns with same now()
  18. Usage of MySQL’s “IF EXISTS”
  19. What does SQL clause “GROUP BY 1” mean?
  20. LAST_INSERT_ID() MySQL
  21. Generating a random & unique 8 character string using MySQL
  22. MySQL > Table doesn’t exist. But it does (or it should)
  23. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  24. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  25. Get the new record primary key ID from MySQL insert query?
  26. Create boolean column in MySQL with false as default value?
  27. Is there a naming convention for MySQL?
  28. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  29. Remove Primary Key in MySQL
  30. How to get the max of two values in MySQL?
  31. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  32. MySql – HAVING vs WHERE 
  33. How to stop mysqld
  34. Is merge statement available in MySQL
  35. GROUP_CONCAT comma separator – MySQL
  36. Set page template for all pages?
  37. How to log mysql errors from wordpress core?
  38. Optimize Multiple Taxonomy Term MySQL Query?
  39. WordPress MySQL & PHP Performance
  40. What specific database privileges does WordPress need?
  41. Using source control with WordPress
  42. My WordPress site always displays a cached version of its homepage
  43. wpdb Custom Meta Data with 2 conditions
  44. Updating User Meta with SQL Query
  45. wpdb prepare syntax
  46. How to run this SQL query of wp_terms database
  47. Proper way to work with wpdb to get user’s firstname
  48. How to change post format from Aside to Image for all posts?
  49. Inserting Hundreds of Thousands of Posts at Once
  50. wp_admin edit.php slow with lots of queries
  51. How to add and SQL query of posts only published
  52. Slow Mysql Queries
  53. can database and media folder be moved to a different drive?
  54. Find duplicate posts with same slug and author
  55. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  56. writing inner join in wpdb
  57. How to get data from WordPress site sql file
  58. Unknown collation when I import a dump from an existing site into a development database?
  59. PHP script can’t connect to Database on port 3307
  60. WordPress with php5-fpm and nginx
  61. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  62. How do I join a $wpdb query with user meta using default value if not exist?
  63. mySQL statment count of post in each category and sub category
  64. How to translate this mySQL query to $wpdb query
  65. $wpdb to insert html form information
  66. Proper usage of $wpdb->update()?
  67. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  68. Separate DB by yearly archive of WordPress
  69. What should a WordPress developer know about MySQL? [closed]
  70. Copyright: Get first and last date of post type
  71. Update MySQL query so that it functions again
  72. Is there a page length limit?
  73. Query posts by custom taxonomy and sort by post_modified
  74. WordPress $wpdb get posts from category and sort by custom meta
  75. Create a form with custom autocomplete address field and CSV import values
  76. WordPress insert query is not working : Showing no Error
  77. Some Post Content Does Not Show Up In DB Search
  78. Array Formation Issue
  79. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  80. WordPress $wpdb no result
  81. How can I view my site directly from WordPress dashboard?
  82. get posts whether meta_key exists or not
  83. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  84. When I add metadata, metavalue length is added in to the value in some cases
  85. edit_user_created_user hook – using to update Groups
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. WordPress database error Duplicate entry for key ‘slug’
  88. Improving performance of SQL sub-queries in WordPress
  89. Saving custom term value to the database in new table
  90. MySQL errors after a WordPress clone
  91. `#1215 – Cannot add foreign key constraint
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. MYSQL Join on meta key value?
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment