当前位置:Gxlcms > 数据库问题 > 阿里云安装mysql,初始化密码修改

阿里云安装mysql,初始化密码修改

时间:2021-07-01 10:21:17 帮助过:5人阅读

  • 报错:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
  • flush privileges;
  • 再次:ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;
  • ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  • 执行:SHOW VARIABLES LIKE ‘validate_password%‘;
  • set global validate_password.policy=0;set global validate_password.length=6;
  • 然后再次执行:ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;
  • Query OK, 0 rows affected (0.03 sec)
  • over
  • 阿里云安装mysql,初始化密码修改

    标签:代码   ide   数据库   art   密码   需要   running   centos   restart   

    人气教程排行