# Users Management and MySQL Workbench

**URL:** <https://forums.percona.com/t/users-management-and-mysql-workbench/2427>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [May 25, 2012, 12:22am UTC](https://forums.percona.com/t/users-management-and-mysql-workbench/2427 "2012-05-25T00:22:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zsoujirou](https://avatars.discourse-cdn.com/v4/letter/z/ce73a5/32.png) [@zsoujirou](https://forums.percona.com/u/zsoujirou)\
**Post date:** [May 25, 2012, 12:22am UTC](https://forums.percona.com/t/users-management-and-mysql-workbench/2427/1 "2012-05-25T00:22:41Z")

</div>

Hi all:

I have a cluster with 4 nodes running Ubuntu Server 12.04, Percona XtraDB Cluster 5.5 and Keepalived for load balancing and automatic failover.

I’m using MySQL Workbench to admin the cluster. The databases are getting replicated accross all the nodes but the users and schema privileges are not getting replicated.

I’ll tryed by using the floating IP and the IP of each node with the same problem.

What I must do to get the user data and permissions replicated automaticaly accross all the nodes?

Thanks in advance for your help.

---

<div class="post-metadata">

**Author:** ![ayurchen](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@ayurchen](https://forums.percona.com/u/ayurchen)\
**Post date:** [May 25, 2012, 6:48am UTC](https://forums.percona.com/t/users-management-and-mysql-workbench/2427/2 "2012-05-25T06:48:39Z")

</div>

Try setting

wsrep\_replicate\_myisam=1

in my.cnf and restart the nodes. This however has the consequence that changes to all MyISAM tables will be replicated, not only administrative ones.

---

<div class="post-metadata">

**Author:** ![zsoujirou](https://avatars.discourse-cdn.com/v4/letter/z/ce73a5/32.png) [@zsoujirou](https://forums.percona.com/u/zsoujirou)\
**Post date:** [May 26, 2012, 9:32pm UTC](https://forums.percona.com/t/users-management-and-mysql-workbench/2427/3 "2012-05-26T21:32:06Z")

</div>

Thanks ayurchen, that did the trick, that works like a charm.

Thanks again.