{"id":41885,"date":"2017-04-19T00:00:00","date_gmt":"2017-04-18T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm"},"modified":"2020-02-18T13:44:38","modified_gmt":"2020-02-18T10:44:38","slug":"kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","status":"publish","type":"post","link":"https:\/\/prohoster.info\/pt\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"Como redefinir a senha do painel administrativo do WordPress atrav\u00e9s do phpMyAdmin na hospedagem?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Para que voc\u00ea redefina sua senha atrav\u00e9s phpMyAdmin<\/strong>? \u0421\u0438\u0442\u0443\u0430\u0446\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043c\u043d\u043e\u0433\u043e — \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u044d\u0442\u043e\u0442 \u043f\u0430\u0440\u043e\u043b\u044c \u0438 \u043f\u043e \u043a\u0430\u043a\u0438\u043c-\u0442\u043e \u043f\u0440\u0438\u0447\u0438\u043d\u0430\u043c \u043d\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0441\u043f\u043e\u043c\u043d\u0438\u0442\u044c \u0447\u0435\u0440\u0435\u0437 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u0443\u044e \u043f\u043e\u0447\u0442\u0443, \u0412\u0430\u0441 \u043f\u043e\u0447\u0435\u043c\u0443-\u0442\u043e \u043d\u0435 \u043f\u0443\u0441\u043a\u0430\u044e\u0442 \u0432 \u0430\u0434\u043c\u0438\u043d\u043a\u0443, \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u043e\u0442 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u043e\u0439 \u043f\u043e\u0447\u0442\u044b \u0438\u043b\u0438 \u044d\u0442\u0438\u043c \u044f\u0449\u0438\u043a\u043e\u043c \u0443\u0436\u0435 \u043d\u0435 \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c, \u0412\u0430\u0448 \u0431\u043b\u043e\u0433 \u043f\u0440\u043e\u0441\u0442\u043e \u0441\u043b\u043e\u043c\u0430\u043b\u0438 \u0438 \u0438\u0437\u043c\u0435\u043d\u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c (\u043d\u0435 \u0434\u0430\u0439 \u0411\u043e\u0433) \u0438 \u0442.\u0434. \u0421\u0430\u043c\u044b\u043c \u043f\u0440\u043e\u0441\u0442\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u0435\u043c \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0431\u0440\u043e\u0441 \u043f\u0430\u0440\u043e\u043b\u044f \u0447\u0435\u0440\u0435\u0437 phpMyAdmin<\/strong> na hospedagem web.<\/p>\n

Recentemente, trabalhei com um blog que exigia interven\u00e7\u00e3o direta no banco de dados e redefini\u00e7\u00e3o de senha, ent\u00e3o decidi escrever este post para que, caso necess\u00e1rio, voc\u00ea tenha um guia sobre \u2018Como redefinir a senha do admin do WordPress atrav\u00e9s de phpMyAdmin<\/strong> na hospedagem.'<\/p>\n

Ent\u00e3o, em qualquer caso, o acesso \u00e0 hospedagem em painel de controle<\/a> Seu site (sites) permanece com voc\u00ea e isso \u00e9 suficiente para n\u00f3s. Dependendo do provedor de hospedagem que voc\u00ea utiliza, o tipo e a apar\u00eancia do painel de controle do site podem variar, mas em cada um desses pain\u00e9is h\u00e1 a op\u00e7\u00e3o 'phpMyAdmin', \u00e9 a\u00ed que voc\u00ea deve procurar.\"\"<\/p>\n

O phpMyAdmin pode estar oculto, por exemplo, localizado em um submenu \u2018Gerenciamento de bancos de dados<\/strong>'' portanto, examine bem o painel de controle e encontre esse aplicativo. Encontrou? Agora vamos para o phpMyAdmin. Voc\u00ea ver\u00e1 a seguinte tela:<\/p>\n

\"\"<\/p>\n

Aqui temos a oportunidade de fazer tudo o que precisamos com nossos bancos de dados, gerenci\u00e1-los completamente. Agora precisamos encontrar o banco de dados relacionado ao nosso blog. Se voc\u00ea n\u00e3o se lembra qual banco de dados da lista (pode haver v\u00e1rios \u00e0 esquerda) \u00e9 o seu recurso, basta olhar o arquivo wp-config.php; todos esses dados est\u00e3o l\u00e1.<\/p>\n

\"\"<\/p>\n

Encontre nesta se\u00e7\u00e3o a linha:<\/p>\n

define('DB_NAME', 'Nome do seu banco de dados')<\/strong>;<\/p>\n

E escolha exatamente este banco de dados no phpMyAdmin.<\/p>\n

Clique neste banco de dados e toda a estrutura, todas as tabelas que podemos modificar ser\u00e3o exibidas. Agora, temos interesse na tabelawp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

Nesta tabela, est\u00e3o registrados todos os usu\u00e1rios (caso existam v\u00e1rios) que t\u00eam acesso \u00e0 administra\u00e7\u00e3o do blog. \u00c9 aqui que poderemos alterar a senha ou remover um usu\u00e1rio espec\u00edfico \u2014 clique em wp_users e ser\u00e1 exibido o conte\u00fado de toda a tabela.
\nAqui precisamos editar a senha. No caso do blog com o qual trabalhei, era vis\u00edvel que, al\u00e9m do administrador, havia outro usu\u00e1rio registrado, e o propriet\u00e1rio me informou que deveria haver apenas um usu\u00e1rio. Isso significa que algu\u00e9m mais j\u00e1 estava por l\u00e1.
\nNa tabela, precisamos clicar no l\u00e1pis 'Editar' ao lado do nome do usu\u00e1rio e modificar a senha.<\/p>\n

\"\"<\/p>\n

A estrutura desta tabela ser\u00e1 exibida, onde veremos todos os dados relacionados a esse usu\u00e1rio. N\u00e3o vou entrar em detalhes sobre cada campo \u2014 apenas explicarei como redefinir a senha.<\/p>\n

\"\"<\/p>\n

Atualmente, a senha est\u00e1 criptografada pelo m\u00e9todo MD5, ent\u00e3o, na linha correspondente, vemos caracteres incompreens\u00edveis.<\/p>\n

\"\"<\/p>\n

Para mudar senha<\/strong> \u2014 fa\u00e7a o seguinte: na linha user_pass<\/strong> no campo senha, digitamos a nova senha, e no campo varchar (64)<\/strong> \u2014 escolha o m\u00e9todo de criptografia MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Fizemos as altera\u00e7\u00f5es e clicamos no bot\u00e3o \u201cAvan\u00e7ar<\/strong>\u201d na parte inferior e salvamos a nova senha<\/strong>.<\/p>\n

\"\"<\/p>\n

Ap\u00f3s salvar todas as altera\u00e7\u00f5es \u2014 a senha que voc\u00ea digitou se tornar\u00e1 novamente em MD5, mas ser\u00e1 exatamente como voc\u00ea precisa. Agora, acesse a \u00e1rea administrativa do blog com a nova senha.<\/p>\n

Dica.<\/em> NUNCA<\/strong> use login admin<\/strong> e senhas simples \u2014 isso ir\u00e1 proteg\u00ea-lo de consequ\u00eancias desagrad\u00e1veis devido ao hackeamento do seu recurso. Altere seus dados de acesso para algo mais complexo e 'estranho'.<\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0414\u043b\u044f \u0447\u0435\u0433\u043e \u0441\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin? \u0421\u0438\u0442\u0443\u0430\u0446\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043c\u043d\u043e\u0433\u043e — \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u044d\u0442\u043e\u0442 \u043f\u0430\u0440\u043e\u043b\u044c \u0438 \u043f\u043e \u043a\u0430\u043a\u0438\u043c-\u0442\u043e \u043f\u0440\u0438\u0447\u0438\u043d\u0430\u043c \u043d\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0441\u043f\u043e\u043c\u043d\u0438\u0442\u044c \u0447\u0435\u0440\u0435\u0437 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u0443\u044e \u043f\u043e\u0447\u0442\u0443, \u0412\u0430\u0441 \u043f\u043e\u0447\u0435\u043c\u0443-\u0442\u043e \u043d\u0435 \u043f\u0443\u0441\u043a\u0430\u044e\u0442 \u0432 \u0430\u0434\u043c\u0438\u043d\u043a\u0443, \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u043e\u0442 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u043e\u0439 \u043f\u043e\u0447\u0442\u044b \u0438\u043b\u0438 \u044d\u0442\u0438\u043c \u044f\u0449\u0438\u043a\u043e\u043c \u0443\u0436\u0435 \u043d\u0435 \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c, \u0412\u0430\u0448 \u0431\u043b\u043e\u0433 \u043f\u0440\u043e\u0441\u0442\u043e \u0441\u043b\u043e\u043c\u0430\u043b\u0438 \u0438 \u0438\u0437\u043c\u0435\u043d\u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c (\u043d\u0435 \u0434\u0430\u0439 \u0411\u043e\u0433) \u0438 \u0442.\u0434. […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[682],"tags":[],"class_list":["post-41885","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-raznoe"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Redefinindo a senha atrav\u00e9s do phpMyAdmin para os pain\u00e9is do WordPress | ProHoster","description":"Para que redefinir a senha atrav\u00e9s do phpMyAdmin?","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47 \u0421\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0435\u043c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin \u0434\u043b\u044f \u0430\u0434\u043c\u0438\u043d\u043a\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 WordPress | ProHoster","og:description":"\u0414\u043b\u044f \u0447\u0435\u0433\u043e \u0441\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin?","og:url":"https:\/\/prohoster.info\/pt\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2017-04-18T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:38+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"41885","title":"\ud83e\udd47 Redefini\u00e7\u00e3o de senha via phpMyAdmin para o painel de administra\u00e7\u00e3o de sites WordPress | #site_title","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-08 19:54:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:40:48","updated":"2026-02-08 19:54:20","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}