SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SESSION
is optional, just limits the setting to the current session.
READ UNCOMMITTED
is to be replaced with your desired level.
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html