mysql8之坑
时间:2022-03-15 15:05
1、修改密码和修改加密方式
mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘新密码‘ PASSWORD EXPIRE NEVER;
mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘新密码‘;
mysql> FLUSH PRIVILEGES;
2、不区分大小写