We can change Mysql timezone by using CONVERT_TZ function.
You have to use below SQL command to change timezone
SELECT CONVERT_TZ( NOW(),'current-time-zone','changed-time-zone' );
If you want to change your timezone to USA new York, you can run below command.
SELECT CONVERT_TZ(...