PASA MySQL setup comment

[timkahlke]

Hi,

This is basically not your problem but I thought it might be worth mentioning. When setting up PASA with MySQL the PASA-How-To set's the write access for sql user pasa_write only for specific databases (prefix _pasa).

grant all privileges on `%_pasa`.* to 'pasa_write'@'localhost';

However, funannotate doesn't follow that naming scheme and the pasa_write user can't create/write to the databases.

Might be a security problem, of course, but granting access to everything fixes that.

grant all privileges on *.* to 'pasa_write'@'localhost';

Cheers,
Tim

[schraderL]

Hi,
I am running into this issue, as our admins don't want to grant full priviliges to the mysql PASA user. Is it possible to change the names of the sql databases created by funannotate to match the _pasa or another prefix?
Cheers
lukas

[hyphaltip]

So just a _pasa suffix to the db names - seems easy update @nextgenusfs ?