Solved

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

Posted on 2007-11-30
5
4,500 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
5 Comments
 
LVL 19

Expert Comment

by:erikTsomik
Comment Utility
MAke sure that you have full access to that table
0
 
LVL 20

Expert Comment

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

Author Comment

by:Dargor
Comment Utility
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
Comment Utility
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now