yiisoft/db-mysql

Check DBMS by connection instead of environment variable

Open

#446 opened on Nov 23, 2025

View on GitHub
 (0 comments) (0 reactions) (0 assignees)PHP (20 forks)auto 404
good first issuetype:test

Repository metrics

Stars
 (43 stars)
PR merge metrics
 (PR metrics pending)

Description

Currently we use environment variable YII_MYSQL_TYPE to check DBMS type (MySQL or MariaDB). Instead of relying on the environment variable, we can query the DBMS directly to determine the type, and then cache the result in TestConnection.

Contributor guide

Research direction
Look at how the database connection is established in the Yii MySQL driver. Find a way to query the server version (e.g., using SELECT VERSION()) and detect whether it's MySQL or MariaDB. Then cache the result in the TestConnection class to avoid repeated queries.
Tech stack
php
Domain
backenddatabase
Issue type
Refactor
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GitPHPMySQL/MariaDB
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70