?
Solved

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

Posted on 2007-11-30
5
Medium Priority
?
4,539 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
4 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

593 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