Moving sites with AWStats from DirectAdmin to Virtualmin

Ok, step by step. I changed the DNS back to the old server to let the website up. Used the hosts file to point to the virtualmin server.

  • White screen. The PHP logs and a search on the internet taught me that there was a line with auto_prepend_file in the user.ini that pointed to a wordfence-waf.php file that needed commenting out.
  • Switched to debug mode in wordpress.
  • Next challange; user denied for database connectoin.

The error:
Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘xxxxxx_wp2’@‘localhost’ (using password: YES) in /home/xxxxxx/public_html/wp-includes/class-wpdb.php on line 1982

Access denied for user 'xxxxxxxx_wp2'@'localhost' (using password: YES)

(names have been changed by xxxxx).

When editing users. I noticed the user xxxxx_wp2 has nothing in the field ‘Database granted access to’. So I thought I 'll grant this users access to the xxxxx_wp2 databse only to find out it wants me to change the password. I wouldn’t have a clue what the original password once was. So I really hope this isn’t necessarry. Doesn’t make sense either.

Or am I overlooking somehting entirely different?