Set time zone in mysql

To set Time zone in GMT set time_zone is used with specified time_zone value

      SET time_zone='+00:00';

1	SET time_zone='+00:00';

To check our change reflated on database use following query

       SELECT @@global.time_zone, @@session.time_zone;

1	SELECT @@global.time_zone, @@session.time_zone;

+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM             | +00:00              |
+--------------------+---------------------+
1 row in set (0.00 sec)

+--------------------+---------------------+

| @@global.time_zone | @@session.time_zone |

+--------------------+---------------------+

| SYSTEM | +00:00 |

+--------------------+---------------------+

1 row in set (0.00 sec)

Setting innodb_lock_wait_timeout
Granting Privileges to users
Show engine innodb status
Finding all column name of table

Read More