Table "table" does not exist

I have a problem with MySQL connection. The connection changes according to the user. When I connect to the DB it works, but if I try to connect to a different IP, I get the error:

An exception occurred while executing 'SELECT codigo_equipo, ti.codigoTipoIncidencia as tipo_de_incidencia, count(codigo_equipo) as cuenta FROM
AYTOGRANADA_BD.incidencias_resumen a INNER JOIN nmgi_gestion.subtipos_incidencia st ON st.idSubtipoIncidencia = a.idSubtipoIncidencia
INNER JOIN nmgi_gestion.tipos_incidencia ti ON ti.idTipoIncidencia = st.idTipoIncidencia
where fecha_inspeccion>='2015-06-14' and fecha_inspeccion<'2015-06-15' group by codigo_equipo':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'AYTOGRANADA_BD.incidencias_resumen' doesn't exist 

      

The database structure is the same and if I make this request from the phpmyadmin Server it says "there" I get it back with no problem. Could the problem be MySQL permissions?

thank

Connection code:

$params['host'] = "XX.XX.XX.XX";
$params['dbname'] = "AYTOGRANADA_BD";
$params['user'] = "root";
$params['password'] = "XXXX";

      

+3


source to share


1 answer


I think your root user has local access.

Try to execute locally:



show grants;

      

You will probably see something like GRANT ALL PRIVILEGES. TO 'root' @ ' localhost '

0


source







All Articles