进入 use

    1. use mysql

    查看

    1. select user,host from user;
    3. +------------------+-----------+
    4. | user             | host      |
    5. +------------------+-----------+
    6. | root             | %         |
    7. | admin            | localhost |
    8. | mysql.infoschema | localhost |
    9. | mysql.session    | localhost |
    10. | mysql.sys        | localhost |
    11. | zhangj           | localhost |
    12. +------------------+-----------+

    可以看到上面root是% 所以需要修改修改密码命令

    1. # 使用
    2. ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';