{"id":4132,"date":"2020-10-30T20:49:07","date_gmt":"2020-10-30T19:49:07","guid":{"rendered":"https:\/\/webhosting.de\/?p=4132"},"modified":"2021-07-15T13:05:52","modified_gmt":"2021-07-15T12:05:52","slug":"mariadb-mysql-palavras-passe-esquecidas","status":"publish","type":"post","link":"https:\/\/webhosting.de\/pt\/mariadb-mysql-root-passwort-vergessen\/","title":{"rendered":"MariaDB \/ MySQL Root Esqueci a senha"},"content":{"rendered":"

Perdeu a sua lista de senhas novamente? Os dados de login dos usu\u00e1rios principais s\u00e3o rapidamente perdidos e n\u00e3o s\u00e3o salvos no pr\u00f3prio sistema.
\n\u00c9 certamente mais f\u00e1cil aqui com bases de dados que s\u00e3o utilizadas por Conte\u00fado<\/a> Management Systems, aqui a senha \u00e9 armazenada em texto simples nos respectivos arquivos de configura\u00e7\u00e3o. Este n\u00e3o \u00e9 o caso para o usu\u00e1rio principal do servidor de banco de dados.
\nNormalmente o nome do usu\u00e1rio \u00e9 root. Em Plesk<\/a> instala\u00e7\u00f5es \u00e9 usado o nome de usu\u00e1rio \"admin\". A senha de um servidor Plesk pode ser facilmente recuperada a partir do arquivo .psa\/shadow. Por exemplo: com o comando:<\/p>\n

mysql<\/a> -uadmin -p`cat \/etc\/psa\/.psa.shadow<\/code><\/p>\n

Se voc\u00ea precisar redefinir a senha completamente, basta seguir estes passos.<\/p>\n

Saia do servidor da base de dados. Por exemplo, em Centos7 com MariaDB com <\/p>\n

systemctl stop mariadb.service<\/code><\/p>\n

Se voc\u00ea usar outro servidor de banco de dados, isso tamb\u00e9m pode ser feito com<\/p>\n

\/etc\/init.d\/mysql stop<\/code><\/p>\n

MariaDB \/ MySQL root Alterar senha<\/h2>\n

Agora iniciamos o servidor de banco de dados sem restri\u00e7\u00f5es e gerenciamento de direitos, para que ele possa ser administrado sem senha. Para isso, usamos a op\u00e7\u00e3o -skip-grant-tables, que remove as restri\u00e7\u00f5es, e -skip-networking, que impede o acesso externo durante a configura\u00e7\u00e3o.<\/p>\n

mysqld_safe -- skip-grant-tables -- skip-networking &<\/code><\/p>\n

Agora voc\u00ea pode mudar facilmente a senha do MySQL.<\/p>\n

mysql -u root
\nmysql> use mysql;
\nmysql> update user set password=PASSWORD(\"the_desired_password\") onde User='root';
\nmysql> privil\u00e9gios de descarga;
\nmysql> sair<\/code><\/p>\n

Agora a senha \u00e9 alterada e o servidor de banco de dados pode ser encerrado.<\/p>\n

encerramento do mysqladmin<\/code><\/p>\n

Para que depois possa ser iniciado normalmente.<\/p>\n

systemctl start mariadb.service<\/code><\/p>\n

Mais informa\u00e7\u00f5es podem, naturalmente, ser encontradas no manual do fabricante em https:\/\/mariadb.com.<\/p>","protected":false},"excerpt":{"rendered":"

Haben Sie mal wieder Ihre Passwortliste verlegt? Die Logindaten von Hauptbenutzern gehen schnell mal verloren und werden auf dem System selbst nicht gespeichert. Einfacher ist es hier sicherlich bei Datenbanken die von Content Management Systemen verwendet werden, hier wird das Kennwort im Klartext in den jeweiligen Konfigurationsdateien gespeichert. Beim Hauptbenutzer des Datenbankservers ist dieses nicht […]<\/p>\n","protected":false},"author":1,"featured_media":532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","inline_featured_image":false,"footnotes":""},"categories":[780,700,781,995],"tags":[83,84,85],"class_list":["post-4132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administration-anleitungen","category-anleitungen","category-datenbanken-administration-anleitungen","category-hilfe","tag-mysql","tag-passwort-vergessen","tag-root"],"acf":[],"_wp_attached_file":null,"_wp_attachment_metadata":null,"litespeed-optimize-size":null,"litespeed-optimize-set":null,"_elementor_source_image_hash":null,"_wp_attachment_image_alt":null,"stockpack_author_name":null,"stockpack_author_url":null,"stockpack_provider":null,"stockpack_image_url":null,"stockpack_license":null,"stockpack_license_url":null,"stockpack_modification":null,"color":null,"original_id":null,"original_url":null,"original_link":null,"unsplash_location":null,"unsplash_sponsor":null,"unsplash_exif":null,"unsplash_attachment_metadata":null,"_elementor_is_screenshot":null,"surfer_file_name":null,"surfer_file_original_url":null,"envato_tk_source_kit":null,"envato_tk_source_index":null,"envato_tk_manifest":null,"envato_tk_folder_name":null,"envato_tk_builder":null,"envato_elements_download_event":null,"_menu_item_type":null,"_menu_item_menu_item_parent":null,"_menu_item_object_id":null,"_menu_item_object":null,"_menu_item_target":null,"_menu_item_classes":null,"_menu_item_xfn":null,"_menu_item_url":null,"_trp_menu_languages":null,"rank_math_primary_category":null,"rank_math_title":null,"inline_featured_image":null,"_yoast_wpseo_primary_category":null,"rank_math_schema_blogposting":null,"rank_math_schema_videoobject":null,"_oembed_049c719bc4a9f89deaead66a7da9fddc":null,"_oembed_time_049c719bc4a9f89deaead66a7da9fddc":null,"_yoast_wpseo_focuskw":"mariadb","_yoast_wpseo_linkdex":null,"_oembed_27e3473bf8bec795fbeb3a9d38489348":null,"_oembed_c3b0f6959478faf92a1f343d8f96b19e":null,"_trp_translated_slug_en_us":null,"_wp_desired_post_slug":null,"_yoast_wpseo_title":null,"tldname":null,"tldpreis":null,"tldrubrik":null,"tldpolicylink":null,"tldsize":null,"tldregistrierungsdauer":null,"tldtransfer":null,"tldwhoisprivacy":null,"tldregistrarchange":null,"tldregistrantchange":null,"tldwhoisupdate":null,"tldnameserverupdate":null,"tlddeletesofort":null,"tlddeleteexpire":null,"tldumlaute":null,"tldrestore":null,"tldsubcategory":null,"tldbildname":null,"tldbildurl":null,"tldclean":null,"tldcategory":null,"tldpolicy":null,"tldbesonderheiten":null,"tld_bedeutung":null,"_oembed_d167040d816d8f94c072940c8009f5f8":null,"_oembed_b0a0fa59ef14f8870da2c63f2027d064":null,"_oembed_4792fa4dfb2a8f09ab950a73b7f313ba":null,"_oembed_33ceb1fe54a8ab775d9410abf699878d":null,"_oembed_fd7014d14d919b45ec004937c0db9335":null,"_oembed_21a029d076783ec3e8042698c351bd7e":null,"_oembed_be5ea8a0c7b18e658f08cc571a909452":null,"_oembed_a9ca7a298b19f9b48ec5914e010294d2":null,"_oembed_f8db6b27d08a2bb1f920e7647808899a":null,"_oembed_168ebde5096e77d8a89326519af9e022":null,"_oembed_cdb76f1b345b42743edfe25481b6f98f":null,"_oembed_87b0613611ae54e86e8864265404b0a1":null,"_oembed_27aa0e5cf3f1bb4bc416a4641a5ac273":null,"_oembed_time_27aa0e5cf3f1bb4bc416a4641a5ac273":null,"_tldname":null,"_tldclean":null,"_tldpreis":null,"_tldcategory":null,"_tldsubcategory":null,"_tldpolicy":null,"_tldpolicylink":null,"_tldsize":null,"_tldregistrierungsdauer":null,"_tldtransfer":null,"_tldwhoisprivacy":null,"_tldregistrarchange":null,"_tldregistrantchange":null,"_tldwhoisupdate":null,"_tldnameserverupdate":null,"_tlddeletesofort":null,"_tlddeleteexpire":null,"_tldumlaute":null,"_tldrestore":null,"_tldbildname":null,"_tldbildurl":null,"_tld_bedeutung":null,"_tldbesonderheiten":null,"_oembed_ad96e4112edb9f8ffa35731d4098bc6b":null,"_oembed_8357e2b8a2575c74ed5978f262a10126":null,"_oembed_3d5fea5103dd0d22ec5d6a33eff7f863":null,"_eael_widget_elements":null,"_oembed_0d8a206f09633e3d62b95a15a4dd0487":null,"_oembed_time_0d8a206f09633e3d62b95a15a4dd0487":null,"_aioseo_description":null,"_eb_attr":null,"_eb_data_table":null,"_oembed_819a879e7da16dd629cfd15a97334c8a":null,"_oembed_time_819a879e7da16dd629cfd15a97334c8a":null,"_acf_changed":null,"_wpcode_auto_insert":null,"_edit_last":null,"_edit_lock":null,"_oembed_e7b913c6c84084ed9702cb4feb012ddd":null,"_oembed_bfde9e10f59a17b85fc8917fa7edf782":null,"_oembed_time_bfde9e10f59a17b85fc8917fa7edf782":null,"_oembed_03514b67990db061d7c4672de26dc514":null,"_oembed_time_03514b67990db061d7c4672de26dc514":null,"rank_math_news_sitemap_robots":"index","rank_math_robots":["index"],"_eael_post_view_count":"5327","_trp_automatically_translated_slug_ru_ru":null,"_trp_automatically_translated_slug_et":"mariadb-mysql-root-password-forgot","_trp_automatically_translated_slug_lv":"mariadb-mysql-root-password-forgotten","_trp_automatically_translated_slug_fr_fr":null,"_trp_automatically_translated_slug_en_us":null,"_wp_old_slug":null,"_trp_automatically_translated_slug_da_dk":null,"_trp_automatically_translated_slug_pl_pl":null,"_trp_automatically_translated_slug_es_es":null,"_trp_automatically_translated_slug_hu_hu":null,"_trp_automatically_translated_slug_fi":"mariadb-mysql-root-password-forgotten","_trp_automatically_translated_slug_ja":"mariadb-mysql-root-password-%e3%82%92%e5%bf%98%e3%82%8c%e3%81%9f","_trp_automatically_translated_slug_lt_lt":null,"_elementor_edit_mode":null,"_elementor_template_type":null,"_elementor_version":null,"_elementor_pro_version":null,"_wp_page_template":"default","_elementor_page_settings":null,"_elementor_data":null,"_elementor_css":null,"_elementor_conditions":null,"_happyaddons_elements_cache":null,"_oembed_75446120c39305f0da0ccd147f6de9cb":null,"_oembed_time_75446120c39305f0da0ccd147f6de9cb":null,"_oembed_3efb2c3e76a18143e7207993a2a6939a":null,"_oembed_time_3efb2c3e76a18143e7207993a2a6939a":null,"_oembed_59808117857ddf57e478a31d79f76e4d":null,"_oembed_time_59808117857ddf57e478a31d79f76e4d":null,"_oembed_965c5b49aa8d22ce37dfb3bde0268600":null,"_oembed_time_965c5b49aa8d22ce37dfb3bde0268600":null,"_oembed_81002f7ee3604f645db4ebcfd1912acf":null,"_oembed_time_81002f7ee3604f645db4ebcfd1912acf":null,"_elementor_screenshot":null,"_oembed_7ea3429961cf98fa85da9747683af827":null,"_oembed_time_7ea3429961cf98fa85da9747683af827":null,"_elementor_controls_usage":null,"_elementor_page_assets":[],"_elementor_screenshot_failed":null,"theplus_transient_widgets":["tp-video-player"],"_eael_custom_js":null,"_wp_old_date":null,"_trp_automatically_translated_slug_it_it":null,"_trp_automatically_translated_slug_pt_pt":null,"_trp_automatically_translated_slug_zh_cn":null,"_trp_automatically_translated_slug_nl_nl":null,"_trp_automatically_translated_slug_pt_br":null,"_trp_automatically_translated_slug_sv_se":null,"rank_math_analytic_object_id":"972","rank_math_internal_links_processed":null,"_trp_automatically_translated_slug_ro_ro":null,"_trp_automatically_translated_slug_sk_sk":null,"_trp_automatically_translated_slug_bg_bg":null,"_trp_automatically_translated_slug_sl_si":null,"litespeed_vpi_list":["webhostinglogo.png"],"litespeed_vpi_list_mobile":["webhostinglogo.png"],"rank_math_seo_score":null,"rank_math_contentai_score":null,"ilj_limitincominglinks":null,"ilj_maxincominglinks":null,"ilj_limitoutgoinglinks":null,"ilj_maxoutgoinglinks":null,"ilj_limitlinksperparagraph":null,"ilj_linksperparagraph":null,"ilj_blacklistdefinition":null,"ilj_linkdefinition":["mariadb \/ mysql root passwort vergessen","mariadb"],"_eb_reusable_block_ids":null,"rank_math_focus_keyword":"mariadb","rank_math_og_content_image":null,"_yoast_wpseo_metadesc":"Datenbank Logindaten vergessen? Kein Problem. So setzen Sie ein neues Datenbankpasswort f\u00fcr den root Benutzer.","_yoast_wpseo_content_score":null,"_yoast_wpseo_focuskeywords":null,"_yoast_wpseo_keywordsynonyms":null,"_yoast_wpseo_estimated-reading-time-minutes":null,"rank_math_description":"Datenbank Logindaten vergessen? Kein Problem. So setzen Sie ein neues Datenbankpasswort f\u00fcr den root Benutzer.","surfer_last_post_update":null,"surfer_last_post_update_direction":null,"surfer_keywords":null,"surfer_location":null,"surfer_draft_id":null,"surfer_permalink_hash":null,"surfer_scrape_ready":null,"_thumbnail_id":"532","footnotes":null,"_links":{"self":[{"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/posts\/4132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/comments?post=4132"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/posts\/4132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/media?parent=4132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/categories?post=4132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/pt\/wp-json\/wp\/v2\/tags?post=4132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}