When you install Rundeck on your server ,H2 database is configured by default. I prepared a video to guide you for migrating this database in Mysql.

Rundeck version: 2.11

Mysql version: 5.5

This procedure is applicable to all Rundeck versions.



Rundeck’s administration document:

https://docs.rundeck.com/docs/administration/configuration/database/mysql.html#install-mysql

After migration, if you encounter some errors like ‘Service unavailable’ or ‘problem to connect mysql database’, apply following procedure:

Check logs under /var/log/rundeck/service.log

  • Connect to your mysql database with root user and type commands below.

mysql -u root -p

GRANT ALL ON rundeck.* to rundeck;

  • Check permissions with,

SHOW GRANTS FOR rundeck;

Then restart rundeck service.