0

I've noticed if I set the mysql user's password like below, I cannot connect with MySQL Workbench.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword'

If I use this below I can connect to it:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'myPassword';

I remember at MySQL 8 there was a default password policy change.
But still after years of that change, do the drivers (c/c++, node.js etc) not support the new password authentication?
Does MySQL's own Workbench don't support the new way of authentication? Or am I missing something?

Improve this question

1 Answer 1

Reset to default
0

MySQL Workbench 8 accepts, if mysql server is set to legacy mode, also native_passwords.

But it also accepts users that use cashing_sha2_password or sh2 passwords.

So you must check the users roles and for which. first try to use % in LImit to host matching and DBA as role, so that your user has all privileges to test.

Improve this answer
2
  • I am still confused. Limit to Hosts matching setting is a setting from where someone can connect as this user; localhost or a specific IP or public internet... How is it related to the password encryption method?
    – Seregwethrin
    Jan 23, 2021 at 9:31
  • it has nothing to do with the password setting, but ypou clained that it will not work, so i gave you hints to find the source of the problem
    – nbk
    Jan 23, 2021 at 9:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.