Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings by Copilot · Pull Request #310 · wp-cli/db-command · GitHub

MariaDB tests were failing due to SSL warnings cluttering STDERR: WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login. These warnings trigger Behat test failures even when commands succeed.

Changes

DB_Command::run(): Auto-add --ssl-verify-server-cert flag when MariaDB is detected via Utils\get_db_type()
get_mysql_args(): Add ssl-verify-server-cert to allowed MySQL options

The flag is only added if not already present in user arguments, preserving override capability. MySQL installations are unaffected.

// Add --ssl-verify-server-cert for MariaDB to suppress passwordless login warning.
if ( 'mariadb' === Utils\get_db_type() && ! isset( $assoc_args['ssl-verify-server-cert'] ) ) {
    $required['ssl-verify-server-cert'] = true;
}

Mirrors the fix from wp-cli/wp-cli-tests#297, extending it to all db commands (export, import, query, etc.).

Original prompt

This section details on the original issue you should resolve

<issue_title>Improve MariaDB tests</issue_title>
<issue_description>They are still allowed to fail but would be nice to get them to green. There are currently quite a few failing tests, almost all because of --ssl-verify-server-cert warnings cluttering STDERR.

Perhaps we need to pass it manually like was done in wp-cli/wp-cli-tests#297?

Examples:

Failed steps:

001 Scenario: Display information about a non default WordPress table                                                # features/db-columns.feature:44
      And I run `wp db query "CREATE TABLE not_wp ( date DATE NOT NULL, awesome_stuff TEXT, PRIMARY KEY (date) );;"` # features/db-columns.feature:46
        $ wp db query "CREATE TABLE not_wp ( date DATE NOT NULL, awesome_stuff TEXT, PRIMARY KEY (date) );;"
        
        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c7c6bcc3.53632177/
        run time: 0.16866993904114
        exit status: 0 (RuntimeException)

002 Scenario: Database exports with random hash applied # features/db-export.feature:3
      When I run `wp db export --porcelain`             # features/db-export.feature:6
        $ wp db export --porcelain
        wp_cli_test-2026-02-08-68c4205.sql
        
        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c848a357.72059523/
        run time: 0.19305086135864
        exit status: 0 (RuntimeException)

003 Scenario: Database export to a specified file path      # features/db-export.feature:13
      When I run `wp db export wp_cli_test.sql --porcelain` # features/db-export.feature:16
        $ wp db export wp_cli_test.sql --porcelain
        wp_cli_test.sql
        
        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c8c233a4.45982247/
        run time: 0.19237279891968
        exit status: 0 (RuntimeException)

004 Scenario: Exclude tables when exporting the database                              # features/db-export.feature:23
      When I run `wp db export wp_cli_test.sql --exclude_tables=wp_users --porcelain` # features/db-export.feature:26
        $ wp db export wp_cli_test.sql --exclude_tables=wp_users --porcelain
        wp_cli_test.sql
        
        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c94b0ca7.31860636/
        run time: 0.18274307250977
        exit status: 0 (RuntimeException)

005 Scenario: Export database to STDOUT # features/db-export.feature:37
      When I run `wp db export -`       # features/db-export.feature:40
        $ wp db export -

        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c9c54811.18958571/
        run time: 0.19263005256653
        exit status: 0 (RuntimeException)

006 Scenario: Export database with mysql defaults to STDOUT # features/db-export.feature:46
      When I run `wp db export --defaults -`                # features/db-export.feature:49
        $ wp db export --defaults -

        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0c9c54811.18958571/
        run time: 0.19263005256653
        exit status: 0 (RuntimeException)

008 Scenario: Export database with passed-in options                 # features/db-export.feature:64
      When I run `wp db export - --dbpass=password1 --skip-comments` # features/db-export.feature:67
        $ wp db export - --dbpass=password1 --skip-comments

        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0cb900c03.97350758/
        run time: 0.18559980392456
        exit status: 0 (RuntimeException)

009 Scenario: Import from database name path by default # features/db-import.feature:3
      When I run `wp db export wp_cli_test.sql`         # features/db-import.feature:6
        $ wp db export wp_cli_test.sql
        Success: Exported to 'wp_cli_test.sql'.
        
        WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
        cwd: /tmp/wp-cli-test-run--6987f0cd0bbfc5.61320675/
        run time: 0.18721199035645
        exit status: 0 (RuntimeException)

010 Scenario: Import from database name path by default with mysql defaults # features/db-import.feature:15
      When I run `wp db export wp_cli_test.sql`                             # features/db-import.feature:18
        $ wp db export wp_cli_test.sql
        Success: Exported to 'wp_cli_test.sql'.
        
        WARNING: option --ssl-verify-server-cert is dis...

</details>



<!-- START COPILOT CODING AGENT SUFFIX -->

- Fixes wp-cli/db-command#309

<!-- START COPILOT CODING AGENT TIPS -->
---

💬 We'd love your input! Share your thoughts on Copilot coding agent in our [2 minute survey](https://gh.io/copilot-coding-agent-survey).

…s login warning Co-authored-by: swissspidy <841956+swissspidy@users.noreply.github.com>

Codecov Report

❌ Patch coverage is 66.66667% with 1 line in your changes missing coverage. Please review.

Files with missing lines	Patch %	Lines
src/DB_Command.php	66.66%	1 Missing ⚠️

📢 Thoughts on this report? Let us know!

Closing in favor of #334

Initial plan

f8228e1

Copilot AI assigned Copilot and swissspidy Feb 8, 2026

Copilot started work on behalf of swissspidy February 8, 2026 22:03 View session

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordles…

f7567d5

…s login warning Co-authored-by: swissspidy <841956+swissspidy@users.noreply.github.com>

Copilot AI changed the title [WIP] Fix SSL verification warnings in MariaDB tests Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings Feb 8, 2026

Copilot AI requested a review from swissspidy February 8, 2026 22:10

Copilot finished work on behalf of swissspidy February 8, 2026 22:10

swissspidy linked an issue Feb 8, 2026 that may be closed by this pull request

Improve MariaDB tests #309

Closed

github-actions Bot added command:db Related to 'db' command command:db-export Related to 'db export' command command:db-import Related to 'db import' command scope:testing Related to testing labels Feb 8, 2026

This comment was marked as resolved.

Sign in to view

swissspidy added the state:unconfirmed label Mar 12, 2026

Merge branch 'main' into copilot/improve-mariadb-tests

2dd3710

schlessera mentioned this pull request Jul 21, 2026

Skip server certificate verification for MariaDB connections #334

Merged

swissspidy closed this Jul 21, 2026

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings by Copilot · Pull Request #310 · wp-cli/db-command · GitHub

Uh oh!

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings - #310

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings#310
swissspidy with Copilot wants to merge 3 commits into
mainfrom
copilot/improve-mariadb-tests

Copilot AI commented Feb 8, 2026 •
edited
Loading

Uh oh!

Uh oh!

codecov Bot commented Feb 8, 2026

Uh oh!

This comment was marked as resolved.

This comment was marked as resolved.

Uh oh!

swissspidy commented Jul 21, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings by Copilot · Pull Request #310 · wp-cli/db-command · GitHub

Uh oh!

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings - #310

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings#310swissspidy with Copilot wants to merge 3 commits intomainwp-cli/db-command:mainfrom copilot/improve-mariadb-testswp-cli/db-command:copilot/improve-mariadb-testsCopy head branch name to clipboard

Conversation

Copilot AI commented Feb 8, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Changes

Uh oh!

codecov Bot commented Feb 8, 2026

Codecov Report

Uh oh!

This comment was marked as resolved.

This comment was marked as resolved.

Uh oh!

swissspidy commented Jul 21, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Add --ssl-verify-server-cert flag for MariaDB to suppress passwordless login warnings#310
swissspidy with Copilot wants to merge 3 commits into
mainfrom
copilot/improve-mariadb-tests

Copilot AI commented Feb 8, 2026 •
edited
Loading