Can't login to MySQL with MySQL Workbench, Authentication plugin "" couldn't be found in restricted_auth plugin list

[Antoine Beaubien]

I get this message when trying to loggin in with MySQL Workbench to a MySQL server : « Authentication plugin "" couldn't be found in restricted_auth plugin list »

But in the command line mysql, I can login without problems. Here my full log:

12:25:22 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/antoine/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
12:25:22 [INF][ WBContext]: WbContext::init
12:25:22 [ERR][ python]: Error importing Python module /usr/lib/mysql-workbench/modules/wb_admin_grt.py
Unhandled exception in Python code:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 33, in <module>
import wb_admin_main
File "/usr/lib/mysql-workbench/modules/wb_admin_main.py", line 38, in <module>
from wb_admin_configuration_startup import WbAdminConfigurationStartup
File "/usr/lib/mysql-workbench/modules/wb_admin_configuration_startup.py", line 30, in <module>
from wb_log_reader import ErrorLogFileReader
File "/usr/lib/mysql-workbench/modules/wb_log_reader.py", line 103, in <module>
from wb_server_management import SudoTailInputFile, LocalInputFile, SFTPInputFile
File "/usr/lib/mysql-workbench/modules/wb_server_management.py", line 31, in <module>
import pipes
ModuleNotFoundError: No module named 'pipes'

Traceback:
No stack information.
NameError: Error importing Python module /usr/lib/mysql-workbench/modules/wb_admin_grt.py
Unhandled exception in Python code:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 33, in <module>
import wb_admin_main
File "/usr/lib/mysql-workbench/modules/wb_admin_main.py", line 38, in <module>
from wb_admin_configuration_startup import WbAdminConfigurationStartup
File "/usr/lib/mysql-workbench/modules/wb_admin_configuration_startup.py", line 30, in <module>
from wb_log_reader import ErrorLogFileReader
File "/usr/lib/mysql-workbench/modules/wb_log_reader.py", line 103, in <module>
from wb_server_management import SudoTailInputFile, LocalInputFile, SFTPInputFile
File "/usr/lib/mysql-workbench/modules/wb_server_management.py", line 31, in <module>
import pipes
ModuleNotFoundError: No module named 'pipes'

12:25:22 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:25:22 [WRN][ grt]: /home/antoine/.mysql/workbench/connections.xml:23: link '8b5dc88a-17ba-11f0-a6a5-00163ee87780' <object GrtObject> key=owner could not be resolved
12:25:22 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:25:22 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 8.0.41 CE build 4802116 (64 bit)
Configuration Directory: /home/antoine/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.18.4
OS: x86_64
CPU: 8x 12th Gen Intel(R) Core(TM) i3-1215U (2496.000MHz) - 6,32GiB RAM
No video adapter info available
Distribution: Debian GNU/Linux trixie/sid

Fips mode enabled: no

12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ mforms]: Resource file not found: [e-mail]
12:25:22 [WRN][ WBModule]: OS not found on supported OS list. OS string: ' x86_64'
12:25:25 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ WQE backend]: Got an exception during connection: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][SQL Editor Form]: SQL editor could not be connected: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][SQL Editor Form]: Your connection attempt failed for user 'antoine' to the MySQL server at X.X.X.X:3306:
Authentication plugin '' couldn't be found in restricted_auth plugin list.

Please:
1 Check that MySQL is running on address X.X.X.X
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user antoine has rights to connect to X.X.X.X from your address (MySQL rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for X.X.X.X connecting from the host address you're connecting from