{"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-root-password-zapomniane","status":"publish","type":"post","link":"https:\/\/webhosting.de\/pl\/mariadb-mysql-root-passwort-vergessen\/","title":{"rendered":"MariaDB \/ Root MySQL Zapomniane has\u0142o"},"content":{"rendered":"

Znowu zgubi\u0142e\u015b swoj\u0105 list\u0119 hase\u0142? Dane do logowania g\u0142\u00f3wnych u\u017cytkownik\u00f3w s\u0105 szybko tracone i nie s\u0105 zapisywane w samym systemie.
\nNa pewno \u0142atwiej jest z bazami danych, z kt\u00f3rych korzystaj\u0105 Tre\u015b\u0107<\/a> Systemy zarz\u0105dzania, tutaj has\u0142o jest zapisywane w postaci zwyk\u0142ego tekstu w odpowiednich plikach konfiguracyjnych. Nie ma to miejsca w przypadku g\u0142\u00f3wnego u\u017cytkownika serwera bazy danych.
\nZazwyczaj nazwa u\u017cytkownika to root. Na stronie Plesk<\/a> instalacji u\u017cywa si\u0119 nazwy u\u017cytkownika \"admin\". Has\u0142o serwera Plesk mo\u017ce by\u0107 \u0142atwo pobrane z pliku .psa\/shadow. Na przyk\u0142ad: za pomoc\u0105 polecenia:<\/p>\n

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

Je\u015bli musisz ca\u0142kowicie zresetowa\u0107 has\u0142o, po prostu wykonaj poni\u017csze kroki.<\/p>\n

Wyj\u015bcie z serwera bazy danych. Np. pod Centos7 z MariaDB z <\/p>\n

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

Je\u015bli u\u017cywasz innego serwera bazy danych, mo\u017cna to zrobi\u0107 r\u00f3wnie\u017c za pomoc\u0105<\/p>\n

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

MariaDB \/ root MySQL Zmiana has\u0142a<\/h2>\n

Teraz uruchamiamy serwer bazy danych bez ogranicze\u0144 i zarz\u0105dzania prawami, tak aby mo\u017cna by\u0142o zarz\u0105dza\u0107 nim bez has\u0142a. W tym celu u\u017cywamy opcji -skip-grant-tables, kt\u00f3ra usuwa ograniczenia, oraz -skip-networking, kt\u00f3ry uniemo\u017cliwia dost\u0119p z zewn\u0105trz podczas konfiguracji.<\/p>\n

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

Teraz mo\u017cesz \u0142atwo zmieni\u0107 has\u0142o MySQL.<\/p>\n

mysql -u root
\nmysql> use mysql;
\nmysql> update user set password=PASSWORD(\"the_desired_password\") where User='root';
\nmysql> flush privileges;
\nmysql> exit<\/code><\/p>\n

Teraz has\u0142o zosta\u0142o zmienione i serwer bazy danych mo\u017ce zosta\u0107 zako\u0144czony.<\/p>\n

zamykanie mysqladminu<\/code><\/p>\n

\u017beby potem mo\u017cna by\u0142o zaczyna\u0107 normalnie.<\/p>\n

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

Dalsze informacje mo\u017cna oczywi\u015bcie znale\u017a\u0107 r\u00f3wnie\u017c w podr\u0119czniku producenta na stronie 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\/pl\/wp-json\/wp\/v2\/posts\/4132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/comments?post=4132"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/posts\/4132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/media?parent=4132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/categories?post=4132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/tags?post=4132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}