← Back to team overview

maria-developers team mailing list archive

Re: users table

 

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@xxxxxxxxxxxxx>

>
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Roberto Spadim
SPAEmpresarial

Follow ups

References