{"id":41885,"date":"2017-04-19T00:00:00","date_gmt":"2017-04-18T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm"},"modified":"2020-02-18T13:44:38","modified_gmt":"2020-02-18T10:44:38","slug":"kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","status":"publish","type":"post","link":"https:\/\/prohoster.info\/es\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"\u00bfC\u00f3mo restablecer la contrase\u00f1a del panel de administraci\u00f3n de WordPress a trav\u00e9s de phpMyAdmin en el hosting?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\u00bfPor qu\u00e9 restablecer la contrase\u00f1a a trav\u00e9s de phpMyAdmin<\/strong>? \u0421\u0438\u0442\u0443\u0430\u0446\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043c\u043d\u043e\u0433\u043e — \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u044d\u0442\u043e\u0442 \u043f\u0430\u0440\u043e\u043b\u044c \u0438 \u043f\u043e \u043a\u0430\u043a\u0438\u043c-\u0442\u043e \u043f\u0440\u0438\u0447\u0438\u043d\u0430\u043c \u043d\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0441\u043f\u043e\u043c\u043d\u0438\u0442\u044c \u0447\u0435\u0440\u0435\u0437 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u0443\u044e \u043f\u043e\u0447\u0442\u0443, \u0412\u0430\u0441 \u043f\u043e\u0447\u0435\u043c\u0443-\u0442\u043e \u043d\u0435 \u043f\u0443\u0441\u043a\u0430\u044e\u0442 \u0432 \u0430\u0434\u043c\u0438\u043d\u043a\u0443, \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u043e\u0442 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u043e\u0439 \u043f\u043e\u0447\u0442\u044b \u0438\u043b\u0438 \u044d\u0442\u0438\u043c \u044f\u0449\u0438\u043a\u043e\u043c \u0443\u0436\u0435 \u043d\u0435 \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c, \u0412\u0430\u0448 \u0431\u043b\u043e\u0433 \u043f\u0440\u043e\u0441\u0442\u043e \u0441\u043b\u043e\u043c\u0430\u043b\u0438 \u0438 \u0438\u0437\u043c\u0435\u043d\u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c (\u043d\u0435 \u0434\u0430\u0439 \u0411\u043e\u0433) \u0438 \u0442.\u0434. \u0421\u0430\u043c\u044b\u043c \u043f\u0440\u043e\u0441\u0442\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u0435\u043c \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0431\u0440\u043e\u0441 \u043f\u0430\u0440\u043e\u043b\u044f \u0447\u0435\u0440\u0435\u0437 phpMyAdmin<\/strong> en el alojamiento web?<\/p>\n

Recientemente trabaj\u00e9 con un blog que requer\u00eda intervenci\u00f3n directa en la base de datos y un restablecimiento de contrase\u00f1a, as\u00ed que decid\u00ed escribir esta publicaci\u00f3n para que, en caso de ser necesario, tuvieras una gu\u00eda sobre 'C\u00f3mo restablecer la contrase\u00f1a del panel de administraci\u00f3n de WordPress a trav\u00e9s de phpMyAdmin<\/strong> en el alojamiento\".<\/p>\n

Entonces, de todos modos, el acceso al alojamiento en panel de control<\/a> Tu(s) sitio(s) web permanece(n) y eso es suficiente para nosotros. Dependiendo del tipo de hosting que utilices, el tama\u00f1o y la apariencia del panel de control variar\u00e1n, pero en cada uno de estos paneles encontrar\u00e1s la opci\u00f3n 'phpMyAdmin', que debes localizar.\"\"<\/p>\n

phpMyAdmin puede estar oculto, por ejemplo, en un submen\u00fa 'Gesti\u00f3n de bases de datos<\/strong>\u00bb, as\u00ed que revisen el panel de control con atenci\u00f3n y encuentren esta aplicaci\u00f3n. Una vez que la hayan encontrado, accedemos directamente a phpMyAdmin. Ante ustedes aparecer\u00e1 esta imagen:<\/p>\n

\"\"<\/p>\n

Aqu\u00ed tenemos la posibilidad de hacer con nuestras bases de datos todo lo que necesitamos, gestionarlas completamente. Ahora necesitamos encontrar la base de datos que corresponde a nuestro blog. Si no recuerdan cu\u00e1l de la lista (puede haber varias en la parte izquierda) se relaciona con su recurso, simplemente revisen el archivo wp-config.php, donde tienen estos datos registrados.<\/p>\n

\"\"<\/p>\n

Busquen en este archivo la l\u00ednea:<\/p>\n

define('DB_NAME', 'Nombre de tu base de datos')<\/strong>;<\/p>\n

Y seleccionen precisamente esta base de datos en phpMyAdmin.<\/p>\n

Hacemos clic en esta base de datos y se abrir\u00e1 ante nosotros toda la estructura, todas las tablas que podemos modificar. Ahora nos interesa la tablawp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

En esta tabla se registran todos los usuarios (si existen varios) que tienen acceso a la gesti\u00f3n del blog. Aqu\u00ed es donde podremos cambiar la contrase\u00f1a o eliminar a un usuario espec\u00edfico; hacemos clic en wp_users y se abrir\u00e1 el contenido de toda la tabla.
\nAqu\u00ed necesitamos editar la contrase\u00f1a. En el caso del blog con el que trabaj\u00e9, se pod\u00eda ver que adem\u00e1s del administrador, hab\u00eda otro usuario registrado, y el propietario me inform\u00f3 que deber\u00eda haber solo uno. As\u00ed que alguien ya estaba ah\u00ed.
\nEn la tabla necesitaremos hacer clic en el l\u00e1piz \"Editar\" junto al nombre de usuario y cambiar la contrase\u00f1a.<\/p>\n

\"\"<\/p>\n

Ante nosotros se abrir\u00e1 la estructura de esta tabla, donde veremos todos los datos relacionados con este usuario. No me detendr\u00e9 en cada l\u00ednea; solo explicar\u00e9 c\u00f3mo restablecer la contrase\u00f1a.<\/p>\n

\"\"<\/p>\n

En este momento, la contrase\u00f1a est\u00e1 encriptada con el m\u00e9todo MD5, por lo que en la l\u00ednea correspondiente vemos s\u00edmbolos incomprensibles.<\/p>\n

\"\"<\/p>\n

Para cambiar la contrase\u00f1a<\/strong> - hacemos lo siguiente: en la fila user_pass<\/strong> en el campo de contrase\u00f1a escribimos la nueva contrase\u00f1a, y en el campo varchar (64)<\/strong> - seleccionamos el m\u00e9todo de cifrado MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Realizamos los cambios y presionamos el bot\u00f3n \u00abContinuar<\/strong>\u00bb al final y guardamos la nueva contrase\u00f1a<\/strong>.<\/p>\n

\"\"<\/p>\n

Despu\u00e9s de guardar todos los cambios, la contrase\u00f1a que ingresaste se convertir\u00e1 nuevamente en MD5, pero ser\u00e1 exactamente como lo necesitas. Ahora puedes acceder al panel del blog con la nueva contrase\u00f1a.<\/p>\n

Consejo.<\/em> NUNCA<\/strong> utilices el nombre de usuario admin<\/strong> y las contrase\u00f1as simples te proteger\u00e1n de las consecuencias desagradables de un posible hackeo de tu recurso. Cambia tus credenciales a opciones m\u00e1s complejas y 'extra\u00f1as'.<\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0414\u043b\u044f \u0447\u0435\u0433\u043e \u0441\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin? \u0421\u0438\u0442\u0443\u0430\u0446\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043c\u043d\u043e\u0433\u043e — \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u044d\u0442\u043e\u0442 \u043f\u0430\u0440\u043e\u043b\u044c \u0438 \u043f\u043e \u043a\u0430\u043a\u0438\u043c-\u0442\u043e \u043f\u0440\u0438\u0447\u0438\u043d\u0430\u043c \u043d\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0441\u043f\u043e\u043c\u043d\u0438\u0442\u044c \u0447\u0435\u0440\u0435\u0437 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u0443\u044e \u043f\u043e\u0447\u0442\u0443, \u0412\u0430\u0441 \u043f\u043e\u0447\u0435\u043c\u0443-\u0442\u043e \u043d\u0435 \u043f\u0443\u0441\u043a\u0430\u044e\u0442 \u0432 \u0430\u0434\u043c\u0438\u043d\u043a\u0443, \u0412\u044b \u0437\u0430\u0431\u044b\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u043e\u0442 \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u043e\u0439 \u043f\u043e\u0447\u0442\u044b \u0438\u043b\u0438 \u044d\u0442\u0438\u043c \u044f\u0449\u0438\u043a\u043e\u043c \u0443\u0436\u0435 \u043d\u0435 \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435\u0441\u044c, \u0412\u0430\u0448 \u0431\u043b\u043e\u0433 \u043f\u0440\u043e\u0441\u0442\u043e \u0441\u043b\u043e\u043c\u0430\u043b\u0438 \u0438 \u0438\u0437\u043c\u0435\u043d\u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u044c (\u043d\u0435 \u0434\u0430\u0439 \u0411\u043e\u0433) \u0438 \u0442.\u0434. […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[682],"tags":[],"class_list":["post-41885","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-raznoe"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Restablecemos la contrase\u00f1a a trav\u00e9s de phpMyAdmin para el panel de administraci\u00f3n de sitios WordPress | ProHoster","description":"\u00bfPor qu\u00e9 restablecer la contrase\u00f1a a trav\u00e9s de phpMyAdmin?","canonical_url":"https:\/\/prohoster.info\/es\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"es_ES","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47 \u0421\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0435\u043c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin \u0434\u043b\u044f \u0430\u0434\u043c\u0438\u043d\u043a\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 WordPress | ProHoster","og:description":"\u0414\u043b\u044f \u0447\u0435\u0433\u043e \u0441\u0431\u0440\u0430\u0441\u044b\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u044c \u0447\u0435\u0440\u0435\u0437 phpMyAdmin?","og:url":"https:\/\/prohoster.info\/es\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2017-04-18T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:38+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"41885","title":"\ud83e\udd47 Restablecemos la contrase\u00f1a a trav\u00e9s de phpMyAdmin para el panel de administraci\u00f3n de sitios WordPress | #site_title","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-08 19:54:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:40:48","updated":"2026-02-08 19:54:20","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}