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
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/