I'm currently working with mariadb and phpmyadmin on my debian 10 server. For some reason mariadb only allows passwords with a maximum length of 79 characters. If I specify a password that is longer than 79 characters I can easily login to phpmyadmin over the loginpage. But when I try to login to mariadb over the command prompt with the same password I get the error response: "ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)". Is there a way to enable longer passwords?
Thanks for your time and help.