Hi Roberto.

1) By default, replication applies to mysql.* tables also. GRANTS are
documented to be immediately be applied without FLUSH PRIVILEGES.

2) Most people just have one or two mysql instances per
server machine for production work.

3) If you would like more detailed answers in the future, please say
why you're doing something, and try more formal English. Your
original email was not exactly clear to me. Also, this is the
wrong list for end-user questions like grants and basic replication.

Thanks, James.

--- On Tue, 6/18/13, Roberto Spadim <roberto@spadim.com.br> wrote:

From: Roberto Spadim <roberto@spadim.com.br>
Subject: Re: [Maria-developers] users table
To: "Reindl Harald" <h.reindl@thelounge.net>
Cc: "maria-developers@lists.launchpad.net" <maria-developers@lists.launchpad.net>
Date: Tuesday, June 18, 2013, 4:46 PM

maybe ldap or other feature could help me? thinking about a new auth_plugin for example, there's something that is near to what i need? like
setup mysql database in all servers
setup auth plugin in all servers pointing to some 'master database with users', any grant or auth will be done there and my current server will say ok you are in, (what i'm saying now is near mysql tables replication + some plugin)
thinking again... could replication be used in mysql tables? allowing a automatic flush privileges when something change?


2013/6/18 Reindl Harald <h.reindl@thelounge.net>

Am 19.06.2013 00:03, schrieb Roberto Spadim:
> hi guys, what's the better way to have a shared mysql schema?
> i'm talking about creating a user in one database and this user be created in many databases (in the same server)
> i'm trying with symbolic links in data directory, but sure i have some problems that i need same server version (ok
> no problem) and flush tables in all servers after add an user

this is russian roulette

if you need the same users use a dedicated dtabase with
it's own connection from all applications or implement
logic in the software to connect to all databases for
the insert

this is nothing which should be done with hacks


_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp




--
Roberto Spadim
SPAEmpresarial

-----Inline Attachment Follows-----

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp