When I try to install XenForo on my host after created the DB and user, I receive this error:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
My previous workaround was to add this to .htaccess in the root of the forum software:
AddHandler application/x-httpd-php52 .php5 .php4 .php .php3 .php2 .phtml AddType application/x-httpd-php52 .php5 .php4 .php .php3 .php2 .phtml
The support department for the host asked for the connection string or PHP file I'm using but I've very new to XenForo (1 day) so I'm completely unfamiliar with the code base and what to provide them. I rather like the host, they've been doing quite well for me over the years and they're decently priced but if I need to move to another host I will do so, especially as my new sites I'll be using PHP 5.3+ functions.