Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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…
Suggested Courses

783 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