> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 5:54 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> > Any user can get into mysql, it's what they can do after
Hi,
On 16/10/2010, at 8:50 AM, Daevid Vincent wrote:
Thanks for the reply Jesper, but either there isn't a solution in your
response, or I'm missing it?
What I mean is that you have to explicitly give the grant to each
user that should be allowed to query the table. You can't run one
gr
You obviously know best how your application will query your database, and
you may have already thought through your indexing strategy. If so, please
disregard my comments.
In my experience, it is not often you need separate indexes on most or all
the columns in a table (excepting very narrow t
> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 2:33 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> Hi
>
>
> On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
>
>
Hi
On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
Hey Daevid,
As this time zone table won't change once it is set up. Do a copy
of the
table data into another database and give grants to it.
Copy the data is not a good solution. First of all, time zone data
does change. Secondly if you
> We have a PSE05 "Master" and PSE06 "Slave" (PRODUCTION servers) both
> are
> Ubuntu 32-bit.
> We have a third slave PSE07 which is Ubuntu 64-bit. This is our 'live
> backup' so to speak. We take mysqld down daily on there and tarball the
> /var/lib/mysql and /var/log/mysql as snapshots (since mys
you can use mysqld_multi
On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni wrote:
> did you remove /etc/my.cnf?
>
> 2010/10/15 ml ml
>
> > Hello,
> >
> > i installed mysql with:
> > ./configure --prefix=/usr/local/myprefix/mysql/ && make && make install
> >
> > (at the point mysql is not running ye
did you remove /etc/my.cnf?
2010/10/15 ml ml
> Hello,
>
> i installed mysql with:
> ./configure --prefix=/usr/local/myprefix/mysql/ && make && make install
>
> (at the point mysql is not running yet)
>
> Next i would like to initialize the DB but get the follwoing error:
> --
Hey Daevid,
As this time zone table won't change once it is set up. Do a copy of the
table data into another database and give grants to it.
On Fri, Oct 15, 2010 at 7:57 PM, Johnny Withers wrote:
> I think this is one of those times you would update the mysql.user table
> directly, then flush pr
I think this is one of those times you would update the mysql.user table
directly, then flush privileges.
JW
On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent wrote:
> I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
> the very specific mysql.time_zone_name table?? I do
You can pass the following variables as well
--defaults-extra-file=
--socket=
--port=
On Fri, 2010-10-15 at 18:50 +0530, ml ml wrote:
> Hello,
>
> i installed mysql with:
> ./configure --prefix=/usr/local/myprefix/mysql/ && make && make install
>
> (at the point mysql is not running yet)
>
>
Hello,
i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/ && make && make install
(at the point mysql is not running yet)
Next i would like to initialize the DB but get the follwoing error:
--
#:/usr/local/m
Hi Mario,
MySQL search my.cnf in this order(if I remember well):
1. /etc/my.cnf
2. /basedir/my.cnf
3. /datadir/my.cnf
4. $userhome/my.cnf
you have to make sure that you REMOVE ate least /etc/my.cnf from the system
try and let me know
Claudio
2010/10/15 ml ml
> Hi Claudio,
Hi Mario,
While installing a new instance you don't exactly need to mention
anything except for the --prefix option. While starting the new instance
you can provide all config parameters like config file, datadir etc.
On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
> Hello List,
>
> how do i in
Hi Claudio,
i would like to compile it from source.
Mario
On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni wrote:
> hi,
> do you want to compile or you can use binaries?
>
> Claudio
>
> 2010/10/15 ml ml
>>
>> Hello List,
>>
>> how do i install mysql COMPLETLY in a diffrent directory?
>>
>> Righ
hi,
do you want to compile or you can use binaries?
Claudio
2010/10/15 ml ml
> Hello List,
>
> how do i install mysql COMPLETLY in a diffrent directory?
>
> Right now i am using:
> ./configure --prefix=/usr/local/mysql-5.1.42
> --sysconfdir=/usr/local/mysql-5.1.42/etc
>
> BUT, mysql still looks
Hello List,
how do i install mysql COMPLETLY in a diffrent directory?
Right now i am using:
./configure --prefix=/usr/local/mysql-5.1.42
--sysconfdir=/usr/local/mysql-5.1.42/etc
BUT, mysql still looks for /etc/my.cnf and for
/var/log/mysql/mysql-bin.index ...
So what configure options do i need
I managed to use the older version of MySQL Administrator 1.2.15 and it
appears to back up find using InnoDB online backup.
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman wrote:
> I have had this problem with PHPMyAdmin many times, and the only way I
> know around it, is to go in and do your d
Based on my reply below, do you recommend I continue to have these indexes ?
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Oct 13, 2010 at 8:22 PM
Subject: Re: Primary key not unique on InnoDB table
To: Travis Ard
Cc: "[MySQL]"
Hi Travis,
Thanks for your response. T
Oh this isn't good. Because the database in on a shared server and I don't
think I've got console access ?
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman wrote:
> I have had this problem with PHPMyAdmin many times, and the only way I
> know around it, is to go in and do your dump at the consol
20 matches
Mail list logo