{"id":4398,"date":"2020-10-30T23:33:35","date_gmt":"2020-10-30T22:33:35","guid":{"rendered":"https:\/\/webhosting.de\/?p=4398"},"modified":"2021-07-15T13:04:59","modified_gmt":"2021-07-15T12:04:59","slug":"zmiany-hasla-roota-mariadb","status":"publish","type":"post","link":"https:\/\/webhosting.de\/pl\/mariadb-root-passwort-aendern\/","title":{"rendered":"mariadb root change password"},"content":{"rendered":"

Linux MariaDB<\/a> Korzenie<\/p>\n

Has\u0142o roota mariadb nie jest teraz dost\u0119pne, czy te\u017c zosta\u0142o zapomniane? Nawet je\u015bli has\u0142o nie jest wystarczaj\u0105co bezpieczne i chcesz je zmieni\u0107, nie powinno by\u0107 \u017cadnych problem\u00f3w. Has\u0142o mo\u017ce by\u0107 \u0142atwo zresetowane, zmienione lub przywr\u00f3cone. Rozwi\u0105zanie problem\u00f3w takich jak zmiana has\u0142a jest bardzo proste.<\/p>\n

Pod\u0105\u017canie drog\u0105 rozwi\u0105zania bez problem\u00f3w<\/p>\n

Z r\u00f3\u017cnymi dystrybucjami i serwerem MySQL mo\u017cna znale\u017a\u0107 rozwi\u0105zania. Korze\u0144 mariadbu powinien by\u0107 najpierw zako\u0144czony. Zresetowanie go b\u0119dzie dzia\u0142a\u0107 bez \u017cadnych problem\u00f3w, a nawet przybli\u017conych ogranicze\u0144. Nale\u017cy uruchomi\u0107 serwer g\u0142\u00f3wny mariadb. Nast\u0119pnie zostanie u\u017cyta opcja - skip- grant-tables i serwer g\u0142\u00f3wny mariadb b\u0119dzie dzia\u0142a\u0142 bezawaryjnie. Sensowne jest r\u00f3wnie\u017c korzystanie z serwera bazy danych. Jest to po\u0142\u0105czone z opcj\u0105 -skip-networking. Wi\u0119c dost\u0119p z zewn\u0105trz jest zabroniony. Ten dost\u0119p jest inaczej bez has\u0142a. To staje si\u0119 proste, je\u015bli mariadb zakorzenia si\u0119. Wtedy mo\u017cesz po prostu pracowa\u0107 bez has\u0142a roota i serwer bazy danych zostanie po\u0142\u0105czony. Tam mo\u017cna zresetowa\u0107 has\u0142o. Je\u015bli has\u0142o dla u\u017cytkownika zosta\u0142o zmienione, w\u00f3wczas serwer bazy danych mo\u017ce zosta\u0107 zlikwidowany. Nast\u0119pnie us\u0142uga jest uruchamiana ponownie. Za pomoc\u0105 nowo przydzielonego has\u0142a u\u017cytkownik mo\u017ce teraz \u0142\u0105czy\u0107 si\u0119 z serwerem g\u0142\u00f3wnym mariadb.<\/p>\n

Wymagania i pierwsze kroki<\/p>\n

Aby uzyska\u0107 dost\u0119p do mariadb root- Serverpaswort, nale\u017cy zapewni\u0107 dost\u0119p do mariadb root serwera Linux. Zamiennik typu drop-in w pe\u0142ni kompatybilny z MySQL<\/a> jest zazwyczaj wysy\u0142any przez roota mariadb. U\u017cywany Baza danych<\/a> i wersja musz\u0105 by\u0107 u\u017cywane z r\u00f3\u017cnymi poleceniami. Tak wi\u0119c has\u0142o roota mo\u017ce by\u0107 odzyskane. Aby dotrze\u0107 do bazy danych musi by\u0107 zatrzymany, a nast\u0119pnie mo\u017ce by\u0107 osi\u0105gni\u0119ty tylko r\u0119cznie. Linia polece\u0144 bazy danych mo\u017ce by\u0107 r\u00f3wnie\u017c dost\u0119pna bez podawania has\u0142a. Nale\u017cy zapobiec sytuacji, w kt\u00f3rej mo\u017cna po\u0142\u0105czy\u0107 si\u0119 z innymi klientami. Baza danych musi zosta\u0107 uruchomiona bez \u0142adowania tabel dotacji. Reklama na ko\u0144cu polecenia, proces ten jest uruchamiany w tle. Dzi\u0119ki temu terminal mo\u017ce by\u0107 dalej wykorzystywany. Po\u0142\u0105czenie z baz\u0105 danych mo\u017ce by\u0107 wykonane jako u\u017cytkownik root. To po\u0142\u0105czenie z baz\u0105 danych mo\u017ce by\u0107 u\u017cywane bez podawania has\u0142a. Z opcj\u0105 $ mysql-u root, natychmiast widziany jest znak zach\u0119ty pow\u0142oki bazy danych. Za pomoc\u0105 r\u00f3\u017cnych podpowiedzi mo\u017cna uzyska\u0107 dost\u0119p do roota. Tam mo\u017cna wygodnie zmieni\u0107 has\u0142o.<\/p>\n

Zmiana has\u0142a roota<\/p>\n

W nowoczesnych wersjach serwera g\u0142\u00f3wnego mariadb mo\u017cna u\u017cywa\u0107 komendy ALT USER. Jednak\u017ce, polecenie to nie zadzia\u0142a, je\u015bli tabele dotacji nie zostan\u0105 za\u0142adowane. FLUSH PRIVILEGES mog\u0105 by\u0107 u\u017cywane do \u0142adowania tabel dotacji. Za pomoc\u0105 mysql> FLUSH PRIVILEGES mo\u017cna \u0142atwo zmieni\u0107 has\u0142o roota. Dla nowszych wersji ni\u017c MariaDB 10.1.20 mo\u017cna u\u017cy\u0107 nast\u0119puj\u0105cego polecenia: mysql> ALTER USER 'root'@'localhost'IDENTIFIED BY 'new_password'; .
\nDla wersji MariaDB 10.1.20 i starszych polecenie mysql> SET PASSWORD FOR 'root'@'localhorst'= PASSWORD('new_password'); . Nale\u017cy pami\u0119ta\u0107, \u017ce new_password powinno by\u0107 pierwszym wybranym has\u0142em. Polecenie ALTER USER mo\u017ce czasami nie dzia\u0142a\u0107, wi\u0119c UPDATE...SET mo\u017ce zazwyczaj zast\u0105pi\u0107 has\u0142o. Wa\u017cne jest, aby tabele dotacji zosta\u0142y p\u00f3\u017aniej prze\u0142adowane. W obu przypadkach nale\u017cy zobaczy\u0107 potwierdzenie, \u017ce polecenie zosta\u0142o wykonane. Serwer bazy danych mo\u017ce by\u0107 teraz zatrzymany i ponownie uruchomiony. Przypadek serwera jest zatrzymywany i wysy\u0142any za pomoc\u0105 SIGTERM. Po oczyszczeniu polecenie to b\u0119dzie pojawia\u0107 si\u0119 cz\u0119\u015bciej.<\/p>","protected":false},"excerpt":{"rendered":"

Linux MariaDB Root Das Passwort von mariadb root ist gerade nicht griffbereit, oder es wurde vergessen? Auch wenn das Passwort nicht sicher genug ist und es soll ge\u00e4ndert werden sollten keine Probleme auftauchen. Das Passwort kann leicht zur\u00fcck gesetzt, ver\u00e4ndert oder neu eingesetzt werden. Der L\u00f6sungsweg f\u00fcr Probleme, wie die \u00c4nderung des Passworts sind sehr […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[],"class_list":["post-4398","post","type-post","status-publish","format-standard","hentry","category-administration-anleitungen","category-anleitungen","category-datenbanken-administration-anleitungen","category-hilfe"],"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":"","_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":"5089","_trp_automatically_translated_slug_ru_ru":null,"_trp_automatically_translated_slug_et":"mariadb-root-passwort-aendern","_trp_automatically_translated_slug_lv":"mariadb-root-passwort-aendern","_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-root-passwort-aendern","_trp_automatically_translated_slug_ja":"mariadb-%e3%83%ab%e3%83%bc%e3%83%88%e3%83%91%e3%82%b9%e3%83%af%e3%83%bc%e3%83%89%e3%81%ae%e5%a4%89%e6%9b%b4","_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":"705","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 root passwort \u00e4ndern"],"_eb_reusable_block_ids":null,"rank_math_focus_keyword":null,"rank_math_og_content_image":null,"_yoast_wpseo_metadesc":"","_yoast_wpseo_content_score":null,"_yoast_wpseo_focuskeywords":null,"_yoast_wpseo_keywordsynonyms":null,"_yoast_wpseo_estimated-reading-time-minutes":null,"rank_math_description":null,"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":null,"footnotes":null,"_links":{"self":[{"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/posts\/4398","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=4398"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/posts\/4398\/revisions"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/media?parent=4398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/categories?post=4398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/pl\/wp-json\/wp\/v2\/tags?post=4398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}