CentOS - May 2010 - phpmyadmin

Hi all

When someone uses the phpmyadmin to delete data, how can I know it

Does it have log?

Thank you

ann kok wrote:
> Hi all
>
> When someone uses the phpmyadmin to delete data, how can I know it
>
> Does it have log?
>   
you mean mysql?   all phpmyadmin is doing is issuing DELETE or DROP or 
whatever commands to the SQL database server.

SQL doesn't log much unless you configure it to, and if you configure it 
to log all statements that can get pretty messy on a high volume 
database with 100s of transactions/second.

If you look into the config file you'll find 

  $cfg['Servers'][$i]['history'] = '';  // table to
store SQL history
                                        //   - leave blank for no SQL query
history
                                        //     DEFAULT: 'pma_history'

Set it and you get the history.

Jobst



On Wed, May 05, 2010 at 06:35:33PM -0700, ann kok (oiyankok at yahoo.ca)
wrote:
> Hi all
> 
> When someone uses the phpmyadmin to delete data, how can I know it
> 
> Does it have log?
> 
> Thank you
> 
> 
> 
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
-- 
Why is the man who invests all your money called a broker?

  | |0| |   Jobst Schmalenbach, jobst at barrett.com.au, General Manager
  | | |0|   Barrett Consulting Group P/L & The Meditation Room P/L
  |0|0|0|   +61 3 9532 7677, POBox 277, Caulfield South, 3162, Australia