Solved

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

Posted on 2007-11-30
5
4,502 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
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query 34 82
Whether to use true/false, yes/no or 0/1 11 51
C# HTTP GET method sample code 3 41
mysql between clause 2 8
Creating and Managing Databases with phpMyAdmin in cPanel.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 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

18 Experts available now in Live!

Get 1:1 Help Now