February 20, 2019
命令行添加mysql用户, 命令行添加新phpmyadmin登录, Access denied for user ‘test’@’localhost’ (using password: YES) except root user, Your password does not satisfy the current policy requirements
进入 mysql
sudo mysql
创建用户:
mysql> CREATE USER 'ikeepstudying'@'localhost' IDENTIFIED BY 'password';
如果有报错:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
那么就查看 mysql 密码默认的要求:
mysql> SHOW VARIABLES LIKE 'validate_password%';
根据要求来创建用户密码。
如果你想修改用户密码的要求,可以用:
SET GLOBA… Read More