{"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 l\u00e4htestada WordPressi admini parool phpMyAdmini kaudu hostimisel?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Milleks on parooli l\u00e4htestamine 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> veebihostingul.<\/p>\n

Hiljuti t\u00f6\u00f6tasin \u00fche blogiga, mis n\u00f5udis otset\u00f6\u00f6d andmebaasi ja parooli l\u00e4htestamist, seega otsustasin kirjutada selle postituse, et teil oleks juhend \"Kuidas l\u00e4htestada WordPressi administreerimisp\u00e4eva parooli\". phpMyAdmin<\/strong> veebihostingu.\"<\/p>\n

Nii et igal juhul, kuid juurdep\u00e4\u00e4s veebihostingule juhtpaneel<\/a> Teie veebisaidi (veebisaitide) kohta j\u00e4\u00e4b see meile piisavaks. Olenevalt sellest, millist veebimajutust kasutate, on teie veebisaitide halduspaneeli t\u00fc\u00fcp ja v\u00e4limus erinev, kuid igas sellises paneelis on valik \"phpMyAdmin\" \u2014 leidke see.\"\"<\/p>\n

phpMyAdmin v\u00f5ib olla peidetud, n\u00e4iteks asuda alajaotisest \"Andmebaaside haldamine<\/strong>\", seega vaadake hoolikalt juhtpaneeli ja leidke see rakendus. Leidsime ja l\u00e4heme otse phpMyAdmini. Teie ees ilmub selline pilt:<\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

Leiate sellest failist rea:<\/p>\n

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

Ja valite just selle andmebaasi phpMyAdminis.<\/p>\n

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

\"\"<\/p>\n

Selles tabelis on salvestatud k\u00f5ik kasutajad (kui neid on mitu), kellel on juurdep\u00e4\u00e4s blogi haldamisele. Just siin saame me muuta parooli v\u00f5i kustutada kindla kasutaja \u2014 kl\u00f5psake wp_users ja avaneb kogu tabeli sisu.
\nSiin peame me parooli redigeerima. Blogiga, millega ma t\u00f6\u00f6tasin, oli n\u00e4ha, et peale administraatori oli registreeritud veel \u00fcks kasutaja, ja omanik teatas mulle, et kasutaja peaks olema ainult \u00fcks. See t\u00e4hendab, et keegi seal juba oli.
\nTabelis peame kl\u00f5psama pliiatsi m\u00e4rgil \"Redigeeri\" kasutajanime k\u00f5rval ja muutma parooli.<\/p>\n

\"\"<\/p>\n

Ees avanevad selle tabeli struktuur, kus n\u00e4eme k\u00f5iki andmeid, mis puudutavad seda kasutajat. Ma ei parem ei peatuks igal ribal \u2014 r\u00e4\u00e4gin vaid, kuidas parooli l\u00e4htestada.<\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

Et muuda parooli<\/strong> \u2014 teeme j\u00e4rgmist: rida user_pass<\/strong> parooli v\u00e4ljale kirjutame uue parooli, ja v\u00e4ljale varchar (64)<\/strong> \u2014 valige \u0161ifreerimise meetod MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Tehtud muudatused ja vajutame nuppu \u201eEdasi<\/strong>\u201d k\u00f5ige all ja salvestame uue parooli.<\/strong>.<\/p>\n

\"\"<\/p>\n

P\u00e4rast k\u00f5igi muudatuste salvestamist \u2014 see parool, mille olete m\u00e4\u00e4ranud, muutub j\u00e4lle MD5-ks, kuid see on just selline, nagu soovite. N\u00fc\u00fcd siseneme rahulikult blogi t\u00f6\u00f6kojaga uue parooliga.<\/p>\n

N\u00f5uanne.<\/em> \u00c4RGE KUNAGI<\/strong> kasutage sisselogimist admin<\/strong> ja lihtsad paroolid \u2014 see kaitseb teid ebameeldivate tagaj\u00e4rgede eest teie ressursi h\u00e4kitud korral. Muutke oma juurdep\u00e4\u00e4suandmed keerulisemaks ja \"kiiremaks\".<\/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 L\u00e4htestame parooli l\u00e4bi phpMyAdmin WordPressi veebihalduri jaoks | ProHoster","description":"Miks l\u00e4htestada parooli l\u00e4bi phpMyAdmin?","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 Taaskasutame phpMyAdmini kaudu parooli l\u00e4htestamist WordPressi saitide haldamiseks | #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}]}}