79242726

Date: 2024-12-02 00:41:08
Score: 1
Natty:
Report link

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.

Reasons:
  • Whitelisted phrase (-1): worked for me
  • No code block (0.5):
  • Single line (0.5):
  • Starts with a question (0.5): What
  • Low reputation (0.5):
Posted by: c.dasa