{"id":670,"date":"2026-10-07T15:47:01","date_gmt":"2026-10-07T13:47:01","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=670"},"modified":"2026-10-08T07:10:24","modified_gmt":"2026-10-08T05:10:24","slug":"narusene-spojeni-mysql-po-aktualizaci","status":"publish","type":"page","link":"https:\/\/cz.datenquelle.at\/index.php\/narusene-spojeni-mysql-po-aktualizaci\/","title":{"rendered":"Naru\u0161en\u00e9 spojen\u00ed MySQL po aktualizaci"},"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=\"Drobe\u010dkov\u00e1 navigace\"><a href=\"https:\/\/cz.datenquelle.at\/\">\u00davod<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Chyby & \u0158e\u0161en\u00ed<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/#datenbank\">P\u0159\u00edstup k datab\u00e1zi<\/a><\/nav><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>P\u0159\u00edstup k datab\u00e1zi<\/p><h1>Spojen\u00ed MySQL po aktualizaci p\u0159estalo fungovat<\/h1><p class=\"dq-lead\">Po aktualizaci mus\u00ed klient a server nad\u00e1le podporovat stejn\u00e9 postupy p\u0159ipojen\u00ed a p\u0159ihl\u00e1\u0161en\u00ed. Dosud funk\u010dn\u00ed heslo nedokazuje, \u017ee star\u0161\u00ed ovlada\u010d rozum\u00ed aktu\u00e1ln\u00edmu postupu. Konkr\u00e9tn\u00ed chybov\u00e9 hl\u00e1\u0161en\u00ed a ob\u011b verze jsou d\u016fle\u017eit\u011bj\u0161\u00ed ne\u017e slovo \u201eaktualizace\u201c.<\/p><ol class=\"dq-help-flow\" aria-label=\"Cesta dat a kontroln\u00ed bod\"><li><span>Zdroj<\/span><strong>Aplikace & Konektor<\/strong><\/li><li class=\"is-checkpoint\"><span>Ov\u011b\u0159it propojen\u00ed<\/span><strong>P\u0159ihl\u00e1\u0161en\u00ed & TLS<\/strong><\/li><li><span>C\u00edl<\/span><strong>Verze MySQL<\/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>Jak se to projevuje v praxi<\/h2><p>Existuj\u00edc\u00ed aplikace b\u011b\u017e\u00ed d\u00e1l, ale p\u0159\u00edstup k dat\u016fm sel\u017ee ihned po zm\u011bn\u011b serveru nebo ovlada\u010de. Ne\u017e n\u011bkdo zalo\u017e\u00ed nov\u00e9 \u00fa\u010dty, vyjasn\u00edme: zm\u011bnil se server MySQL, byl vym\u011bn\u011bn klient nebo se p\u0159esunula adresa p\u0159ipojen\u00ed?<\/p><\/section><section id=\"ursachen\"><h2>Rozli\u0161it typick\u00e9 p\u0159\u00ed\u010diny<\/h2><div class=\"dq-help-causes\"><div><h3>Star\u0161\u00ed postup p\u0159ihl\u00e1\u0161en\u00ed<\/h3><p>mysql_native_password je v MySQL 8.4 ve v\u00fdchoz\u00edm stavu deaktivov\u00e1n a od MySQL 9.0 odstran\u011bn. Zda to ovliv\u0148uje v\u00e1\u0161 p\u0159\u00edstup, z\u00e1vis\u00ed na \u00fa\u010dtu a klientovi.<\/p><\/div><div><h3>Klient a server aktualizov\u00e1ny odli\u0161n\u011b<\/h3><p>Star\u00fd konektor m\u016f\u017ee m\u00edt jin\u00e9 mo\u017enosti podpory ne\u017e nov\u00fd n\u00e1stroj spr\u00e1vy na stejn\u00e9m po\u010d\u00edta\u010di.<\/p><\/div><div><h3>Zm\u011bn\u011bna dal\u0161\u00ed nastaven\u00ed spojen\u00ed<\/h3><p>Mohla se zm\u011bnit tak\u00e9 c\u00edlov\u00e1 adresa, p\u0159i\u0159azen\u00ed \u00fa\u010dtu nebo certifik\u00e1ty. Ne ka\u017ed\u00e1 chyba po aktualizaci je probl\u00e9m pluginu.<\/p><\/div><\/div><\/section><section id=\"pruefen\"><h2>Co m\u016f\u017eete nejprve zkontrolovat<\/h2><ol class=\"dq-help-checks\"><li><h3>Zaznamenat produkt a verzi<\/h3><p>Posuzujte MySQL a MariaDB odd\u011blen\u011b. Zaznamenejte verzi serveru, verzi konektoru a p\u0159edchoz\u00ed funk\u010dn\u00ed kombinaci.<\/p><\/li><li><h3>Zaznamenat chybov\u00fd text m\u00edsto zkou\u0161en\u00ed hesel<\/h3><p>\u201eAccess denied\u201c, hl\u00e1\u0161en\u00ed pluginu a chyba certifik\u00e1tu jsou r\u016fzn\u00e9 informace. Z p\u0159\u00edklad\u016f odstra\u0148te p\u0159\u00edstupov\u00e9 \u00fadaje.<\/p><\/li><li><h3>Porovnat schv\u00e1len\u00ed a protokol zm\u011bn<\/h3><p>Ov\u011b\u0159te podporu aplikace pro nov\u00fd server. Zat\u00edm nem\u011b\u0148te produk\u010dn\u00ed \u00fa\u010dty ani ov\u011b\u0159ovac\u00ed postupy.<\/p><\/li><\/ol><\/section><section id=\"tiefer\"><h2>Kdy\u017e je probl\u00e9m hlub\u0161\u00ed<\/h2><p>Dlouhodob\u011b udr\u017eiteln\u00fdm \u0159e\u0161en\u00edm m\u016f\u017ee b\u00fdt podporovan\u00fd konektor nebo pl\u00e1novan\u00e1 \u00faprava aplikace. Op\u011btovn\u00e9 zapnut\u00ed vypnut\u00e9ho star\u00e9ho postupu nen\u00ed obecn\u00fdm \u0159e\u0161en\u00edm. Pro MariaDB plat\u00ed vlastn\u00ed dokumentace verz\u00ed a v\u00fdrobce; nastaven\u00ed MySQL se nep\u0159eb\u00edr\u00e1 bez ov\u011b\u0159en\u00ed.<\/p><div class=\"dq-help-details\"><details><summary>Posoudit aktualizaci jako test rozhran\u00ed<\/summary><p>P\u0159ihl\u00e1\u0161en\u00ed, p\u0159enos, pot\u0159ebn\u00e1 data a v\u011bcn\u00fd postup posuzujeme odd\u011blen\u011b. Tak lze zjistit, zda je dot\u010den jen p\u0159\u00edstup, nebo je pot\u0159eba upravit i dotazy, form\u00e1ty a dal\u0161\u00ed zpracov\u00e1n\u00ed.<\/p><\/details><details><summary>Kdy\u017e se aplikace u\u017e neudr\u017euje<\/summary><p>Pro prvn\u00ed tok dat vyjasn\u00edme, kter\u00e9 informace jsou skute\u010dn\u011b pot\u0159eba. Pokud nelze modernizovat p\u016fvodn\u00ed aplikaci, lze prov\u011b\u0159it povolen\u00fd export nebo odd\u011blen\u00e9 propojen\u00ed. Rozsah a provoz dohodneme p\u0159edem.<\/p><\/details><\/div><\/section><section id=\"weiter\"><h2>Kdy d\u00e1v\u00e1 podpora smysl<\/h2><p>Odborn\u00e1 podpora d\u00e1v\u00e1 smysl, kdy\u017e si neodpov\u00eddaj\u00ed v\u00fdrobci a verze ovlada\u010d\u016f nebo neudr\u017eovan\u00e1 aplikace blokuje provoz. Na za\u010d\u00e1tek sta\u010d\u00ed verze a anonymizovan\u00e9 chybov\u00e9 hl\u00e1\u0161en\u00ed.<\/p><a class=\"dq-help-service\" href=\"https:\/\/cz.datenquelle.at\/index.php\/dale-vyuzivat-starsi-systemy\/\"><span>Vhodn\u00e9 \u0159e\u0161en\u00ed<\/span><strong>Propojit existuj\u00edc\u00ed datab\u00e1ze s nov\u00fdmi po\u017eadavky<\/strong><span class=\"dq-ui-arrow\" aria-hidden=\"true\"><\/span><\/a><aside class=\"dq-help-cross\"><p>Pro v\u00fdb\u011br konektor\u016f, datov\u00e9 modely a slo\u017eit\u011bj\u0161\u00ed integra\u010dn\u00ed architekturu nab\u00edz\u00ed DataSource technick\u00e9 pokra\u010dov\u00e1n\u00ed.<\/p><a href=\"https:\/\/datasource.at\/\" rel=\"noopener\">Dal\u0161\u00ed informace u DataSource<span class=\"dq-ui-external\" aria-hidden=\"true\"><\/span><\/a><\/aside><\/section><section class=\"dq-help-sources\"><h2>Zdroje pro technickou orientaci<\/h2><ul><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/native-pluggable-authentication.html\" rel=\"noopener\">MySQL: Native Pluggable Authentication a hranice verz\u00ed<\/a><\/li><\/ul><p>Odborn\u011b ov\u011b\u0159eno 7. \u0159\u00edjna 2026. Informace v\u00fdrobc\u016f se vztahuj\u00ed k uveden\u00fdm produkt\u016fm; nenahrazuj\u00ed ov\u011b\u0159en\u00ed va\u0161\u00ed konkr\u00e9tn\u00ed konfigurace.<\/p><\/section><\/article><aside class=\"dq-help-toc\"><nav aria-label=\"Na t\u00e9to str\u00e1nce n\u00e1pov\u011bdy\"><span class=\"dq-kicker\">Na t\u00e9to str\u00e1nce<\/span><a href=\"#ursachen\">Typick\u00e9 p\u0159\u00ed\u010diny<\/a><a href=\"#pruefen\">Prvn\u00ed kontroly<\/a><a href=\"#tiefer\">Technick\u00e9 souvislosti<\/a><a href=\"#weiter\">Vhodn\u00e9 \u0159e\u0161en\u00ed<\/a><\/nav><div><span class=\"dq-kicker\">Souvisej\u00edc\u00ed probl\u00e9my<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/pristup-k-databazi-chyba-ssl-certifikatu\/\">P\u0159\u00edstup k datab\u00e1zi: chyba SSL certifik\u00e1tu<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/prevzit-data-ze-stareho-programu\/\">P\u0159evz\u00edt data ze star\u00e9ho programu<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Na p\u0159ehled t\u00e9mat<\/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>Spole\u010dn\u011b vyjasnit dal\u0161\u00ed krok.<\/h2><p>Na za\u010d\u00e1tek sta\u010d\u00ed n\u00e1zvy program\u016f a stru\u010dn\u00fd popis probl\u00e9mu.<\/p><\/div><a class=\"dq-button\" href=\"https:\/\/cz.datenquelle.at\/index.php\/proberme-vas-problem-s-daty\/\" aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\" data-dq-booking>Domluvit \u00favodn\u00ed rozhovor<\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Posu\u010fte p\u0159\u00edstup MySQL po aktualizaci: porovnejte klienta, ov\u011b\u0159ov\u00e1n\u00ed a TLS. Prov\u011b\u0159te p\u0159\u00ed\u010diny z\u00e1visl\u00e9 na verzi a MariaDB posuzujte zvl\u00e1\u0161\u0165.<\/p>\n","protected":false},"author":2,"featured_media":709,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-670","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=670"}],"version-history":[{"count":4,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/670\/revisions"}],"predecessor-version":[{"id":813,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/670\/revisions\/813"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/709"}],"wp:attachment":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}