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@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@centos.org http://lists.centos.org/mailman/listinfo/centos
On Thu, May 6, 2010 at 3:18 AM, Jobst Schmalenbach jobst@barrett.com.au wrote:
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
Of course, unless someone drops that table/db as well. :)
On Wed, May 05, 2010 at 06:35:33PM -0700, ann kok (oiyankok@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@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@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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Hi Jobst
Thank you
I set it to TRUE
$cfg['Servers'][$i]['history'] = TRUE; // table to store SQL history
I try to run the sql in phpmyadmin but where is pma_history ?
Thank you
--- On Wed, 5/5/10, Jobst Schmalenbach jobst@barrett.com.au wrote:
From: Jobst Schmalenbach jobst@barrett.com.au Subject: Re: [CentOS] phpmyadmin To: centos@centos.org Received: Wednesday, May 5, 2010, 10:18 PM
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@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@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@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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
From: ann kok oiyankok@yahoo.ca
I set it to TRUE $cfg['Servers'][$i]['history'] = TRUE;
It is supposed to be the name of an existing sql table... Use 'pma_history' as advised... And check the table phpmyadmin.pma_history
JD
-
ann kok -
Jobst Schmalenbach -
John Doe -
John R Pierce -
Lucian