Reduced right for Mysqluser since Plesk 12

[Thomas Krcal]

Hello

After updating Plesk to 12.5.30, I miss for default the rights

Alter_routine_priv
Execute_priv
Event_priv

when I create a database.

Basicly this was not a problem, because I addet the rights in the table mysql.db and flush privileges.

I only want to know, if this is a Bug or Plesk decide to change the default right for mysqluser in 12.5.30
and if I can create any template for future.

I urgently need this right on various users and databases, so do I have to add it manually in mysql-db always when I create a new database or database user ?

Thanks

 

[IgorG]

Yes, in Plesk 12.5 database user roles were significantly revised. I suppose that it is related to your case.

 

[Thomas Krcal]

Ok,

Could I define default roles for creating Database users (or something similar).
Otherwise this means, I always have to change by hand directly inside Database.

Thanks