replying only to the list...
On Wed, May 13, 2009 at 10:19:21AM -0700, Scott Haneda wrote:
> >3. Configure on the slave the replication (which databases need to
> >be replicated)
>
> This is where I need a little clarification, is the only thing I need
> to do is adjust my.cnf to have in the
We are using mysqld_multi to start three instances, the command /usr/
bin/mysqld_multi --config-file=/etc/my.cnf start 1-3 works just fine.
But when I tried to put that in rc.local only 3306 would start. Ok
fine.
So I created 3 scripts that I put in /etc/init.d called mysqld1, 2,
and 3.
S
You would be fine.
Grant all does not include with grant option.
Ability to grant has to be given explicitly.
Kyong
At 08:57 AM 5/13/2009, Carlos Williams wrote:
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote:
> One thing though: your user does not need the 'WITH GRANT OPTION' bit
> as
Thanks, a few comments inline below...
On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
talkli...@newgeo.com (Scott Haneda) writes:
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is
The DROP TRIGGER command is in the wrong place. You changed the delimiter to $$
but still tried to use the semicolon(;) with DROP TRIGGER.
Your code should read like this:
DROP TRIGGER IF EXISTS cfe_tg_calcular_consumos;
DELIMITER $$
CREATE TRIGGER cfe_tg_calcular_consumos
AFTER I
2009/5/13 Pintér Tibor :
> how about reading the fine manual of the GRANT command at mysql.com?
I did to avoid being lazy...go figure. I then decided to ask here
before I make a mistake & I felt the fine manual was not clear enough
for me...
--
MySQL General Mailing List
For list archives: http:
Carlos Williams írta:
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote:
One thing though: your user does not need the 'WITH GRANT OPTION' bit
as that gives them permission to gratn permissions to other users,
which I don't think is what you want.
How do I change the bit for 'grant all'
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote:
> One thing though: your user does not need the 'WITH GRANT OPTION' bit
> as that gives them permission to gratn permissions to other users,
> which I don't think is what you want.
How do I change the bit for 'grant all' via the CLI? What co
I have a bit of perl code that ends with an error:
$sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
FROM alerts a
Your directive looks fine assuming dublin expects to always connect
from localhost.
One thing though: your user does not need the 'WITH GRANT OPTION' bit
as that gives them permission to gratn permissions to other users,
which I don't think is what you want.
- michael dykman
On Wed, May 13, 200
I have used MySQL twice in my career so I did read the MySQL How-to
page and just wanted to ask here if what I did as correct based on
what I wanted to do. I just wanted to create a new database in MySQL
called "webmail" and then also create a new user who limited to only
accessing the 'webmail' da
2009/5/13 Mauricio Tellez :
> Hi, I'm developed a trigger with mysql version 5.0.51(ubuntu), and when I
> tried to move this to a production server (version 5.0.22 fedora) I ran into
[...]
> but mysql say there is an error near EXISTS cfe_tg_calculas_consumos. Of
http://dev.mysql.com/doc/refman/5.
Hi, I'm developed a trigger with mysql version 5.0.51(ubuntu), and when I
tried to move this to a production server (version 5.0.22 fedora) I ran into
2 problems:
1. I try to install the trigger from a text file, and the first lines were:
DELIMITER $$
DROP TRIGGER IF EXISTS cfe_tg_calcular
13 matches
Mail list logo
