TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    TestLink Tutorial

    MySQL TestLink Database Configuration

    TestLink Tutorials

    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

    TestLink Bitnami Cloud Image

    TestLink Tutorial /

    TestLink Bitnami Cloud Image

    Apache Server Configuration

    TestLink Tutorial /

    TestLink REST API Apache Server Configuration

    TestLink Install on Domain

    TestLink Tutorial /

    Install TestLink Software via CPanel Platform

    Test Suite Import Export TestLink

    TestLink Tutorial /

    Import/Export TestSuite in TestLink

    TestLink Tutorial /

    Commercial Alternatives to TestLink Tool

    ‹ TestLink Dev Instance from GitHub› Enable MySQL extensions in PHP.ini

    Recent Posts

    • ChatGPT Subscription Plans
    • Stellar Converter for Database
    • Stellar Log Analyzer for MySQL
    • Stellar Repair for MySQL
    • ChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI Features
    • Shaping the Future of Development: Exploring Key Trends in Software Engineering
    • Improving Java Performance with Multithreading
    • Open-source Vector Databases

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com