PHP PDO broken because of mysql init_connect

Asked Oct 28 '20 at 19:42

Active Oct 28 '20 at 19:50

Viewed 45 times

I have a small PDO script that asks the server for information in a tabel. I tought loggin the connections was a good idea and added:

SET GLOBAL init_connect = "INSERT INTO admin.connections (connect_time, user, connection_id) VALUES (NOW(), CURRENT_USER(), CONNECTION_ID());";

All the permissions should be good on mysql, tough when i execute that command the webpage returns a 500 error, if i remove it everything works perfectly.

asked Oct 28 '20 at 19:42

hansi132

1

Please add the PHP you are using. If the issue is present outside of PHP then PHP is irrelevant. – user3783243 Oct 28 '20 at 19:44
1

try to read your log files – Lukas Mittun Alexander Guldstv Oct 28 '20 at 19:50

PHP PDO broken because of mysql init_connect

0 Answers0