SELECT command denied to user 'user'@'ip' for table 'tablename'
Posted on 2007-11-30
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.