...
Create /usr/local/targeted-id/etc/tid.cnf, if necessary, and set the password for the shib database user (from above); you can copy tid.cnf.example in that directory, and simply set the password accordingly. The file should be readable only by root. Also create /usr/local/targeted-id/etc/admin.cnf, if necessary, which is used by the database backup script;
the shibadmin MySQL user account can be used for the backup.
...