Getting Mysqli prepare error: Access denied for user '****' to database '*****' - in plugin Goals error message

#1

Just recently I have started to get the following error message:

Mysqli prepare error: Access denied for user ‘****’ to database ‘*****’ - in plugin Goals

I can now only use Matomo if I have the Goals plug-in deactivated, what can be done to solve this problem?

#2

Hi,

This is most likely the same as

#3

That doesn’t answer the question of how to fix the problem.

#4

Your MySQL user needs the permission to CREATE TEMPORARY TABLES. So change your MySQL user to grant them the access.

(sorry, the error message is not helpful in this case)

#5

But the MySQL user does have the permission to CREATE TEMPORARY TABLES so it must be something else?

#6

After a lot of faffing about, I found that changing the php level from 7.3 to 7.1 it started to work again, I have no idea why this is, but at least it now works.

#7

Hi,

There are a lot of people reporting more database issue after updating to PHP 7.2 or later.

One possible solution is to check in config/config.ini.php if MYSQLI is used as an adapter and if so, comment that line out so that the default of PDO is used instead.

#8

That seems to have solved the problem, thanks

1 Like