{"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-dimenticato","status":"publish","type":"post","link":"https:\/\/webhosting.de\/it\/mariadb-mysql-root-passwort-vergessen\/","title":{"rendered":"MariaDB \/ MySQL Root Password dimenticata"},"content":{"rendered":"

Hai perso di nuovo la tua lista di password? I dati di login degli utenti principali vanno rapidamente persi e non vengono salvati nel sistema stesso.
\nQui \u00e8 certamente pi\u00f9 facile con i database che sono usati da Contenuto<\/a> Management Systems, qui la password viene memorizzata in chiaro nei rispettivi file di configurazione. Questo non \u00e8 il caso dell'utente principale del server di database.
\nDi solito il nome utente \u00e8 root. Su Plesk<\/a> installazioni viene utilizzato il nome utente \"admin\". La password di un server Plesk pu\u00f2 essere facilmente recuperata dal file .psa\/shadow. Per esempio: con il comando:<\/p>\n

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

Se \u00e8 necessario reimpostare completamente la password, basta seguire questi passi.<\/p>\n

Uscire dal server del database. Ad esempio sotto Centos7 con MariaDB con <\/p>\n

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

Se si utilizza un altro server di database, questo pu\u00f2 essere fatto anche con<\/p>\n

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

MariaDB \/ MySQL root Cambiare la password<\/h2>\n

Ora avviamo il server del database senza restrizioni e gestione dei diritti, in modo che possa essere amministrato senza password. Per fare questo, usiamo l'opzione -skip-grant-tables, che elimina le restrizioni, e -skip-networking, che impedisce l'accesso esterno durante la configurazione.<\/p>\n

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

Ora \u00e8 possibile modificare facilmente la password di MySQL.<\/p>\n

mysql -u root
\nmysql> usa mysql;
\nmysql> update user set password=PASSWORD(\"the_desired_password\") dove User='root';
\nmysql> sciacquare i privilegi;
\nmysql> uscire<\/code><\/p>\n

Ora la password viene modificata e il server del database pu\u00f2 essere terminato.<\/p>\n

spegnimento del mysqladmin<\/code><\/p>\n

In modo che possa poi essere avviata normalmente.<\/p>\n

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

Ulteriori informazioni si trovano naturalmente anche nel manuale del produttore all'indirizzo 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":"5292","_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\/it\/wp-json\/wp\/v2\/posts\/4132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/comments?post=4132"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/posts\/4132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/media?parent=4132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/categories?post=4132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/it\/wp-json\/wp\/v2\/tags?post=4132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}