Replication and Vanishing Privileges

After successfully configuring replication between two mysql servers on my
network, I realized that my privilege settings on the master had vanished!
I could log in as the 'root' mysql user (or any other user) on the master
without a password ... from anywhere! I have to FLUSH PRIVILEGES in order
to restore them (which I shouldn't need to do). Also, If I restart the
master without the my.cnf file in place (i.e. disable replication),
privileges are restored per grant tables.

Here are the contents of the configuration files on master and slave:


MASTER (my.cnf)
---------------------------
[mysqld]
log-bin
server-id=1
---------------------------


SLAVE (my.cnf)
---------------------------
[mysqld]
master-host=(master IP)
master-user=(replication user - FILE privilege only granted on master)
master-password=(replication user's password)
master-port=3306
server-id=2
---------------------------


Master is MySQL 3.23.54 on Mac OS X 10.2.5, Slave is MySQL 4.0.12 on Mac
OS Server 10.2. According to the MySQL Reference Manual and online
documentation, the 3.23.54 (master) - 4.0.12 (slave) combination is
kosher.

Is this a bug, or did I do something stupid?

--
Chad Nicely
Webmaster, College of Architecture and Urban Planning
University of Washington
(206) 616-0495





--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Replication and Vanishing Privileges

C. Nicely writes:
>
> After successfully configuring replication between two mysql servers on my
> network, I realized that my privilege settings on the master had vanished!
> I could log in as the 'root' mysql user (or any other user) on the master
> without a password ... from anywhere! I have to FLUSH PRIVILEGES in order
> to restore them (which I shouldn't need to do). Also, If I restart the
> master without the my.cnf file in place (i.e. disable replication),
> privileges are restored per grant tables.
>
> Here are the contents of the configuration files on master and slave:
>
>
> MASTER (my.cnf)
> ---------------------------
> [mysqld]
> log-bin
> server-id=1
> ---------------------------

[skip]

>
> Is this a bug, or did I do something stupid?
>
> --
> Chad Nicely
> Webmaster, College of Architecture and Urban Planning
> University of Washington
> (206) 616-0495
>

Hi!

I was not able to repeat a bug you reported, although I have set
options just as you described.

Please check:

* that you have not started server with --skip-grant-tables
* that you are truly logged as user root and not as anonymous user


--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Replication

Hi guys,

Having tested replication on a live system for the past three weeks using
Mysql 4.0.12, I have trashed the system twice. Here's how I did it.

1) Changed the hostname on the master and slave without shutting Mysql down
first.
2) Running out of space on the slave.

I highly recommend that if a hostname change is detected, it initiates a
replication shutdown. I also recommend that if there is less than X MB free
on the hard drive, that replication also shuts down and an error is placed
in the error log.

It is far better to be safe than sorry in these instances.

Hope that helps!

Regards,

Mike
Wordtracker
_____________________________________

MIKE MINDEL
Managing Director
Wordtracker
Rivergold Associates Ltd
(Company Number: 3784266)
http://www.wordtracker.com

10 The Broadway
Mill Hill, London
NW7 3LL

Email: mikemindel@wordtracker.com
Fax: 01144 208 959 1388



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org