Fanfurlio

Yes, I can login from the command line client using those credentials.

You're spot on, if I try to execute the same query from the command line client, I get the same error: MariaDB [(none)]> CREATE USER 'froxlor'@'localhost' IDENTIFIED WITH mysql_native_password BY 'random_garbage'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY 'random_garbage'' at line 1 The only way I can create an user on the CentOS standard MariaDB installation using old mysql SHA1 passwords is MariaDB [(none)]> CREATE USER 'froxlor'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('random_garbage'); Query OK, 0 rows affected (0.003 sec) From here, what should I change in my configuration to allow Froxlor to create its user? I tried setting old_passwords (both ways, also the default is 0), but that does not change anything. EDIT: Just out of curiosity, is there a specific reason behind forcing mysql_native_passwords instead of using the DB server's default?

On an already existing server, CentOS 7 with PHP-FPM 8.0.16 and MariaDB 10.5.15 Downloaded latest Froxlor stable, following the documentation, and set up a virtualhost for it. I start the setup process, all requirements check are green, then I insert a DB user and password for the "new" froxlor user, then I my (almost plaintext, no strange characters) MariaDB root password, and when clicking the continue button, I receive a blank page, and in the PHP-FPM log I have: PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY '[MY_FROXLOR_DBUSER_PASSWORD]'' at line 1 in /var/www/froxlor/install/lib/class.FroxlorInstall.php:744 Is it a problem with the MariaDB version or something else? I also tried to manually create the user, but there's no way to tell the installer that it already exists.