Common SQL Errors

MySQL Error 69: EE_UNKNOWN_SHORT_OPTION - How to Fix and Prevent

Galaxy Team
August 5, 2025

The MySQL client or utility cannot recognize a supplied short option flag and aborts with error code 69 (EE_UNKNOWN_SHORT_OPTION).

Sign up for the latest in common SQL errors from the Galaxy Team!
Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)
Oops! Something went wrong while submitting the form.

What is MySQL error code 69 (EE_UNKNOWN_SHORT_OPTION)?

MySQL Error 69: EE_UNKNOWN_SHORT_OPTION appears when a MySQL client or utility encounters an unrecognized -x style flag. Remove or correct the invalid option, or upgrade/downgrade to a version that supports it, to clear the error.

Error Highlights

Typical Error Message

%s: unknown option '-%c'. EE_UNKNOWN_SHORT_OPTION was added in 8.0.13.

Error Type

Configuration/Option Parsing Error

Language

MySQL

Symbol

EE_UNKNOWN_SHORT_OPTION

Error Code

69

SQL State

Explanation

Table of Contents

What is MySQL error code 69 (EE_UNKNOWN_SHORT_OPTION)?

Error code 69 signals that a MySQL program received a short option it does not understand. The message format is “%s: unknown option '-%c'”. Added in 8.0.13, the check fires early during option parsing, so no connection to the server is ever attempted.

Fixing the issue is important because the program will terminate immediately, blocking automation scripts and scheduled jobs.

Understanding which component rejects the flag helps you resolve it quickly.

What Causes This Error?

Most occurrences stem from typos, copy-pasted options from older blog posts, or mixing client versions. A flag valid in 5.7 may be removed in 8.0, triggering EE_UNKNOWN_SHORT_OPTION. Wrapped shell variables that expand to -x flags can also surprise CI pipelines.

How to Fix MySQL Error 69: EE_UNKNOWN_SHORT_OPTION

Identify the exact utility printing the message (mysqld, mysql, mysqldump, etc.).

Run it with --help to list supported flags. Remove, rename, or replace the offending option. If the flag exists only in older versions, install that version or use its long-form equivalent.

Common Scenarios and Solutions

Automation scripts that call mysqldump -p instead of -p[password] can hit the error in strict shells. Container images that upgrade to 8.0 may break legacy init scripts using -T (tab-separated output).

Fix by switching to --tab.

Best Practices to Avoid This Error

Pin MySQL client versions in Dockerfiles, keep option files under version control, and validate all command invocations in CI. Use Galaxy’s snippet library to share vetted command templates the whole team can reuse safely.

Related Errors and Solutions

ER_UNKNOWN_SYSTEM_VARIABLE occurs when a SQL variable is unknown, while ER_PARSE_ERROR flags SQL syntax issues. Unlike EE_UNKNOWN_SHORT_OPTION, both happen after a successful connection.

.

Common Causes

Related Errors

FAQs

Does EE_UNKNOWN_SHORT_OPTION affect the server?

No, the error is raised by the client or utility before any network communication with mysqld.

Can I ignore this error safely?

No, the program exits with status 2, so downstream steps in scripts will fail.

Which MySQL versions show this error?

The condition appears in 8.0.13 and later. Older versions emit a generic unknown option error.

How does Galaxy help?

Galaxy lets teams store and version working command templates, reducing copy-paste mistakes that lead to unrecognized options.

Start Querying with the Modern SQL Editor Today!
Welcome to the Galaxy, Guardian!
You'll be receiving a confirmation email

Follow us on twitter :)
Oops! Something went wrong while submitting the form.

Check out some other errors

Trusted by top engineers on high-velocity teams
Aryeo Logo
Assort Health
Curri
Rubie Logo
Bauhealth Logo
Truvideo Logo