HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Installation problem - cannot access database


#1

Before installing Helpspot, I created a MySQL db and a user with permissions to create tables. Then modified config.php accordingly. The installation starts & all the initial checks are OK, including ‘can connect to database’. When I click ‘Finish Installation’, I’m presented with a blank screen with a message ‘Cannot access database. If this is a new installation please go to the installer page.’ My database now has helpspot tables, so the problem does not seem to be permissions.

Any help will be appreciated.


#2

How many tables are created? Make sure you allow all permissions on the database not just create.


#3

Ian, 19 of the 36 tables were created. I have managed to work around the issue by doing a local install (which worked fine), scripting the local tables and importing these to the database on the live site.


#4

Hmm ok just keep an eye on it. Also if you’ve set the database as mysqli change it to just mysql.