Generally, there is a big problem with installing MariaDB from version 10.7 and above... only manual compilation brings good results. With the "fast" installation method, there is a feedback message in Chinese(?) that MariaDB is not compatible with Ubuntu 22 LTS and 24 LTS (tested on ARM64 and x86). During manual compilation and attempting to change the root password, there is an error message:
ERROR 1348 (HY000) at line 1: Column 'Password' is not updatable
Of course, changing the password via the panel > database does not have any effect.
The problem lies in the query, which is simply different in newer versions of MariaDB.