Table prefix is a string of alphanumeric characters prefixed to the name of the tables. XenForo developers have decided against the use of customizable table prefix and have hardcoded it as xf_.
An unexpected shut down of MySQL due to memory and xf_session table being frequently written is likely to crash and is the root cause of the issue.
CPanel and Plesk provide an easy to use front end option to create databases, create users and assign correct permissions to be able to use in XenForo.
A detailed guide with screenshots for each step of the installation process of XenForo 2. It assumes you know how to upload content to the server via FTP using software like FileZilla.
The complete step by step guide with pictures of every step to help install XenForo locally on localhost running on XAMPP.