MySQL TestLink Database Configuration

Introduction

MySQL TestLink Database Configuration is to define the database server details to the TestLink instance. We can define it during the TestLink installation process.

To install MySQL server on the Linux machine :

https://www.testingdocs.com/install-mysql-server-on-linux/

Database Details

We can define the database instance details to store in TestLink data.

  • Database Type
  • Database Host
  • Database Name
  • Table Prefix

Username and password of the MySQL database should be provided to setup the DB schema. The table prefix would be attached before the database objects like tables, views etc. If you work on multiple databases this prefix would identify the TestLink tables.

Screenshot

MySQL Database Configuration

 

Two SQL scripts would be used to create Table schema and populate the TestLink schema with sample data. These scripts can be found under the install folder.  install/sql/mysql

testlink_create_tables.sql

testlink_create_default_data.sql

Database Configuration File

The TestLink DB Configuration file is stored in the file: config_db.inc.php

This file would be automatically created by the TestLink installer during the install process. Sample File contents:

<?php
// Automatically Generated by TestLink Installer - Mon, 20 Mar 17 16:30:59 +0000
define('DB_TYPE', 'mysql');
define('DB_USER', 'testlink_user200');
define('DB_PASS', 'testlinkPaswrd33');
define('DB_HOST', 'localhost');
define('DB_NAME', 'testlink_db200');
define('DB_TABLE_PREFIX', 'tl_');

TestLink DB User

In this screen we need to provide MySQL server root credentials ( * This is NOT the root user credentials of the Linux box * ) and a TestLink DB User credentials. This TestLink DB user should have all the privileges on the database.

Warning

As part of the install process, all  TestLink tables present on the database/schema (if any TestLink table exists) would be dropped. Backup your database Before installing and load after this process.

 

TestLink Tutorial on this website can be found at:
https://www.testingdocs.com/testlink-tutorials/

More information on TestLink Open source Test management tool can be found on the official website at: http://testlink.org

Related Posts