星宇的博客

1.情况如下：如果忘记密码,可以在mysql的.my.ini 里面配置该参数，可以跳过密码验证：[mysql] skip-grant-tables2.通过cmd登录mysqlmysql -u root -p use mysql; SELECT Host, User, plugin from user;可以看到 root用户的验证器插件为caching_sha2_password3.修改身份验证类型(修改密码) :xxxxx为自己的密码ALTER...

UPDATE user SET authentication_string=PASSWORD("xiayu"), HOST='%',password_expired='N' WHERE user='root';

G:\tool\mysql\bin>mysqld --initializemysqld: Can't create/write to file 'G: ool\mysql\data\is_writable' (Errcode: 2 - No such file or directory)2021-06-02T04:01:42.535302Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use -.