I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
> I'm trying to set up a replication database and cannot get the slave
> to parse the log files on the master.
> The slave is connecting to the master as indicated in the log file.
>
> I have trie
I'm trying to set up a replication database and cannot get the slave to
parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to connect directly to the master database from the mysql
client on the slave and have no problem using the
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:04 PM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is
11:02 AM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
> When I grant privileges as follows, the slave gets updated:
>
> GRANT FILE ON *.* to repl@'%' identified by 'some_password';
>
> Could someone
you don't need to grant
any additional privileges. For example, to create a user named repl
which can access your master from any host, you might use this command:
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '';
>
> Thi Cao wrote:
> >
> > Hello everyone
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 10:42 AM
To: Thi Cao
Cc: MySQL
Subject: Re: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slav
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slave database has just updated itself by means of replication. The
> reason I ask is that I know MySql currently doesn't support
> triggers, but my applicat
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken p
hanks everyone.
Thi
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replica
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replication. Can't seem to get
> it to work yet. The problem reported in the error log of the slave server
> is as follows:
>
> Error reading packet from server: Access den
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote:
>
> I have 10 or so MySQL servers in the field, all writing data to a
> database of the same name. I would like to set up replication from
> all masters back to a single slave server and have each master write
> to a different databa
I have 10 or so MySQL servers in the field, all writing data to a database
of the same name. I would like to set up replication from all masters back
to a single slave server and have each master write to a different database.
Is there an easy way to do this, short of running multiple instances
14 matches
Mail list logo
