[Lsb-infrastructure] Update: New database up - partly / problems

[Denis Silakov]

Wichmann, Mats D wrote:
> I've got this set up, but now I'm stuck on permissions again.
>
> ERROR 1227 (42000) at line 9: Access denied; you need the SUPER
> privilege for this operation
>   
This is actually more serious. MySQL has a separate TRIGGER privilege
only since 5.1.6, and it seems unreasonable to upgrade to such a fresh
version at the moment.

I suggest not to create triggers in the master db at all. They are not
used by Navigator or by other tools that only read the information. So
it would be reasonable to comment out call to 'create_triggers.sql' in
makefile and not have them at the master db. Triggers are really useful
when someone uploads lots of data to the database, but such uploads are
usually performed on local copies of the database, and 'create_triggers'
can be called manually. I'll document triggers usage on wiki.

Thus, 'dbperms.sql' is the only script left to be executed.

-- 
Regards,
Denis.