mysql 8 зміна паролю з плагіном caching_sha2_password

SET GLOBAL validate_password.LENGTH = 4; 

SET GLOBAL validate_password.policy = 0; 

SET GLOBAL validate_password.mixed_case_count = 0; 

SET GLOBAL validate_password.number_count = 0; 

SET GLOBAL validate_password.special_char_count = 0; 

SET GLOBAL validate_password.check_user_name = 0;

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';

FLUSH PRIVILEGES; 

 

глюк phpmyadmin: - count(): Parameter must be an array or an object that implements Countable

файл /usr/share/phpmyadmin/libraries/sql.lib.php 613 лінія

|| (count($analyzed_sql_results['select_expr'] == 1)

 заміна на

|| ((count($analyzed_sql_results['select_expr']) == 1)