What worked for me was changing the hostname of the user in phpmyadmin to "127.0.0.1" when creating the user. This allows Workbench to properly authenticate the user when attempting to establish the connection. Using "%" as the host allows connection from any host, but it can lead to unexpected behavior or security restrictions (like unsuccessful authentication) depending on MySQL configuration.