{"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-olvidado","status":"publish","type":"post","link":"https:\/\/webhosting.de\/es\/mariadb-mysql-root-passwort-vergessen\/","title":{"rendered":"MariaDB \/ MySQL Ra\u00edz Olvid\u00f3 la contrase\u00f1a"},"content":{"rendered":"

\u00bfHas perdido tu lista de contrase\u00f1as otra vez? Los datos de acceso de los principales usuarios se pierden r\u00e1pidamente y no se guardan en el propio sistema.
\nEn este caso es ciertamente m\u00e1s f\u00e1cil con las bases de datos que son utilizadas por Contenido<\/a> Sistemas de gesti\u00f3n, aqu\u00ed la contrase\u00f1a se almacena en texto plano en los respectivos archivos de configuraci\u00f3n. Este no es el caso del usuario principal del servidor de la base de datos.
\nNormalmente el nombre de usuario es root. En Plesk<\/a> instalaciones se utiliza el nombre de usuario \"admin\". La contrase\u00f1a de un servidor Plesk puede ser f\u00e1cilmente recuperada del archivo .psa\/shadow. Por ejemplo: con el comando:<\/p>\n

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

Si necesitas restablecer la contrase\u00f1a completamente, simplemente sigue estos pasos.<\/p>\n

Salga del servidor de la base de datos. Por ejemplo, bajo Centos7 con MariaDB con <\/p>\n

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

Si se utiliza otro servidor de base de datos, esto tambi\u00e9n puede hacerse con<\/p>\n

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

MariaDB \/ MySQL root Cambiar la contrase\u00f1a<\/h2>\n

Ahora ponemos en marcha el servidor de la base de datos sin restricciones y sin gesti\u00f3n de derechos, para que pueda ser administrado sin una contrase\u00f1a. Para ello, utilizamos la opci\u00f3n -saltar-cuadros, que elimina las restricciones, y -saltar-red, que impide el acceso externo durante la configuraci\u00f3n.<\/p>\n

mysqld_safe -- skip-grande-tabla -- skip-networking &<\/code><\/p>\n

Ahora puedes cambiar f\u00e1cilmente la contrase\u00f1a de MySQL.<\/p>\n

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

Ahora la contrase\u00f1a se cambia y el servidor de la base de datos puede ser terminado.<\/p>\n

apagado de mysqladmin<\/code><\/p>\n

Para que luego se pueda iniciar normalmente.<\/p>\n

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

Por supuesto, tambi\u00e9n se puede encontrar m\u00e1s informaci\u00f3n en el manual del fabricante en 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\/es\/wp-json\/wp\/v2\/posts\/4132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/comments?post=4132"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/posts\/4132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/media?parent=4132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/categories?post=4132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/es\/wp-json\/wp\/v2\/tags?post=4132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}