Resetting WordPress user passwords in the database

After restoring a backup mysqldump file from one server to another, I found that my WordPress user passwords were no longer working correctly, despite knowing I was using the correct password. Apparently because WordPress hashes passwords with md5 in the user table, it could be that attempting logon on another server the md5 hash was computing differently.\, The simple fix was to reset passwords in the wp_users table with a new hash, using:

update wp_users set user_pass = md5('NEW_PASSWORD') where user_login = 'USER-TO-UPDATE';

Terraform error provisioning new VMs on Hetzner: error during placement (resource_unavailable)

I’ve been moving to use Terraform to provision VMs on Hetzner, and recently while adding a minor change and doing a ‘terraform apply’ I got this error:

Error: error during placement (resource_unavailable, ...

I hadn’t seen this before, but according to this post, ‘resource_unavailable’ means that Hetzner are unable to provision a new VM of the selected type (I’m using cx22), and may be a temporary issue, or maybe changing the location to one of their other locations may work.

Re-running a few minutes later and the provisioning was successful.