{"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\/sv\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","title":{"rendered":"Hur \u00e5terst\u00e4ller jag l\u00f6senordet till WordPress-adminpanelen via phpMyAdmin p\u00e5 webbhotell?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Varf\u00f6r \u00e5terst\u00e4lla l\u00f6senordet via 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> webbhotell.<\/p>\n

Nyligen arbetade jag med en blogg som kr\u00e4vde direkt ingripande i databasen och \u00e5terst\u00e4llning av l\u00f6senordet, s\u00e5 jag best\u00e4mde mig f\u00f6r att skriva detta inl\u00e4gg s\u00e5 att ni, vid behov, skulle ha en sorts instruktion \"Hur man \u00e5terst\u00e4ller l\u00f6senordet till WordPress-adminpanelen via phpMyAdmin<\/strong> webbhotellet.\"<\/p>\n

S\u00e5, oavsett vad, men \u00e5tkomsten till webbhotellet i kontrollpanel<\/a> Din webbplats (webbplatser) ska du ha, och det r\u00e4cker f\u00f6r oss. Beroende p\u00e5 vilken webbhotellstj\u00e4nst du anv\u00e4nder kommer typ och utseende p\u00e5 kontrollpanelen f\u00f6r webbplatser att variera, men i varje s\u00e5dan panel finns en punkt \"phpMyAdmin\", s\u00e5 leta efter den.\"\"<\/p>\n

phpMyAdmin kan vara dolt, l\u00e5t oss s\u00e4ga, ligga under underrubriken \"Databasadministration<\/strong>\", s\u00e5 titta noggrant p\u00e5 kontrollpanelen och hitta denna applikation. N\u00e4r du har hittat den g\u00e5r vi direkt till phpMyAdmin. Det ser ut som f\u00f6ljande:<\/p>\n

\"\"<\/p>\n

H\u00e4r har vi m\u00f6jlighet att g\u00f6ra med v\u00e5ra databaser allt vi beh\u00f6ver, vi kan helt och h\u00e5llet hantera dem. Nu beh\u00f6ver vi hitta den databas som r\u00f6r v\u00e5r blogg. Om du inte kommer ih\u00e5g vilken databas fr\u00e5n listan (det kan finnas flera p\u00e5 v\u00e4nster sida) som r\u00f6r din resurs, kolla bara filen wp-config.php, d\u00e4r har du skrivit ner all denna information.<\/p>\n

\"\"<\/p>\n

Hitta i denna fil raden:<\/p>\n

define('DB_NAME', 'Namnet p\u00e5 din databas')<\/strong>;<\/p>\n

Och precis denna databas v\u00e4ljer du i phpMyAdmin.<\/p>\n

Klicka p\u00e5 denna databas s\u00e5 \u00f6ppnas hela strukturen, alla tabeller som vi kan \u00e4ndra. Nu \u00e4r vi intresserade av tabellenwp_users<\/strong>.<\/p>\n

\"\"<\/p>\n

I denna tabell \u00e4r alla anv\u00e4ndare (om det finns flera) som har tillg\u00e5ng till bloggadministrationen registrerade. H\u00e4r kan vi \u00e4ndra l\u00f6senordet eller ta bort en viss anv\u00e4ndare \u2013 klicka p\u00e5 wp_users s\u00e5 \u00f6ppnas hela tabellens inneh\u00e5ll.
\nH\u00e4r beh\u00f6ver vi redigera l\u00f6senordet. I det fall av bloggen jag arbetade med var det synligt att f\u00f6rutom administrat\u00f6ren var det registrerat en annan anv\u00e4ndare, och \u00e4garen meddelade mig att det bara skulle finnas en anv\u00e4ndare. S\u00e5 n\u00e5gon har redan varit d\u00e4r.
\nI tabellen m\u00e5ste vi klicka p\u00e5 pennikonen \"Redigera\" bredvid anv\u00e4ndarnamnet och \u00e4ndra l\u00f6senordet.<\/p>\n

\"\"<\/p>\n

Vi kommer att se strukturen i denna tabell d\u00e4r vi ser alla uppgifter som r\u00f6r den h\u00e4r anv\u00e4ndaren. Jag kommer inte att g\u00e5 in p\u00e5 detaljer kring varje rad \u2013 jag kommer bara att ber\u00e4tta hur man \u00e5terst\u00e4ller l\u00f6senordet.<\/p>\n

\"\"<\/p>\n

F\u00f6r n\u00e4rvarande \u00e4r v\u00e5rt l\u00f6senord krypterat med MD5-metoden, s\u00e5 i den aktuella raden ser vi of\u00f6rst\u00e5eliga tecken.<\/p>\n

\"\"<\/p>\n

F\u00f6r att \u00e4ndra l\u00f6senord<\/strong> \u2013 g\u00f6r f\u00f6ljande: i raden user_pass<\/strong> skriver vi det nya l\u00f6senordet i l\u00f6senordsf\u00e4ltet och i f\u00e4ltet varchar (64)<\/strong> \u2013 v\u00e4lj krypteringsmetod MD5<\/strong>.<\/p>\n

\"\"<\/p>\n

Vi har gjort \u00e4ndringarna och klickar p\u00e5 knappen \"Forts\u00e4tt<\/strong>\u00bb l\u00e4ngst ner och sparar det nya l\u00f6senordet<\/strong>.<\/p>\n

\"\"<\/p>\n

Efter att ha sparat alla \u00e4ndringar \u2013 kommer det l\u00f6senord du angav att \u00e5terigen bli MD5, men det blir det som du beh\u00f6ver. Nu kan du lugnt logga in p\u00e5 bloggverkstaden med det nya l\u00f6senordet.<\/p>\n

Tips.<\/em> ALDRIG<\/strong> anv\u00e4nda anv\u00e4ndarnamn admin<\/strong> och enkla l\u00f6senord \u2013 detta skyddar dig fr\u00e5n o\u00f6nskade konsekvenser av en eventuell hackning av din resurs. \u00c4ndra dina inloggningsuppgifter till mer komplexa och \"konstiga\".<\/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 \u00c5terst\u00e4ll l\u00f6senordet via phpMyAdmin f\u00f6r WordPress-adminpanelen | ProHoster","description":"Varf\u00f6r \u00e5terst\u00e4lla l\u00f6senordet via phpMyAdmin?","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/raznoe\/kak-sbrosit-parol-k-adminke-wordpress-cherez-phpm","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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\/sv\/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 \u00c5terst\u00e4ll l\u00f6senordet via phpMyAdmin f\u00f6r WordPress-adminpanelen | #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\/sv\/wp-json\/wp\/v2\/posts\/41885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=41885"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/41885\/revisions"}],"predecessor-version":[{"id":157656,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/41885\/revisions\/157656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=41885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=41885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=41885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}