{"id":492,"date":"2022-07-08T13:28:49","date_gmt":"2022-07-08T16:28:49","guid":{"rendered":"https:\/\/xaxowareti.com.br\/?p=492"},"modified":"2022-07-08T13:28:49","modified_gmt":"2022-07-08T16:28:49","slug":"alterar-o-horario-do-mysql","status":"publish","type":"post","link":"https:\/\/xaxowareti.com.br\/?p=492","title":{"rendered":"Alterar o hor\u00e1rio do MYSQL"},"content":{"rendered":"\n<p>Se voc\u00ea estiver com problema no&nbsp;hor\u00e1rio do banco de dados do&nbsp;<strong>mysql&nbsp;<\/strong>mesmo que o&nbsp;hor\u00e1rio do servidor linux esteja correto e o timezone correto.<\/p>\n\n\n\n<p>Fa\u00e7a desta forma que resolve o problema.<\/p>\n\n\n\n<p>Execute o comando na console do&nbsp;<strong>Mysql<\/strong>: &nbsp; &nbsp;&nbsp;<strong>SET GLOBAL time_zone = &#8216;-03:00&#8217;;<\/strong>&nbsp;&nbsp; &nbsp; &nbsp; (Fuso de&nbsp;S\u00e3o Paulo)<\/p>\n\n\n\n<p>Para confirma se hor\u00e1rio esta correto, execute: \u00a0 \u00a0<strong>select now();<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/xaxowareti.com.br\/wp-content\/uploads\/2022\/07\/image.png\" alt=\"\" class=\"wp-image-493\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Se voc\u00ea estiver com problema no&nbsp;hor\u00e1rio do banco de dados do&nbsp;mysql&nbsp;mesmo que o&nbsp;hor\u00e1rio do servidor linux esteja correto e o timezone correto. Fa\u00e7a desta forma que resolve o problema. Execute o comando na console do&nbsp;Mysql: &nbsp; &nbsp;&nbsp;SET GLOBAL time_zone = &#8216;-03:00&#8217;;&nbsp;&nbsp; &nbsp; &nbsp; (Fuso de&nbsp;S\u00e3o Paulo) Para confirma se hor\u00e1rio esta correto, execute: \u00a0 \u00a0select [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-492","post","type-post","status-publish","format-standard","hentry","category-sem-categoria"],"_links":{"self":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=492"}],"version-history":[{"count":0,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/492\/revisions"}],"wp:attachment":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}