I have an Server where I want to activate the Database (MYSQL). If I tick the checkbox end execute the create-process, I got an error like this:
Creating MySQL login ..
.. MySQL database failed! : mysql::execute_sql_logged failed : SQL update user set authentication_string = password(‘’) where user = ‘xyz_Admin’ and host = ‘localhost’ failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(’‘) where user = ‘xyz_Admin’ and host = ‘localhost’’ at line 1
I’m not sure to understand, with pictures it might be easier. But checking here:
The password function have been deprecated in 5.7 and then removed in MySQL 8.0 (You indicated ubuntu 22.04 so it shall be >8.0). So maybe it simply doesn’t recognise the function.
Then indeed the password shall, according to me too, not be empty (But it’s probably unrelated to the current problem, you would simply have an empty password for your DB, WHICH SHALL NEVER HAPPENS )
Not sure if it can help.
If you can safely (Nothing to backup or really few stuff) and easily reinstall the whole server and then Virtualmin. It might update everything correctly