Installation server error


Step 2 of the installation process is giving me the following error:
Mysqli prepare error: CREATE command denied to user 'XXX'@'localhost' for table 'xf_addon'
  1. Zend_Db_Statement_Mysqli->_prepare() in /hsphere/local/home/XXX/ line 115
  2. Zend_Db_Statement->__construct() in /hsphere/local/home/XXX/ line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in/hsphere/local/home/XXX/ at line 478
  4. Zend_Db_Adapter_Abstract->query() in/hsphere/local/home/XXX/ at line 174
  5. XenForo_Install_Model_Install->createApplicationTables() in/hsphere/local/home/XXX/ at line 196
  6. XenForo_Install_Controller_Install->actionStep2() in/hsphere/local/home/XXX/ at line 310
  7. XenForo_FrontController->dispatch() in/hsphere/local/home/XXX/ at line 132
  8. XenForo_FrontController->run() in /hsphere/local/home/XXX/ at line 17
I have the database name and username/password entered correctly.


XenForo moderator
Staff member
This is the first table so it indicates that the DB user doesn't have the correct permissions.

Check that the DB user has all privileges, including create.


Yeah, I wasn't seeing that. I told it to read and write but there was another privilege page with a list of things and most were not ticked.