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

[Kim]

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?

[Lukas (Lukas Winkler)]

Hi,

This is most likely the same as

Mysqli prepare error: Access denied -- for goals plugin only

Matomo seems to work fine. Except that the widget titled “Visits Over Time” shows no data, but instead a red box with “Mysqli prepare error: Access denied for user ‘yvhu3nejs9HtWp4I’@‘localhost’ to database ‘pdrbshnqdqdwswtm’” (disregard the strange database names – they are auto-generated). If I disable the goals plugin, everything seems to be fine. I can log into mariadb from the terminal with the data provided in the config file. I looked into the mariadb query log, but I cannot see a conn…

[Kim]

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

[Lukas (Lukas Winkler)]

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)

[Kim]

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

[Kim]

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.

[Lukas (Lukas Winkler)]

Hi,

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

"MySQL has gone away" more common with PHP 7.2+

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.

[Kim]

That seems to have solved the problem, thanks

[Practice_for_one]

I’m also facing the access problem in my database. You can see here the data of my website.

[Zayee_Alen]

This post was flagged by the community and is temporarily hidden.

[Farel_Moksi]

yes iam facing the same issue but cant find the real solution from anywhere even on youtube there is no single tutorial about it i need help from you guy if anyone know about it.