I am trying to experiment a bit with the isolation level of MySQL in a test environment.
I do the following:
mysql> set @@session.tx_isolation='READ-UNCOMMITED'; ERROR 1231 (42000): Variable 'tx_isolation' can't be set to the value of 'READ-UNCOMMITED'
This also fails:
mysql> update information_schema.session_variables set variable_value='READ-UNCOMMITED' where variable_name='TX_ISOLATION'; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'
What am I doing wrong here? I am root. So it should not be a rights issue.