| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu 22.04 |
| Webmin version | 2.021 |
| Virtualmin version | 7.7 GPL |
| Related packages | backup restore |
There is a small bug when restoring a virtual server from a backup archive, any additional ftp users loose their database access rights.
Editing the users shows that in their “Other user permissions” the database access is no longer granted access to.
Here is the list of “other user permissions” in the original installation:
After restoring the virtual server on the new installtion it no longer lists the MySQL user name:
If I then click on a database to grant its access and click on “save”, there is an error message:
If I follow the message and change the password at the same time, there is another error that the database user name already exists.
If I enter the MySQL command in terminal, the user is listed with “SELECT user FROM mysql.user”
But if I try to grant him access to a database, there is an error that a user cannot be created with the GRANT command.
Trying then to create the same user doesn’t work directly either, so the user first has to be dropped, then recreated (with the original password), and finally can be granted access.
So the upshot seems to be that in the restore the user is entered as a MySQL user but incompletely and has lost his grants.