{"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\/cs\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"Jak resetovat heslo k administraci WordPressu p\u0159es phpMyAdmin na hostingu?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

K \u010demu slou\u017e\u00ed resetov\u00e1n\u00ed hesla p\u0159es 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> na webov\u00e9m hostingu.<\/p>\n

Ned\u00e1vno jsem pracoval na jednom blogu, kter\u00fd vy\u017eadoval z\u00e1sah do datab\u00e1ze a resetov\u00e1n\u00ed hesla, a tak jsem se rozhodl napsat tento p\u0159\u00edsp\u011bvek, abyste v p\u0159\u00edpad\u011b pot\u0159eby m\u011bli n\u011bjak\u00fd n\u00e1vod, jak resetovat heslo do administrace WordPressu p\u0159es phpMyAdmin<\/strong> na hostingu.\u201c<\/p>\n

Tak\u017ee, v ka\u017ed\u00e9m p\u0159\u00edpad\u011b, p\u0159\u00edstup k hostingu ve ovl\u00e1dac\u00ed panel<\/a> Va\u0161\u00edm webem (weby) v\u00e1m z\u016fst\u00e1v\u00e1 a n\u00e1m to sta\u010d\u00ed. V z\u00e1vislosti na tom, jak\u00fd internetov\u00fd hosting pou\u017e\u00edv\u00e1te, se typ a vzhled panelu pro spr\u00e1vu web\u016f li\u0161\u00ed, ale v ka\u017ed\u00e9m takov\u00e9m panelu najdete polo\u017eku \u201ephpMyAdmin\u201c, tu hledejte.\"\"<\/p>\n

phpMyAdmin m\u016f\u017ee b\u00fdt skryt\u00fd, nap\u0159\u00edklad m\u016f\u017ee b\u00fdt v podmenu \u201eSpr\u00e1va datab\u00e1z\u00ed<\/strong>\u201c, proto pe\u010dliv\u011b prozkoumejte ovl\u00e1dac\u00ed panel a najd\u011bte tuto aplikaci. Na\u0161li jste a p\u0159ech\u00e1z\u00edme p\u0159\u00edmo do phpMyAdmin. P\u0159ed v\u00e1mi se objev\u00ed takov\u00fd obr\u00e1zek:<\/p>\n

\"\"<\/p>\n

Zde m\u00e1me mo\u017enost d\u011blat s na\u0161imi datab\u00e1zemi v\u0161e, co pot\u0159ebujeme, pln\u011b je ovl\u00e1dat. Nyn\u00ed je nutn\u00e9 naj\u00edt tu datab\u00e1zi, kter\u00e1 se t\u00fdk\u00e1 na\u0161eho blogu. Pokud si nepamatujete, kter\u00e1 datab\u00e1ze ze seznamu (m\u016f\u017ee jich b\u00fdt n\u011bkolik vlevo) se t\u00fdk\u00e1 va\u0161eho zdroje, jednodu\u0161e se pod\u00edvejte do souboru wp-config.php, tam jsou v\u0161echny tyto \u00fadaje uvedeny.<\/p>\n

\"\"<\/p>\n

Najdete v tomto souboru \u0159\u00e1dek:<\/p>\n

define('DB_NAME', 'N\u00e1zev va\u0161\u00ed datab\u00e1ze')<\/strong>;<\/p>\n

A pr\u00e1v\u011b tuto datab\u00e1zi vyberete v phpMyAdmin.<\/p>\n

Klikneme na tuto datab\u00e1zi a p\u0159ed n\u00e1mi se otev\u0159e cel\u00e1 struktura, v\u0161echny tabulky, kter\u00e9 m\u016f\u017eeme upravit. Nyn\u00ed n\u00e1s zaj\u00edm\u00e1 tabulkawp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

V t\u00e9to tabulce jsou uvedeni v\u0161ichni u\u017eivatel\u00e9 (pokud jich je v\u00edce), kte\u0159\u00ed maj\u00ed p\u0159\u00edstup k administraci blogu. Pr\u00e1v\u011b zde m\u016f\u017eeme zm\u011bnit heslo nebo odstranit konkr\u00e9tn\u00edho u\u017eivatele - klikneme na wp_users a zobraz\u00ed se n\u00e1m obsah cel\u00e9 tabulky.
\nZde je t\u0159eba upravit heslo. V p\u0159\u00edpad\u011b blogu, na kter\u00e9m jsem pracoval, bylo vid\u011bt, \u017ee krom\u011b administr\u00e1tora byl zaregistrov\u00e1n je\u0161t\u011b jeden u\u017eivatel, a vlastn\u00edk mi sd\u011blil, \u017ee u\u017eivatel m\u00e1 b\u00fdt jen jeden. To znamen\u00e1, \u017ee tam u\u017e n\u011bkdo byl.
\nV tabulce je nutn\u00e9 kliknout na ikonku tu\u017eky \u201eUpravit\u201c vedle jm\u00e9na u\u017eivatele a zm\u011bnit heslo.<\/p>\n

\"\"<\/p>\n

P\u0159ed n\u00e1mi se otev\u0159e struktura t\u00e9to tabulky, kde uvid\u00edme v\u0161echny \u00fadaje t\u00fdkaj\u00edc\u00ed se tohoto u\u017eivatele. Nebudu se podrobn\u011b zab\u00fdvat ka\u017ed\u00fdm sloupcem, uvedu jen, jak resetovat heslo.<\/p>\n

\"\"<\/p>\n

Nyn\u00ed je heslo za\u0161ifrov\u00e1no metodou MD5, proto vid\u00edme v p\u0159\u00edslu\u0161n\u00e9m \u0159\u00e1dku nesrozumiteln\u00e9 znaky.<\/p>\n

\"\"<\/p>\n

Aby zm\u011bnit heslo<\/strong> - d\u011bl\u00e1me n\u00e1sleduj\u00edc\u00ed: v \u0159\u00e1dku user_pass<\/strong> do pole hesla nap\u00ed\u0161eme nov\u00e9 heslo a v poli varchar (64)<\/strong> - vyb\u00edr\u00e1me metodu \u0161ifrov\u00e1n\u00ed MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Provedli jsme zm\u011bny a klikneme na tla\u010d\u00edtko \u201ePokra\u010dovat<\/strong>\u201c na sam\u00e9m dn\u011b a ulo\u017e\u00edme nov\u00e9 heslo<\/strong>.<\/p>\n

\"\"<\/p>\n

Po ulo\u017een\u00ed v\u0161ech zm\u011bn - to heslo, kter\u00e9 jste zadali, se znovu p\u0159evede na MD5, ale bude m\u00edt podobu, kterou pot\u0159ebujete. Nyn\u00ed se v klidu p\u0159ihlaste do administrace blogu s nov\u00fdm heslem.<\/p>\n

Tip.<\/em> NIKDY<\/strong> nepou\u017e\u00edvejte p\u0159ihla\u0161ovac\u00ed jm\u00e9no admin<\/strong> a jednoduch\u00e1 hesla - to v\u00e1s ochr\u00e1n\u00ed p\u0159ed nep\u0159\u00edjemn\u00fdmi d\u016fsledky hacknut\u00ed va\u0161eho zdroje. Zm\u011b\u0148te sv\u00e9 p\u0159ihla\u0161ovac\u00ed \u00fadaje na slo\u017eit\u011bj\u0161\u00ed a \u201epodivn\u011bj\u0161\u00ed\u201c.<\/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 Obnovujeme heslo p\u0159es phpMyAdmin pro administraci web\u016f WordPress | ProHoster","description":"Pro\u010d obnovit heslo p\u0159es phpMyAdmin?","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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 Obnoven\u00ed hesla p\u0159es phpMyAdmin pro administraci str\u00e1nek 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\/cs\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}