Re: Replication and Vanishing Privileges - Sinisa Milivojevic - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsRe: Replication and Vanishing Privileges

From	Sent On	Attachments
C. Nicely	01 May 2003 10:09
Sinisa Milivojevic	01 May 2003 11:24

Subject:	Re: Replication and Vanishing Privileges
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	05/01/2003 11:24:15 AM
List:	com.mysql.lists.bugs

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?

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,