Kim
(Kim)
April 3, 2020, 1:09pm
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?
Lukas
(Lukas Winkler)
April 3, 2020, 2:30pm
2
Hi,
This is most likely the same as
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
(Kim)
April 3, 2020, 4:53pm
3
That doesn’t answer the question of how to fix the problem.
Lukas
(Lukas Winkler)
April 3, 2020, 5:18pm
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)
Kim
(Kim)
May 11, 2020, 8:15pm
5
But the MySQL user does have the permission to CREATE TEMPORARY TABLES
so it must be something else?
Kim
(Kim)
May 13, 2020, 12:53pm
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.
Lukas
(Lukas Winkler)
May 14, 2020, 9:59am
7
Hi,
There are a lot of people reporting more database issue after updating to PHP 7.2 or later.
opened 08:17AM - 24 Jan 20 UTC
c: Performance
Can't reproduce (yet)
Hi,
I've setup quite a few matomo instances at our hosting company and have n… oticed that as soon as we upgrade a customers PHP to 7.2 or above, the matomo instance starts showing lots of "MySQL has gone away" errors and performance goes down.
As soon as we downgrade back to 7.1 these errors go away and the system functions and performs fine. With PHP 7.1 being end of life, it would probably be a good idea looking to support the newer versions and ensuring performance is on par or better, and that errors like the above don't appear.
I'm a PHP developer myself so happy to work with you guys and provide a test environment to help debug and fix.
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
(Kim)
May 16, 2020, 10:28am
8
That seems to have solved the problem, thanks
1 Like
I’m also facing the access problem in my database. You can see here the data of my website.
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.