Ver Mensaje Individual
  #5 (permalink)  
Antiguo 03/02/2014, 12:18
cpu210
 
Fecha de Ingreso: enero-2014
Mensajes: 22
Antigüedad: 10 años, 3 meses
Puntos: 0
Respuesta: Generar CSV con INTO OUTFILE Problema permisos!

Gracias!

Cuando me conecto a phpMyAdmin del servidor remoto, se me conecta con el siguiente usuario:

Usuario: cpses_buFdVzGhMY@localhost, se ve que es un usuario que crea temporal o algo así.. ¿Cómo se podría cambiar?

en creado un php que se conecta con el usuario y pass que quiero comprobar y he hecho el query SHOW PRIVILEGES; y me da el siguiente resultado:

Alter----Tables----To alter the table
Alter routine----Functions,Procedures----To alter or drop stored functions/procedures
Create----Databases,Tables,Indexes----To create new databases and tables
Create routine----Databases----To use CREATE FUNCTION/PROCEDURE
Create temporary tables----Databases----To use CREATE TEMPORARY TABLE
Create view----Tables----To create new views
Create user----Server Admin----To create new users
Delete----Tables----To delete existing rows
Drop----Databases,Tables----To drop databases, tables, and views
Event----Server Admin----To create, alter, drop and execute events
Execute----Functions,Procedures----To execute stored routines
File----File access on server----To read and write files on the server
Grant option----Databases,Tables,Functions,Procedures----To give to other users those privileges you possess
Index----Tables----To create or drop indexes
Insert----Tables----To insert data into tables
Lock tables----Databases----To use LOCK TABLES (together with SELECT privilege)
Process----Server Admin----To view the plain text of currently executing queries
Proxy----Server Admin----To make proxy user possible
References----Databases,Tables----To have references on tables
Reload----Server Admin----To reload or refresh tables, logs and privileges
Replication client----Server Admin----To ask where the slave or master servers are
Replication slave----Server Admin----To read binary log events from the master
Select----Tables----To retrieve rows from table
Show databases----Server Admin----To see all databases with SHOW DATABASES
Show view----Tables----To see views with SHOW CREATE VIEW
Shutdown----Server Admin----To shut down the server
Super----Server Admin----To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.
Trigger----Tables----To use triggers
Create tablespace----Server Admin----To create/alter/drop tablespaces
Update----Tables----To update existing rows
Usage----Server Admin----No privileges - allow connect only


A mi me parece que esto solo muestra una lista de los privilegios disponibles y su descripción...