mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Ver 14.14 Distrib 5.7.19, for macos10.12 (x86_64)
, I logged in as:mysql -uroot -p
then typed in the generated password by MySQL when you install it. Then.ALTER USER 'root'@'localhost' IDENTIFIED BY '<new_password>';
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ab1234';Query OK, 0 rows affected (0.00 sec)mysql> exitBye$ mysql -uroot -p
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SET GLOBAL validate_password_policy=LOW;
SET PASSWORD = PASSWORD('xxxxx');
SET PASSWORD = PASSWORD('your_new_password');
it may crash for it SET GLOBAL validate_password_policy=LOW;
to slove it.show databases ;
uninstall plugin validate_password;
alter user 'root'@'localhost' identified by 'root';
flush privileges;
mysql> SET PASSWORD = PASSWORD('your_new_password');
That works for me.root
user in MySQL used to not have a password and could only connect from localhost. Ibm printer drivers. So you would connect usingmysql-client
, which is a command-line tool, or you can use phpMyAdmin
, which is a web-based tool.