新版mysql改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'qwe!@#QWE'; 

  1. update user set authentication_string='' where user = 'root';

  2.  
  3. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'

©️2020 CSDN 皮肤主题: 技术黑板 设计师:CSDN官方博客 返回首页