mysql8.0安装后密码调整
-
创建密码策略:
INSTALL COMPONENT ‘file://component_validate_password’; -
查看是否创建成功,执行后显示如下内容标识密码策略安装成功。属性值可修改(
-
set GLOBAL [Variable_name]=[value])
SHOW VARIABLES LIKE ‘validate_password%’
-
修改密码
ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘root0325’