
03/02/2014, 12:18
|
| | Fecha de Ingreso: enero-2014
Mensajes: 22
Antigüedad: 11 años, 2 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... |