Solved

SELECT command denied to user 'user'@'ip' for table 'tablename'

Posted on 2007-11-30
5
4,518 Views
Last Modified: 2013-11-07
I am using a shared hosting service. My application is ASP.NET and I am using MySQL DB V5.0.23-c-nt

I get the error "SELECT command denied to user 'user'@'ip' for table "municipio" when I try to execute the following query:

SELECT municipio0_.id_municipio as id1_14_1_, municipio0_.st_nombre as st2_14_1_, municipio0_.id_estado as id3_14_1_, estado1_.id_estado as id1_8_0_, estado1_.st_nombre as st2_8_0_ FROM zibler.municipio municipio0_ inner join zibler.estado estado1_ on municipio0_.id_estado=estado1_.id_estado WHERE municipio0_.id_municipio=68


"municipio" and "estado" are the names of my tables


I know the query works because when I test it in local it returns the values correctly, unfortunately I am trying to run this in shared host environment. I have contacted their support team but they claim that I have all the necessary select permissions for my DB/User.

I want to understand what the real problem is, so I can go and have the support team fix it (they don't seem to be able to figure it out on their own).

Thanks for the help in advanced.

Mario
0
Comment
Question by:Dargor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 19

Expert Comment

by:erikTsomik
ID: 20384014
MAke sure that you have full access to that table
0
 
LVL 20

Expert Comment

by:Muhammad Wasif
ID: 20384687
It seems you dont have permissions to connect to the MySQL server remotely.
0
 

Author Comment

by:Dargor
ID: 20385798
Thanks all for the prompt response. I figure what the problem was. It was a stupid thing. I was using my local db name in the query for my hosting db.

I feel dumb.

Thanks a lot though

0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22423031
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question