{"id":789,"date":"2026-10-07T15:47:01","date_gmt":"2026-10-07T13:47:01","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=789"},"modified":"2026-10-08T07:10:59","modified_gmt":"2026-10-08T05:10:59","slug":"mysql-kapcsolati-hiba-frissites-utan","status":"publish","type":"page","link":"https:\/\/hu.datenquelle.at\/index.php\/mysql-kapcsolati-hiba-frissites-utan\/","title":{"rendered":"MySQL-kapcsolati hiba friss\u00edt\u00e9s ut\u00e1n"},"content":{"rendered":"<div class=\"et_pb_section_0 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_0 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_0 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_0 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-hero\" id=\"dq-main\"><div class=\"dq-wrap\"><nav class=\"dq-breadcrumbs\" aria-label=\"Morzsanavig\u00e1ci\u00f3\"><a href=\"https:\/\/hu.datenquelle.at\/\">Kezd\u0151lap<\/a><span>\/<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/\">Hib\u00e1k & Megold\u00e1sok<\/a><span>\/<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/#datenbank\">Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s<\/a><\/nav><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s<\/p><h1>A MySQL-kapcsolat friss\u00edt\u00e9s ut\u00e1n m\u00e1r nem m\u0171k\u00f6dik<\/h1><p class=\"dq-lead\">Friss\u00edt\u00e9s ut\u00e1n a kliensnek \u00e9s a kiszolg\u00e1l\u00f3nak tov\u00e1bbra is ugyanazokat a kapcsol\u00f3d\u00e1si \u00e9s bejelentkez\u00e9si elj\u00e1r\u00e1sokat kell t\u00e1mogatnia. A kor\u00e1bban m\u0171k\u00f6d\u0151 jelsz\u00f3 nem bizony\u00edtja, hogy egy r\u00e9gebbi illeszt\u0151program \u00e9rti az aktu\u00e1lis elj\u00e1r\u00e1st. A konkr\u00e9t hiba\u00fczenet \u00e9s mindk\u00e9t verzi\u00f3 fontosabb a \u201efriss\u00edt\u00e9s\u201d sz\u00f3n\u00e1l.<\/p><ol class=\"dq-help-flow\" aria-label=\"Adat\u00fat \u00e9s ellen\u0151rz\u00e9si pont\"><li><span>Forr\u00e1s<\/span><strong>Alkalmaz\u00e1s & Csatlakoz\u00f3<\/strong><\/li><li class=\"is-checkpoint\"><span>A kapcsolat ellen\u0151rz\u00e9se<\/span><strong>Bejelentkez\u00e9s & TLS<\/strong><\/li><li><span>C\u00e9l<\/span><strong>MySQL-verzi\u00f3<\/strong><\/li><\/ol><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_1 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_1 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_1 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_1 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-body\"><div class=\"dq-wrap\"><div class=\"dq-help-layout\"><article class=\"dq-help-article\"><section class=\"dq-help-situation\"><h2>\u00cdgy jelenik meg a mindennapokban<\/h2><p>A megl\u00e9v\u0151 alkalmaz\u00e1s tov\u00e1bb fut, de az adathozz\u00e1f\u00e9r\u00e9se k\u00f6zvetlen\u00fcl kiszolg\u00e1l\u00f3- vagy illeszt\u0151program-csere ut\u00e1n meghi\u00fasul. \u00daj fi\u00f3kok l\u00e9trehoz\u00e1sa el\u0151tt tiszt\u00e1zzuk: a MySQL-kiszolg\u00e1l\u00f3 v\u00e1ltozott, a klienst cser\u00e9lt\u00e9k le, vagy a kapcsolati c\u00edm m\u00f3dosult?<\/p><\/section><section id=\"ursachen\"><h2>Tipikus okok elk\u00fcl\u00f6n\u00edt\u00e9se<\/h2><div class=\"dq-help-causes\"><div><h3>R\u00e9gebbi bejelentkez\u00e9si elj\u00e1r\u00e1s<\/h3><p>A mysql_native_password a MySQL 8.4-ben alap\u00e9rtelmezetten kikapcsolt, a MySQL 9.0-t\u00f3l pedig elt\u00e1vol\u00edtott\u00e1k. Hogy ez \u00e9rinti-e a hozz\u00e1f\u00e9r\u00e9s\u00e9t, a fi\u00f3kt\u00f3l \u00e9s klienst\u0151l f\u00fcgg.<\/p><\/div><div><h3>Elt\u00e9r\u0151en friss\u00edtett kliens \u00e9s kiszolg\u00e1l\u00f3<\/h3><p>Egy r\u00e9gi csatlakoz\u00f3 m\u00e1s t\u00e1mogat\u00e1st ny\u00fajthat, mint az ugyanazon g\u00e9pen l\u00e9v\u0151 \u00faj adminisztr\u00e1ci\u00f3s eszk\u00f6z.<\/p><\/div><div><h3>Tov\u00e1bbi kapcsolati be\u00e1ll\u00edt\u00e1sok m\u00f3dosultak<\/h3><p>A c\u00e9lc\u00edm, fi\u00f3khozz\u00e1rendel\u00e9s vagy tan\u00fas\u00edtv\u00e1nyok is v\u00e1ltozhattak. Nem minden friss\u00edt\u00e9s ut\u00e1ni hiba pluginprobl\u00e9ma.<\/p><\/div><\/div><\/section><section id=\"pruefen\"><h2>Amit el\u0151sz\u00f6r ellen\u0151rizhet<\/h2><ol class=\"dq-help-checks\"><li><h3>Term\u00e9k \u00e9s verzi\u00f3 feljegyz\u00e9se<\/h3><p>A MySQL-t \u00e9s a MariaDB-t k\u00fcl\u00f6n kezelje. R\u00f6gz\u00edtse a kiszolg\u00e1l\u00f3 \u00e9s a csatlakoz\u00f3 verzi\u00f3j\u00e1t, valamint a kor\u00e1bbi m\u0171k\u00f6d\u0151 kombin\u00e1ci\u00f3t.<\/p><\/li><li><h3>Hibasz\u00f6veg gy\u0171jt\u00e9se jelsz\u00f3pr\u00f3b\u00e1lgat\u00e1s helyett<\/h3><p>Az \u201eAccess denied\u201d, a plugin\u00fczenet \u00e9s a tan\u00fas\u00edtv\u00e1nyhiba k\u00fcl\u00f6nb\u00f6z\u0151 jelz\u00e9sek. T\u00e1vol\u00edtsa el a hozz\u00e1f\u00e9r\u00e9si adatokat a p\u00e9ld\u00e1kb\u00f3l.<\/p><\/li><li><h3>J\u00f3v\u00e1hagy\u00e1sok \u00e9s v\u00e1ltoz\u00e1snapl\u00f3 \u00f6sszehasonl\u00edt\u00e1sa<\/h3><p>Ellen\u0151rizze, hogy az alkalmaz\u00e1s t\u00e1mogatja-e az \u00faj kiszolg\u00e1l\u00f3t. Egyel\u0151re ne m\u00f3dos\u00edtsa az \u00e9les fi\u00f3kokat vagy hiteles\u00edt\u00e9si elj\u00e1r\u00e1sokat.<\/p><\/li><\/ol><\/section><section id=\"tiefer\"><h2>Ha m\u00e9lyebben van a probl\u00e9ma<\/h2><p>Tart\u00f3s megold\u00e1s lehet egy t\u00e1mogatott csatlakoz\u00f3 vagy az alkalmaz\u00e1s tervezett m\u00f3dos\u00edt\u00e1sa. A kikapcsolt r\u00e9gi elj\u00e1r\u00e1s visszakapcsol\u00e1sa nem \u00e1ltal\u00e1nos megold\u00e1s. A MariaDB-hez saj\u00e1t verzi\u00f3- \u00e9s gy\u00e1rt\u00f3i dokument\u00e1ci\u00f3 tartozik; a MySQL-be\u00e1ll\u00edt\u00e1sokat nem vessz\u00fck \u00e1t ellen\u0151rz\u00e9s n\u00e9lk\u00fcl.<\/p><div class=\"dq-help-details\"><details><summary>A friss\u00edt\u00e9s interf\u00e9sztesztk\u00e9nt val\u00f3 vizsg\u00e1lata<\/summary><p>K\u00fcl\u00f6n vizsg\u00e1ljuk a bejelentkez\u00e9st, \u00e1tvitelt, sz\u00fcks\u00e9ges adatokat \u00e9s \u00fczleti folyamatot. \u00cdgy felismerhet\u0151, hogy csak a hozz\u00e1f\u00e9r\u00e9s \u00e9rintett-e, vagy a lek\u00e9rdez\u00e9seket, form\u00e1tumokat \u00e9s tov\u00e1bbi feldolgoz\u00e1st is m\u00f3dos\u00edtani kell.<\/p><\/details><details><summary>Ha az alkalmaz\u00e1st m\u00e1r nem tartj\u00e1k karban<\/summary><p>Az els\u0151 adatfolyamhoz tiszt\u00e1zzuk, mely inform\u00e1ci\u00f3kra van t\u00e9nylegesen sz\u00fcks\u00e9g. Ha az eredeti alkalmaz\u00e1s nem moderniz\u00e1lhat\u00f3, megvizsg\u00e1lhat\u00f3 egy enged\u00e9lyezett export vagy elk\u00fcl\u00f6n\u00edtett kapcsolat. A terjedelmet \u00e9s m\u0171k\u00f6d\u00e9st el\u0151re egyeztetj\u00fck.<\/p><\/details><\/div><\/section><section id=\"weiter\"><h2>Mikor hasznos a seg\u00edts\u00e9g<\/h2><p>Szakmai seg\u00edts\u00e9g hasznos, ha a gy\u00e1rt\u00f3k \u00e9s illeszt\u0151program-verzi\u00f3k nem illeszkednek, vagy egy karbantartatlan alkalmaz\u00e1s blokkolja a m\u0171k\u00f6d\u00e9st. Indul\u00e1sk\u00e9nt el\u00e9g a verzi\u00f3k \u00e9s az anonimiz\u00e1lt hiba\u00fczenet.<\/p><a class=\"dq-help-service\" href=\"https:\/\/hu.datenquelle.at\/index.php\/regi-rendszerek-tovabbi-hasznalata\/\"><span>A megfelel\u0151 megold\u00e1s<\/span><strong>Megl\u00e9v\u0151 adatb\u00e1zisok \u00f6sszekapcsol\u00e1sa \u00faj ig\u00e9nyekkel<\/strong><span class=\"dq-ui-arrow\" aria-hidden=\"true\"><\/span><\/a><aside class=\"dq-help-cross\"><p>Csatlakoz\u00f3v\u00e1laszt\u00e1sban, adatmodellekben \u00e9s \u00f6sszetettebb integr\u00e1ci\u00f3s architekt\u00far\u00e1ban a DataSource ny\u00fajt m\u0171szaki folytat\u00e1st.<\/p><a href=\"https:\/\/datasource.at\/\" rel=\"noopener\">Tov\u00e1bbi inform\u00e1ci\u00f3k a DataSource-n\u00e1l<span class=\"dq-ui-external\" aria-hidden=\"true\"><\/span><\/a><\/aside><\/section><section class=\"dq-help-sources\"><h2>Forr\u00e1sok a m\u0171szaki eligaz\u00edt\u00e1shoz<\/h2><ul><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/native-pluggable-authentication.html\" rel=\"noopener\">MySQL: Native Pluggable Authentication \u00e9s verzi\u00f3hat\u00e1rok<\/a><\/li><\/ul><p>Szakmailag ellen\u0151rizve: 2026. okt\u00f3ber 7. A gy\u00e1rt\u00f3i adatok az adott term\u00e9kekre vonatkoznak; nem helyettes\u00edtik az \u00d6n konkr\u00e9t konfigur\u00e1ci\u00f3j\u00e1nak ellen\u0151rz\u00e9s\u00e9t.<\/p><\/section><\/article><aside class=\"dq-help-toc\"><nav aria-label=\"Ezen a s\u00fag\u00f3oldalon\"><span class=\"dq-kicker\">Ezen az oldalon<\/span><a href=\"#ursachen\">Tipikus okok<\/a><a href=\"#pruefen\">Els\u0151 ellen\u0151rz\u00e9sek<\/a><a href=\"#tiefer\">M\u0171szaki \u00f6sszef\u00fcgg\u00e9sek<\/a><a href=\"#weiter\">Megfelel\u0151 megold\u00e1s<\/a><\/nav><div><span class=\"dq-kicker\">Kapcsol\u00f3d\u00f3 probl\u00e9m\u00e1k<\/span><a href=\"https:\/\/hu.datenquelle.at\/index.php\/adatbazis-hozzaferes-ssl-tanusitvanyhiba\/\">Adatb\u00e1zis-hozz\u00e1f\u00e9r\u00e9s: SSL-tan\u00fas\u00edtv\u00e1nyhiba<\/a><a href=\"https:\/\/hu.datenquelle.at\/index.php\/adatok-atvetele-regi-programbol\/\">Adatok \u00e1tv\u00e9tele r\u00e9gi programb\u00f3l<\/a><a href=\"https:\/\/hu.datenquelle.at\/index.php\/hibak-es-megoldasok-az-adataihoz\/\">Ugr\u00e1s a t\u00e9m\u00e1k \u00e1ttekint\u00e9s\u00e9hez<\/a><\/div><\/aside><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_2 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_2 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_2 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_2 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-contact-section\"><div class=\"dq-wrap\"><div class=\"dq-help-contact\"><div><h2>K\u00f6z\u00f6sen tiszt\u00e1zni a k\u00f6vetkez\u0151 l\u00e9p\u00e9st.<\/h2><p>Indul\u00e1sk\u00e9nt el\u00e9g a programok neve \u00e9s egy r\u00f6vid probl\u00e9male\u00edr\u00e1s.<\/p><\/div><a class=\"dq-button\" href=\"https:\/\/hu.datenquelle.at\/index.php\/adatproblema-megbeszelese\/\" aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\" data-dq-booking>Els\u0151 megbesz\u00e9l\u00e9s egyeztet\u00e9se<\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>MySQL-hozz\u00e1f\u00e9r\u00e9s \u00e9rtelmez\u00e9se friss\u00edt\u00e9s ut\u00e1n: kliens, hiteles\u00edt\u00e9s \u00e9s TLS \u00f6sszehasonl\u00edt\u00e1sa. Verzi\u00f3f\u00fcgg\u0151 okok vizsg\u00e1lata \u00e9s a MariaDB k\u00fcl\u00f6n kezel\u00e9se.<\/p>\n","protected":false},"author":2,"featured_media":828,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-789","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=789"}],"version-history":[{"count":4,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/789\/revisions"}],"predecessor-version":[{"id":907,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/789\/revisions\/907"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/828"}],"wp:attachment":[{"href":"https:\/\/hu.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}