DEPRECATED: This plugin is no longer actively maintained. Consider using jbox-web/job-database-manager-mysql instead.
Automatically set up test databases for Jenkins jobs.
In the global Jenkins configuration, set up host and port of your
MySQL server and enter credentials of the MySQL user that shall be
used to create databases and grant permissions. Note that this user
needs the
GRANT OPTION
which is not included in
ALL PRIVILEGES.
Configure a database name in a job. The plugin ensures the database exists when the job is run. It grants all permissions for the database to a job specific user and publishes its credentials in the environment variables $MYSQL_USER and $MYSQL_PASSWORD.
There is also a PostgreSQL variant of this plugin:
lmlima/jenkins-postgresql-job-databases-plugin
Please fork and improve.
Copyright (c) 2014 Codevise Solutions Ltd. This software is licensed under the MIT License.