ℹ️ Important Note:
Starting with TestRail 9.5.1 Server, Cassandra is officially deprecated and enforcement is in place.:
Admins must first run the Cassandra deprecation script in version 9.4.1 before upgrading to more recent versions.
-
If the script has not been executed, the upgrade to more recent versions will be blocked and a warning message will be displayed during the upgrade process.
👉 Please check our Cassandra Deprecation documentation.
TestRail’s installer automatically creates all needed database tables and initial data in the next step, but you must first create an empty database and database user on your Unix server. To do this, use your favorite MySQL administration tool (such as phpMyAdmin), or use the mysql command line tool to create the database table and user:
$ mysql -u root -p
CREATE DATABASE testrail DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'testrail'@'localhost' IDENTIFIED BY 'newpassword';
GRANT ALL ON testrail.* TO 'testrail'@'localhost';If you are creating the database and user manually, please make sure to specify the default character set utf8 with the utf8_unicode_ci collation and grant the new user all privileges to the TestRail database.