{"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\/et\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"Kuidas taastada WordPressi administreerimispseudo phpMyAdminis hostimises?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Miks l\u00e4htestada parooli kaudu 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> veebihostingus.<\/p>\n

Hiljuti t\u00f6\u00f6tasin \u00fche blogi kallal, mis vajas otsest sekkumist andmebaasi ja parooli l\u00e4htestamist. Seet\u00f5ttu otsustasin kirjutada selle postituse, et teil oleks vajadusel juhend \u201eKuidas l\u00e4htestada WordPressi administreerimisparool l\u00e4bi phpMyAdmin<\/strong> veebihostingu.\"<\/p>\n

Nii et igal juhul, kuid juurdep\u00e4\u00e4s hostimisele on juhtpaneel<\/a> Teie saidi (saidid) kohta j\u00e4\u00e4b teile ning meile piisab sellest. S\u00f5ltuvalt sellest, millist veebimajutust teenust te kasutate \u2014 paneeli t\u00fc\u00fcp ja v\u00e4limus on erinev, kuid igas sellises paneelis on punkt \u201ephpMyAdmin\u201c, seega leidke see.\"\"<\/p>\n

phpMyAdmin v\u00f5ib olla peidetud, \u00f6eldes \u2014 asuda alamosas \u201eAndmebaaside haldamine<\/strong>\", seega uurige hoolikalt juhtpaneeli ja leidke see rakendus. Leidke ja liikume otse phpMyAdmini. Teie ees avaneb selline vaade:<\/p>\n

\"\"<\/p>\n

Siin on meil v\u00f5imalus teha k\u00f5ike, mida soovime oma andmebaasidega, t\u00e4ielikult neid hallata. Praegu peame leidma selle andmebaasi, mis puudutab meie blogi. Kui te ei m\u00e4leta, milline andmebaas loendist (siin vasakul v\u00f5ib olla mitu) puudutab teie ressursi, vaadake lihtsalt faili wp-config.php, seal on k\u00f5ik need andmed kirjas.<\/p>\n

\"\"<\/p>\n

Leidke sellest failist rida:<\/p>\n

define('DB_NAME', 'Teie andmebaasi nimi')<\/strong>;<\/p>\n

Ja valige see andmebaas phpMyAdminis.<\/p>\n

Kl\u00f5psake sellel andmebaasil ja meie ette avatakse kogu struktuur, k\u00f5ik tabelid, mida saame muuta. Praegu huvitab meid tabelwp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

Selles tabelis on kirjas k\u00f5ik kasutajad (kui neid on mitu), kellel on juurdep\u00e4\u00e4s blogi haldamisele. Just siit saame me parooli muuta v\u00f5i teatud kasutaja kustutada \u2014 kl\u00f5psame wp_users ja avaneb kogu tabeli sisu.
\nSiin peame redigeerima parooli. Blogi puhul, millega ma t\u00f6\u00f6tasin, oli n\u00e4ha, et lisaks administraatorile oli registreeritud veel \u00fcks kasutaja, ja omanik \u00fctles mulle, et kasutaja peaks olema ainult \u00fcks. See t\u00e4hendab, et keegi seal juba elas.
\nTabelis peame kl\u00f5psama pliiatsiikoonil \u201eMuuda\u201c kasutajanime k\u00f5rval ja muutma parooli.<\/p>\n

\"\"<\/p>\n

Ees on meie silme ees selle tabeli struktuur, kus me n\u00e4eme k\u00f5iki andmeid, mis puudutavad seda kasutajat. Ma ei j\u00e4\u00e4 iga riba peale pikalt peatuma \u2014 r\u00e4\u00e4gin ainult, kuidas parooli l\u00e4htestada.<\/p>\n

\"\"<\/p>\n

Praegu on parool meil kr\u00fcpteeritud MD5 meetodiga, seega n\u00e4eme vastavas reas arusaamatuid m\u00e4rke.<\/p>\n

\"\"<\/p>\n

Et muuda parooli<\/strong> \u2014 teeme j\u00e4rgmist: real user_pass<\/strong> kirjutame parooliv\u00e4lja uue parooli, ja v\u00e4ljal varchar (64)<\/strong> \u2014 valime kr\u00fcpteerimismeetodi MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Tehtud muudatused ja vajutame nuppu \u201eEdasi<\/strong>\u201c allosas ja salvestame uue parooli<\/strong>.<\/p>\n

\"\"<\/p>\n

P\u00e4rast k\u00f5igi muudatuste salvestamist \u2014 see parool, mille te sisestasite, muutub taas MD5-ks, kuid see on selline, nagu te soovite. N\u00fc\u00fcd p\u00e4\u00e4seme rahulikult blogi salongi sisse uue parooliga.<\/p>\n

N\u00f5uanne.<\/em> KUNAGI<\/strong> \u00e4rge kasutage sisselogimiseks admin<\/strong> ja lihtsad paroolid \u2014 see kaitseb teid ebameeldivate tagaj\u00e4rgede eest teie ressursi h\u00e4kkimise korral. Muutke oma juurdep\u00e4\u00e4suandmed keerulisemaks ja \u201eveidramaks\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\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 Taastame parooli phpMyAdmini kaudu WordPressi saitide administraatorite jaoks | ProHoster","description":"Miks l\u00e4htestada parool phpMyAdmini abil?","canonical_url":"https:\/\/prohoster.info\/et\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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 WordPressi saidi administraatori parooli l\u00e4htestamine phpMyAdmini abil | #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\/et\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}