I've set the same passwords for the following accounts: 'root'@'%', 'root'@''. When I type select user, host, authentication_string from mysql.user I get different values for the authentication_string. enter image description here

Is it because the other way of encryption is used for external accounts like '%'?

  • 1
    add plugin to the columns you want to show and look which plugin is used
    – nbk
    Sep 9 '20 at 12:54
  • 1
    Oh! That's the thing! For 'root'@'' mysql_native_password is used and for 'root'@'%' it's caching_sha2_password. Looks like the last one is more secure. Sep 9 '20 at 13:35
  • yes but if you have programms that don't support it, you need the natove passwort
    – nbk
    Sep 9 '20 at 13:54
  • @nbk I'm not sure about that. For now I use MySQL only with my JIRA software. Sep 9 '20 at 14:10
  • as i stated in the first post of you, a migration is quite complicated and you must follow the steps of the linked mysql. Yopu can only cnnect with ipv6 usually i would say see the(also linked in then answer) and change the bind parameter in the mysql,cnf(ini ifle. But i honestly can't tell what your system looks like, because i don't think that you made a correct migration. So i would recommend, start from a backup and start over
    – nbk
    Sep 9 '20 at 16:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.