{"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\/sk\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"Ako resetova\u0165 heslo pre administr\u00e1ciu WordPressu cez phpMyAdmin na hostingu?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Na\u010do resetova\u0165 heslo cez 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 webovom hostingu.<\/p>\n

Ned\u00e1vno som pracoval na jednom blogu, ktor\u00fd vy\u017eadoval priamy z\u00e1sah do DB a resetovanie hesla, preto som sa rozhodol nap\u00edsa\u0165 tento pr\u00edspevok, aby ste mali pokyny \u201eAko resetova\u0165 heslo do administr\u00e1cie WordPress cez phpMyAdmin<\/strong> na hostingu\u201c.<\/p>\n

Tak\u017ee, v ka\u017edom pr\u00edpade, pr\u00edstup na hosting a ovl\u00e1dac\u00ed panel<\/a> Va\u0161\u00edm webom (webmi) zost\u00e1va a toho m\u00e1me dos\u0165. V z\u00e1vislosti od toho, ak\u00fd internetov\u00fd hosting pou\u017e\u00edvate, bude typ a vzh\u013ead ovl\u00e1dacieho panela r\u00f4zny, ale v ka\u017edom takomto panely je bod \u00abphpMyAdmin\u00bb, ten n\u00e1jdete.\"\"<\/p>\n

phpMyAdmin m\u00f4\u017ee by\u0165 skryt\u00fd, povedzme \u2014 nach\u00e1dza\u0165 sa v podbode \u00abSpr\u00e1va datab\u00e1z<\/strong>\u201c, preto si d\u00f4kladne prezrite ovl\u00e1dac\u00ed panel a n\u00e1jdite t\u00fato aplik\u00e1ciu. Na\u0161li ste ju a prejdite priamo do phpMyAdmin. Pred Vami sa objav\u00ed tak\u00fdto obrazec:<\/p>\n

\"\"<\/p>\n

Tu m\u00e1me mo\u017enos\u0165 robi\u0165 s na\u0161imi datab\u00e1zami v\u0161etko potrebn\u00e9, \u00faplne nimi spravova\u0165. Teraz mus\u00edme n\u00e1js\u0165 datab\u00e1zu, ktor\u00e1 sa t\u00fdka n\u00e1\u0161ho blogu. Ak si nepam\u00e4t\u00e1te, ktor\u00e1 konkr\u00e9tna datab\u00e1za zo zoznamu (m\u00f4\u017ee ich tu by\u0165 nieko\u013eko) sa t\u00fdka v\u00e1\u0161ho zdroja, jednoducho si pozrite s\u00fabor wp-config.php, tam ste v\u0161etky tieto \u00fadaje zap\u00edsali.<\/p>\n

\"\"<\/p>\n

N\u00e1jdite v tomto s\u00fabore riadok:<\/p>\n

define('DB_NAME', 'N\u00e1zov va\u0161ej DB')<\/strong>;<\/p>\n

A pr\u00e1ve t\u00fato datab\u00e1zu vyberiete v phpMyAdmin.<\/p>\n

Kliknite na t\u00fato datab\u00e1zu a pred nami sa otvor\u00ed cel\u00e1 jej \u0161trukt\u00fara, v\u0161etky tabu\u013eky, ktor\u00e9 m\u00f4\u017eeme zmeni\u0165. Teraz n\u00e1s zauj\u00edma tabu\u013ekawp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

V tejto tabu\u013eke s\u00fa uveden\u00ed v\u0161etci pou\u017e\u00edvatelia (ak je ich viac), ktor\u00ed maj\u00fa pr\u00edstup k spr\u00e1ve blogu. Tu budeme m\u00f4c\u0165 zmeni\u0165 heslo alebo odstr\u00e1ni\u0165 konkr\u00e9tneho pou\u017e\u00edvate\u013ea \u2014 klikneme na wp_users a otvor\u00ed sa n\u00e1m obsah celej tabu\u013eky.
\nTu mus\u00edme upravi\u0165 heslo. V pr\u00edpade blogu, na ktorom som pracoval, bolo vidie\u0165, \u017ee okrem administr\u00e1tora bol zaregistrovan\u00fd e\u0161te jeden pou\u017e\u00edvate\u013e, a majite\u013e mi ozn\u00e1mil, \u017ee pou\u017e\u00edvate\u013e by mal by\u0165 len jeden. Znamen\u00e1 to, \u017ee tam u\u017e niekto b\u00fdval.
\nV tabu\u013eke mus\u00edme klikn\u00fa\u0165 na ceruzku \u201eUpravi\u0165\u201c ved\u013ea mena pou\u017e\u00edvate\u013ea a zmeni\u0165 heslo.<\/p>\n

\"\"<\/p>\n

Pred nami sa otvor\u00ed \u0161trukt\u00fara tejto tabu\u013eky, kde uvid\u00edme v\u0161etky \u00fadaje t\u00fdkaj\u00face sa tohto pou\u017e\u00edvate\u013ea. Nep\u00f4jdem podrobne do ka\u017edej z\u00e1lo\u017eky \u2014 poviem len, ako resetova\u0165 heslo.<\/p>\n

\"\"<\/p>\n

Moment\u00e1lne je heslo za\u0161ifrovan\u00e9 met\u00f3dou MD5, preto na pr\u00edslu\u0161nom riadku vid\u00edme nepochopite\u013en\u00e9 znaky.<\/p>\n

\"\"<\/p>\n

Aby ste zmenili heslo<\/strong> \u2014 rob\u00edme nasledovn\u00e9: v riadku user_pass<\/strong> do po\u013ea hesla zad\u00e1me nov\u00e9 heslo, a v poli varchar (64)<\/strong> \u2014 vyberieme met\u00f3du \u0161ifrovania MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Zmeny sme urobili a klikneme na tla\u010didlo \u201e\u010ealej<\/strong>\u201c \u00faplne na spodku a ulo\u017e\u00edme nov\u00e9 heslo.<\/strong>.<\/p>\n

\"\"<\/p>\n

Po ulo\u017een\u00ed v\u0161etk\u00fdch zmien \u2014 to heslo, ktor\u00e9 ste zadali, sa op\u00e4\u0165 stane v MD5, ale bude tak\u00e9, ak\u00e9 potrebujete. Teraz sa pokojne prihl\u00e1ste do blogu s nov\u00fdm heslom.<\/p>\n

Rada.<\/em> NIKDY<\/strong> nepou\u017e\u00edvajte prihl\u00e1senie admin<\/strong> a jednoduch\u00e9 hesl\u00e1 \u2014 to v\u00e1s ochr\u00e1ni pred nepr\u00edjemn\u00fdmi n\u00e1sledkami hackovania v\u00e1\u0161ho zdroja. Zme\u0148te svoje pr\u00edstupov\u00e9 \u00fadaje na zlo\u017eitej\u0161ie a \u201epodivn\u00e9\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 Resetujeme heslo cez phpMyAdmin pre administr\u00e1ciu webov\u00fdch str\u00e1nok WordPress | ProHoster","description":"Na\u010do resetova\u0165 heslo cez phpMyAdmin?","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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 Obnovenie hesla cez phpMyAdmin pre administra\u010dn\u00fd panel str\u00e1nok 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\/sk\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}