Change mysql root password

UPDATE mysql.user SET Password=PASSWORD('axismobile') WHERE User='root';

FLUSH PRIVILEGES;

Updating mysql isolation level

There are many ways to do that, one of them is:

mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
mysql> SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
mysql> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
verify that it got updated:
mysql> SELECT @@tx_isolation;
mysql> SELECT @@global.tx_isolation;

This will update mysql isolation level to be READ COMMITTED

Starting up mysql on windows in non service mode

mysqld --console