Creating the empty SQL database (Unix/Linux) - 8.0 version

 

TestRail 8.0 is available for Server customers who wish to upgrade urgently to an "early access" version. We recommend that all other customers wait until the "default" version of TestRail 8.0 is available. TestRail 8.0 "default" will be available after the release is deployed to cloud customers.

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.

Was this article helpful?
0 out of 0 found this helpful