{"id":87,"date":"2016-12-30T11:33:45","date_gmt":"2016-12-30T10:33:45","guid":{"rendered":"https:\/\/debnar.org\/wp\/?p=87"},"modified":"2017-01-09T20:46:26","modified_gmt":"2017-01-09T19:46:26","slug":"http-mysql-wordpress-mindennel-szivas","status":"publish","type":"post","link":"https:\/\/debnar.org\/wp\/?p=87","title":{"rendered":"HTTP, MySQL, WordPress… mindennel sz\u00edv\u00e1s"},"content":{"rendered":"

Ha m\u00e1r a Chromen\u00e1l kital\u00e1lt\u00e1k, hogy https-t mindenhova (m\u00e1r azt\u00e1n ide is baromi fontos, h\u00e1t m\u00e9g a http:\/\/motherfuckingwebsite.com\/<\/a> -ra).[1]<\/a> No meg am\u00fagyis j\u00f3 m\u00f3ka konfigolni ilyet. Persze szok\u00e1s szerint semmi nem m\u0171k\u00f6d\u00f6tt. Eleve a certbot rewrite-ot pakolt be redirect helyett, de ez egy viszonylag egyszer\u0171bb probl\u00e9ma (lsd.: http:\/\/httpd.apache.org\/docs\/current\/rewrite\/avoid.html#redirect<\/a> ). Alapb\u00f3l mivel az oldal titkos\u00edtatlan volt ez\u00e9rt most sz\u00e9pen \u00f6sszeakadt, hogy redirectelni pr\u00f3b\u00e1lta az apache, egyes r\u00e9szek nem t\u00f6lt\u00f6ttek be, az admin fel\u00fclet loginkor v\u00e9gtelen loopba keveredett). \u00dagyhogy el\u0151sz\u00f6r ne<\/strong> aktiv\u00e1ljuk a https-t.<\/p>\n

<\/p>\n

Azt\u00e1n j\u00f6tt, hogy a jelsz\u00f3t is elfelejtettem, m\u00e9g a MySQL root jelszav\u00e1t is, nemhogy a WordPress loginom…<\/p>\n

MySQL root jelsz\u00f3 ki\u00fct\u00e9se (5.5)<\/h3>\n

# service mysql stop
\n# mysqld_safe –skip-grant-tables
\nmysql> use mysql;
\nmysql> update user set password=PASSWORD(“mynewpassword”) where User=’root’;
\nmysql> flush privileges;
\nmysql> quit
\n# service mysql start
\n# mysql -u root -p #megadjuk jelsz\u00f3nak a mynewpassword-\u00f6t
\nmysql> use mysql;
\nmysql> update user set password=PASSWORD(“\u00fajtitkosjelsz\u00f3”) where User=’root’;<\/p><\/blockquote>\n

Persze megadhatjuk r\u00f6gt\u00f6n a titkos a jelsz\u00f3t mynewpassword<\/em> helyett.<\/p>\n

WordPress jelsz\u00f3 megv\u00e1ltoztat\u00e1sa MySQL-b\u0151l<\/h3>\n

mysql> USE wordpress;
\nmysql> SELECT * FROM wp_user;
\nmysql> UPDATE wp_users SET user_pass=”5f4dcc3b5aa765d61d8327deb882cf99″ WHERE ID = (1);<\/p><\/blockquote>\n

Az utols\u00f3 mysql parancsban a user_pass<\/em> ut\u00e1n egy sima md5hash van. Ezt a legk\u00f6nnyebben \u00fagy kapjuk meg, hogy<\/p>\n

echo -n jelszo | md5sum<\/p><\/blockquote>\n

parancsot be\u00edrjuk konzolba (v\u00e9g\u00e9r\u0151l a – jelet ne m\u00e1soljuk \u00e1t).<\/p>\n

A WHERE ID<\/em> pedig az a sz\u00e1m ami a megv\u00e1ltozatni k\u00edv\u00e1nt userneve mellett \u00e1ll a SELECT * FROM wp_user<\/em> sorban.<\/p>\n

Ezekut\u00e1n ha szerencs\u00e9nk van m\u00e1r loginolni is tudunk.<\/p>\n

HTTP -> HTTPS WordPress m\u00f3dra<\/h3>\n

El\u0151sz\u00f6r is a Settingsben \u00e1ll\u00edtsuk \u00e1t az oldal el\u00e9r\u00e9s\u00fcnket http-r\u0151l https-re. Majd rakjuk fel a https:\/\/wordpress.org\/plugins\/http-https-remover\/<\/a> plugint, ami sz\u00e9pen \u00e1tny\u00e1lazza az oldalt \u00e9s lecser\u00e9li a http linkeket. \u00cdgy m\u00e1r feltehet\u0151leg j\u00f3 lesz.<\/p>\n

Ezut\u00e1n m\u00e1r aktiv\u00e1lhatjuk a https-t.<\/p>\n

 <\/p>\n

Hivatkoz\u00e1sok<\/h3>\n

[1] http:\/\/www.zdnet.com\/article\/chrome-will-begin-marking-http-pages-as-non-secure\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Ha m\u00e1r a Chromen\u00e1l kital\u00e1lt\u00e1k, hogy https-t mindenhova (m\u00e1r azt\u00e1n ide is baromi fontos, h\u00e1t m\u00e9g a http:\/\/motherfuckingwebsite.com\/ -ra).[1] No meg am\u00fagyis j\u00f3 m\u00f3ka konfigolni ilyet. Persze szok\u00e1s szerint semmi nem m\u0171k\u00f6d\u00f6tt. Eleve a certbot rewrite-ot pakolt be redirect helyett, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,2,4],"tags":[14,16,13,12,15],"class_list":["post-87","post","type-post","status-publish","format-standard","hentry","category-jelszo-visszaallitas","category-mysql","category-szerver-felugyelet","tag-elfelejtett","tag-https","tag-jelszo","tag-mysql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=87"}],"version-history":[{"count":2,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/87\/revisions"}],"predecessor-version":[{"id":89,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/87\/revisions\/89"}],"wp:attachment":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=87"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=87"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}