FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > CentOS > CentOS

 
 
LinkBack Thread Tools
 
Old 05-06-2010, 02:18 AM
Jobst Schmalenbach
 
Default phpmyadmin

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
 
Old 05-06-2010, 07:28 AM
Lucian
 
Default phpmyadmin

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
>
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 
Old 05-06-2010, 01:51 PM
ann kok
 
Default phpmyadmin

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
>


_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 
Old 05-06-2010, 03:23 PM
John Doe
 
Default phpmyadmin

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



_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
 

Thread Tools




All times are GMT. The time now is 04:37 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org