Howdy.
I’m attempting to change a database user password.
The navigation I’m using is webmin → Servers → MySQL Database Server → User Permissions → (select user) → Password -Set to → t7Lj5gmghFPqHCK → Save.
I’ll use a different password going forward, but shown here just in case its invalid.
The error message I get is:
Failed to save user : SQL alter user ‘tbh_user’@‘%’ identified with mysql_native_password by ‘t7Lj5gmghFPqHCK’ failed : 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 ‘t7Lj5gmghFPqHCK’’ at line 1
I tried deleting the user on the same page/navigation and got this error:
Failed to save user : SQL create user ‘tbh_user’@‘%’ identified by ‘t7Lj5gmghFPqHCK’ failed : Operation CREATE USER failed for ‘tbh_user’@‘%’
I don’t ask a lot of questions here so please feel free to critique my post ( wrong forum, wrong product, not enough details, etc) - Move post if necessary -Thank you
I’m switching hosts tomorrow and was not expecting this roadblock.
| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu Linux 24.04.2 |
| Webmin version | 2.303 |
| Usermin version | 2.203 |