Bug #110570 Cant login with passwords longer than 79 characters
Submitted: 30 Mar 2023 13:17 Modified: 4 Apr 2023 12:41
Reporter: Daniel Becker Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:latest OS:Any
Assigned to: CPU Architecture:Any

[30 Mar 2023 13:17] Daniel Becker 
Description:
This error occurs when you try to log in via the command line
example: mysql -u root -p
and enter a password longer than 79.

Unfortunately you can not use single quotes with special characters

I have found the exact line for you:
https://github.com/MariaDB/server/blob/11.0/mysys/get_password.c#L178

I found a user with the same problem:
https://serverfault.com/questions/1052564/why-does-adding-one-character-to-my-mysql-passwo...

How to repeat:
You are not able to administer your server or log in to your localhost user.
[4 Apr 2023 12:41] MySQL Verification Team 
Hello Daniel,

Thank you for the bug report.
Imho this is duplicate of Bug #92403, please see Bug #92403.

Regards,
Ashwini Patil
[30 May 0:25] HANCHUN LIU 
I submitted a patch for this issue under Bug #92403, which also addresses the tty password length behavior described in this bug.

The contribution is related to Bug #44929, Bug #92403, and Bug #110570.