Skip to content

Pitfalls

mysql CLI Console Password Character "Limit"

mysql command only reads in 79 characters of "password" from TTY / "console". In my case I was copy'n'pasting / the password store autotyping database passwords which doesn't work then (leads to Access denied for user errors because the password is wrong).
This "limit" doesn't seem to be documented anywhere I looked, so here we go. If you want to login to your users only use passwords 79 characters long when "typing" them on the console.

Thanks to this Jira ticket (MXS-1766) to pointing to the code behind the "limitation"!

I also need to give a shoutout to the people with which I reflected the issue and then stumbled upon the mysql CLI limitation.

Code references:

Replication User Password Character Limit

The password for a replication user must be a maximum of 32 characters long.

MySQL Memory / Storage Size Suffixes

TL;DR The suffixes are in "Bytes". E.g., 16M = 16777216 Bytes.

1
2
mysql --max_allowed_packet=16777216
mysql --max_allowed_packet=16M

The first command specifies the value in bytes. The second specifies the value in megabytes. For variables that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. (For example, when used to set max_allowed_packet, the suffixes indicate units of kilobytes, megabytes, or gigabytes.) As of MySQL 8.0.14, a suffix can also be T, P, and E to indicate a multiplier of 10244, 10245 or 10246. Suffix letters can be uppercase or lowercase.

Quoted from: MySQL 8.0 Reference Manual - 4.2.2.5 Using Options to Set Program Variables