Server restore failed

Help! (Home for newbies)
1
SYSTEM INFORMATION
Ubuntu Server 22.04.2 REQUIRED
Virtualmin version 7.7 REQUIRED

Virtual server Restore failed from backup because MySQL password policy.

Fatal Error!
Restore failed : SQL alter user 'example'@'localhost' identified with caching_sha2_password by 'password' failed : Your password does not satisfy the current policy requirements

Please help I am stuck

2

restoring what from where to where?

3

Sorry. I am restoring to a new computer from my old computer. I have Virtualmin installed on the new computer
I used Backup Virtual Servers then used Restore Virtual server from tar.gz
Thanks

4

I’ve seen this issue defore. Google the issue and found this.

https://dev.mysql.com/doc/refman/5.7/en/validate-password-installation.html

5

Cool. Thanks for the help. I will update you on my progress

6

I just did a fresh install just to check, by default the validate password is not installed.
found this also
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html

maybe that was enabled on old server?

And I backed up a Virtual Server (Rocky9) and restored to the test machine (ubuntu 22.04) no issue, it had a wordpress website, no errors.

7

I too have a Wordpress virtual server I am hoping I can restore
Thanks again.

8

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.