Install percona on archlinux without root password
$ pacman -S percona-server-clients percona-server
$ systemctl start mysql
$ sudo grep 'temporary password' /var/log/mysqld.log
$ mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Passw0rd!';
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 8 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | MEDIUM |
| validate_password.special_char_count | 1 |
+--------------------------------------+--------+
mysql> SET GLOBAL validate_password.special_char_count = 0;
mysql> SET GLOBAL validate_password.mixed_case_count = 0;
mysql> SET GLOBAL validate_password.policy = 0;
mysql> SET GLOBAL validate_password.number_count = 0;
mysql> SET GLOBAL validate_password.length = 0;
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 0 |
| validate_password.mixed_case_count | 0 |
| validate_password.number_count | 0 |
| validate_password.policy | LOW |
| validate_password.special_char_count | 0 |
+--------------------------------------+-------+
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '';
Thanks a lot! I was getting into some errors regarding permissions but this one helped me out.