Rename wordpress database prefix (https://iandunn.name/2016/07/21/rename-wordpress-database-prefix-with-w…)
Check users: wp user list
Reset password: wp user update USERNAME --user_pass="PASSWORD" (https://developer.wordpress.org/cli/commands/user/reset-password/)
Updating admin user e-mail, when you only have MySQL command line access: UPDATE `wp_users` SET `user_email` = 'INSERT_MAIL' WHERE `ID` = '1';
generate wordpress password for insertion in database: echo -n "password" | md5sum
If you are unable to post in Wordpress, you might want to add this to your wp-config.php: define( ‘WP_MEMORY_LIMIT’, ‘256M’ );
Also install classic editor and disable Wordfence completely (look in .htacces) and remove or rename .user.ini
There are many backup solutions out there for wordpress sites.
For example these plugins:
UpdraftPlus can be connected with dropbox.
Jetpack
backWPup
Among others.
You might also want to build your own backup routine with cronjobs on the hosting server.
Remember to backup!
