MySQL Root Password

1

Hello when trying to change the password of root I am told that it does not meet the requirements and when I try to verify what the requirements are, it tells me that I must reset the password which I can not because of the previous problem.

The way I enter is through sudo mysql , the same thing happens with mysql -h localhost -u root -p

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

I already solved the problem, the syntax to change the password is different.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password AS 'MyNewPass';
    
asked by Eduardo Cruz 14.09.2018 в 01:15
source

1 answer

0

Although I found the solution to change the password, do not solve the problems with the integration of phpMyAdmin and MySQL. I add the link of a small tutorial that I found for the correct installation of MySQL in new versions of linux.

How to install MySQL

And if you see this error

  

your password does not satisfy the current policy requirements

Only the following code should be added to verify what the password requirements are.

SHOW VARIABLES LIKE 'validate_password%';
    
answered by 16.09.2018 в 07:31