{"id":897,"date":"2019-06-19T11:35:00","date_gmt":"2019-06-19T09:35:00","guid":{"rendered":"https:\/\/support.versa.host\/?p=897"},"modified":"2026-05-28T22:10:54","modified_gmt":"2026-05-28T20:10:54","slug":"tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel","status":"publish","type":"post","link":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/","title":{"rendered":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Volt m\u00e1r kor\u00e1bban egy cikk\u00fcnk arr\u00f3l, hogy a cPanel PREMIUM&nbsp;<a href=\"https:\/\/versanus.eu\/hu\/webtarhely\">webt\u00e1rhely<\/a>&nbsp;csomagunkat igazi kock\u00e1knak tervezt\u00fck, de mondhatn\u00e1nk \u00fagy is, hogy igazi fejleszt\u0151knek. Azt\u00e1n elind\u00edtottuk a&nbsp;<a href=\"https:\/\/versanus.eu\/hu\/webtarhely\">Python<\/a>&nbsp;csomagot is, amelyben szint\u00e9n el\u00e9rhet\u0151 a GIT \u00e9s az SSH. Most ezt terjesztj\u00fck ki SSH Tunnelel, t\u00e1voli MySQL el\u00e9r\u00e9s\u00e9hez.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">SSH hozz\u00e1f\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Miut\u00e1n megkapta a cPanel hozz\u00e1f\u00e9r\u00e9st, l\u00e9pjen be. A Vez\u00e9rl\u0151pulton keresse meg a Biztons\u00e1g szekci\u00f3n bel\u00fcl az &#8222;SSH hozz\u00e1f\u00e9r\u00e9s&#8221; men\u00fcpontot. A bet\u00f6lt\u0151d\u0151 \u00faj oldalon kattintson az &#8222;SSH-kulcsok kezel\u00e9se&#8221; felirat\u00fa gombra, ahol azt\u00e1n k\u00e9t lehet\u0151s\u00e9ge lesz. Az egyik, hogy gener\u00e1l egy \u00faj kulcsot, a m\u00e1sik, hogy a m\u00e1r megl\u00e9v\u0151t import\u00e1lja.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-01.jpg\" alt=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A szak\u00e9rt\u0151knek nem kell bemutatni ezt a folyamatot, val\u00f3sz\u00edn\u0171leg rendelkeznek is saj\u00e1t SSH kulccsal. Kedvcsin\u00e1l\u00f3nak az\u00e9rt v\u00e9gig megy\u00fcnk egy p\u00e9ld\u00e1n, ahol \u00faj kulcsot gener\u00e1lunk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kattintson az &#8222;\u00daj kulcs gener\u00e1l\u00e1sa&#8221; felirat\u00fa gombra, \u00e9s t\u00f6ltse ki az \u0171rlapot:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Key Name (This value defaults to \u201cid_rsa\u201d.): &#8211; ide \u00edrja be a haszn\u00e1lni k\u00edv\u00e1nt nevet. Lehet c\u00e9gn\u00e9v, projektn\u00e9v, a weboldal neve, vagy a webfejleszt\u0151 neve. Ne haszn\u00e1ljon \u00e9kezetet, se sz\u00f3k\u00f6z\u00f6ket.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kulcs jelsz\u00f3: &#8211; az SSH kulcsot is jelsz\u00f3 v\u00e9di, \u00edgy meg kell adni egym\u00e1s ut\u00e1n k\u00e9tszer is a jelsz\u00f3t, de haszn\u00e1lhatja a jelsz\u00f3gener\u00e1tort is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A kulcs t\u00edpus\u00e1n\u00e1l hagyja az RSA-n, a m\u00e9ret\u00e9n\u00e9l pedig elegend\u0151 a 2048-as is, de haszn\u00e1lhatja az er\u0151sebb 4096-os kulcsm\u00e9retet is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kattintson a lenti &#8222;Kulcs gener\u00e1l\u00e1sa&#8221; felirat\u00fa gombra. \u00c9s a kulcs gener\u00e1l\u00e1sa el is k\u00e9sz\u00fclt. Itt visszaigazol\u00f3 sz\u00f6vegek jelennek meg, ami alatt megjelent egy &#8222;Visszal\u00e9p\u00e9s\u201d c\u00edm\u0171 link. Kattintson r\u00e1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-02.jpg\" alt=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A list\u00e1ban most m\u00e1r megjelent az el\u0151bb l\u00e9trehozott kulcs, melyn\u00e9l a felhatalmaz\u00e1s \u00e1llapot\u00e1n\u00e1l a &#8222;not authorized&#8221; sz\u00f6veg l\u00e1that\u00f3. Ez azt jelenti, hogy a kulcs m\u00e1r k\u00e9sz, de nem haszn\u00e1lhat\u00f3 a fi\u00f3khoz. Ez azt a c\u00e9lt szolg\u00e1lja, hogy a hozz\u00e1f\u00e9r\u00e9st ki\/be lehet kapcsolni, nem kell mindig \u00fajat gener\u00e1lni vagy import\u00e1lni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A &#8222;Kezel\u00e9s&#8221; opci\u00f3ra kattintva lehet aktiv\u00e1lni. Bet\u00f6lt\u0151dik egy \u00faj oldal, ahol egy kis k\u00eds\u00e9r\u0151 sz\u00f6veg alatt megjelenik egy &#8222;Authorize&#8221; nev\u0171 gomb. Klikk r\u00e1, \u00e9s k\u00e9sz is vagyunk. A kulcs enged\u00e9lyezve lett.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A &#8222;Megtekint\u00e9s\/Let\u00f6lt\u00e9s&#8221; m\u0171veletekkel pedig hozz\u00e1f\u00e9r a nyilv\u00e1nos \u00e9s a titkos kulcs is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kattintson el\u0151bb a Nyilv\u00e1nos kulcsok t\u00e1bl\u00e1zatban l\u00e1that\u00f3 gombra. Ekkor sz\u00f6veges form\u00e1tumban megjelenik a kulcs. Ki tudja mag\u00e1nak m\u00e1solni egy sz\u00f6veges (TXT) f\u00e1jlba, van a &#8222;Kulcs let\u00f6lt\u00e9se&#8221; gombra kattintva lementheti pub form\u00e1tumban, ami gyakorlatilag szint\u00e9n csak egy egyszer\u0171 sz\u00f6veges f\u00e1jl. \u2013 K\u00e9s\u0151bb ezt fogjuk haszn\u00e1lni a GIT-hez \u00e9s ezt tudja kiadni partnereknek is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A Titkos kulcsok t\u00e1bl\u00e1zat\u00e1ban ha ugyan erre a m\u0171veletre kattint tudja let\u00f6lteni a titkos, azaz private key-t, ugyan \u00fagy, mint az el\u0151bb, de PPK form\u00e1tumra konvert\u00e1lva is let\u00f6ltheti, a kulcs gener\u00e1l\u00e1s\u00e1n\u00e1l megadott jelsz\u00f3 haszn\u00e1lat\u00e1val. T\u00f6lts\u00f6n le mindent a saj\u00e1t g\u00e9p\u00e9re. \u2013 Ez az\u00e9rt titkos, mert nem adja ki k\u00e9s\u0151bb se senkinek!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-03.jpg\" alt=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ezzel el is k\u00e9sz\u00fclt. Most m\u00e1r van a cPanel t\u00e1rhely\u00e9hez akt\u00edv SSH kulcs \u00e9s a g\u00e9p\u00e9re le is t\u00f6lt\u00f6tte a titkos kulcsokat is minden form\u00e1ban.&nbsp;<strong>K\u00e9szen \u00e1ll a munk\u00e1ra!<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">SSH hozz\u00e1f\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Windows oper\u00e1ci\u00f3s rendszeren a&nbsp;<a href=\"https:\/\/www.chiark.greenend.org.uk\/~sgtatham\/putty\/latest.html\" target=\"_blank\" rel=\"noreferrer noopener\">PuTTY<\/a>&nbsp;SSH kliens programot javasoljuk. T\u00f6ltse le, ind\u00edtsa el, amjd programban r\u00f6gt\u00f6n az els\u0151 ablakban t\u00f6ltse ki az al\u00e1bbi mez\u0151ket:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Host Name (or IP address): &#8211; ide \u00edrja be a haszn\u00e1lt cPanel szerver IP c\u00edm\u00e9t, egyedi IP c\u00edm eset\u00e9n a saj\u00e1tj\u00e1t. Port: 4231<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A Saved Session mez\u0151be \u00edrjon valamint, amivel azonos\u00edtani tudja a szervert. IP-c\u00edm, weboldal, stb, ami alapj\u00e1n majd tudja, hogy ez hova fog csatlakozni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A bal oldali Category oszlopban navig\u00e1ljon ide: Connection \/ SSH \/ Auth. Itt a Private key file for authentication mez\u0151ben tall\u00f3zza ki a let\u00f6lt\u00f6tt titkos PPK f\u00e1jlt.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-04.jpg\" alt=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Azt\u00e1n ugyan itt, a bal oldali Category oszlopban navig\u00e1ljon a: Connection \/ SSH \/ Tunnels men\u00fcpontba. Itt a Source port mez\u0151be \u00edrja be a 3306-ot, azaz az sql portsz\u00e1m\u00e1t, majd a Destination-be ezt: localhost:3306, majd kattintson a mellett\u00fck l\u00e9v\u0151 ADD gombra. Ekkor beker\u00f3l a sor a Forwarded ports list\u00e1ba.<img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-04a.jpg\" alt=\"\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Menjen vissza a Category oszlopban a Session r\u00e9szre, \u00e9s kattintson a &#8222;SAVE&#8221; gombra. Ezzel elmentette a kapcsol\u00f3d\u00e1st a szerverhez. El\u00e9g ezeket a param\u00e9tereket megadni neki. T\u00f6bbet nem kell \u00e1ll\u00edtgatni, legk\u00f6zelebb, a Putty ind\u00edt\u00e1s\u00e1val csak kiv\u00e1lasztja a mentett Session-t, \u00e9s m\u00e1r csatlakozhat is a szerverre, amelyen kereszt\u00fcl most m\u00e1r el\u00e9ri a t\u00e1voli adatb\u00e1zis \u00fagy, hogy az SSH kapcsolat oda ir\u00e1ny\u00edtja a 3306-os porton a kapcsolatot.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az &#8222;OPEN&#8221; gombra kattintva nyitja meg az SSH kapcsolatot a szerverrel. Felugrik egy fekete ablak, ahol els\u0151 esetben egy &#8222;Igen&#8221; gomb megnyom\u00e1s\u00e1val el kell fogadnia annak tartalm\u00e1t.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">login as: &#8211; ide \u00edrja be a cPanel fi\u00f3knev\u00e9t, majd enter<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ekkor a Putty-ba bet\u00f6lt\u00f6tt PPK kulcshoz k\u00e9rni fogja a jelsz\u00f3t, amit legel\u0151sz\u00f6r, a kulcs gener\u00e1l\u00e1sakor megadtunk neki. \u00cdrja be, vagy Shift+Insert-tel be is illesztheti, a CTRL-V itt nem m\u0171k\u00f6dik. Enter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9s m\u00e1r bent is van a szerveren Shell (SSH) jogosults\u00e1ggal!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshgit-05.jpg\" alt=\"\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Munk\u00e1ra fel. J\u00f6jj\u00f6n az adatb\u00e1zis kezel\u00e9s!<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Most m\u00e1r a saj\u00e1t fejleszt\u0151i g\u00e9p\u00e9re telep\u00edtett MySQL kliens programmal is tudja kezelni az adatb\u00e1zis\u00e1t, legyen az ak\u00e1r a MySQL Workbench vagy a HeidiSQL. Az adatb\u00e1zis kapcsolatn\u00e1l a kiszolg\u00e1l\u00f3 legyen localhost, a port 3306. Meg kell adni az adatb\u00e1zis felhaszn\u00e1l\u00f3nevet \u00e9s a hozz\u00e1 tartoz\u00f3 jelsz\u00f3t, amit kor\u00e1bban be\u00e1ll\u00edtott a cPanelen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teh\u00e1t cPanelen l\u00e9trehozza az SSH kulcsokat, enged\u00e9lyezi. PUTTY-al be\u00e1ll\u00edtja az SSH kapcsolatot benne az SSH kulccsal \u00e9s a be\u00e1ll\u00edtott Tunnellel a 3306-os MySQL portra. Csatlakozik a szerverhez. Be\u00e1ll\u00edtja a MySQL kliens programban az adatb\u00e1zis el\u00e9r\u00e9st localhost kiszolg\u00e1l\u00f3val 3306-os porton, megadja az adatb\u00e1zis bel\u00e9p\u00e9si adatokat \u00e9s megnyitja. K\u00e9sz is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/sshmysql.jpg\" alt=\"\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Kinek j\u00f3 ez?<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Minden fejleszt\u0151 koll\u00e9g\u00e1nak, aki nem szeretne cPanelel \u00e9s az abb\u00f3l megny\u00edl\u00f3 PhpMyAdmin fel\u00fclettel vesz\u0151dni.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Volt m\u00e1r kor\u00e1bban egy cikk\u00fcnk arr\u00f3l, hogy a cPanel PREMIUM&nbsp;webt\u00e1rhely&nbsp;csomagunkat igazi kock\u00e1knak tervezt\u00fck, de mondhatn\u00e1nk \u00fagy is, hogy igazi fejleszt\u0151knek. Azt\u00e1n elind\u00edtottuk a&nbsp;Python&nbsp;csomagot is, amelyben szint\u00e9n el\u00e9rhet\u0151 a GIT \u00e9s az SSH. Most ezt terjesztj\u00fck ki SSH Tunnelel, t\u00e1voli MySQL el\u00e9r\u00e9s\u00e9hez. SSH hozz\u00e1f\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa: Miut\u00e1n megkapta a cPanel hozz\u00e1f\u00e9r\u00e9st, l\u00e9pjen be. A Vez\u00e9rl\u0151pulton keresse meg [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6677,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[192],"tags":[],"class_list":["post-897","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.7 (Yoast SEO v27.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel &#8226; Versanus<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel\" \/>\n<meta property=\"og:description\" content=\"Volt m\u00e1r kor\u00e1bban egy cikk\u00fcnk arr\u00f3l, hogy a cPanel PREMIUM&nbsp;webt\u00e1rhely&nbsp;csomagunkat igazi kock\u00e1knak tervezt\u00fck, de mondhatn\u00e1nk \u00fagy is, hogy igazi fejleszt\u0151knek. Azt\u00e1n elind\u00edtottuk a&nbsp;Python&nbsp;csomagot is, amelyben szint\u00e9n el\u00e9rhet\u0151 a GIT \u00e9s az SSH. Most ezt terjesztj\u00fck ki SSH Tunnelel, t\u00e1voli MySQL el\u00e9r\u00e9s\u00e9hez. SSH hozz\u00e1f\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa: Miut\u00e1n megkapta a cPanel hozz\u00e1f\u00e9r\u00e9st, l\u00e9pjen be. A Vez\u00e9rl\u0151pulton keresse meg [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/\" \/>\n<meta property=\"og:site_name\" content=\"Versanus\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/versanus.eu\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-19T09:35:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-28T20:10:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"433\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"M\u00e9h\u00e9sz P\u00e1l\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"M\u00e9h\u00e9sz P\u00e1l\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/\"},\"author\":{\"name\":\"M\u00e9h\u00e9sz P\u00e1l\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#\\\/schema\\\/person\\\/e3d8a534a10d06ad9c4051c078b03eec\"},\"headline\":\"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel\",\"datePublished\":\"2019-06-19T09:35:00+00:00\",\"dateModified\":\"2026-05-28T20:10:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/\"},\"wordCount\":1213,\"publisher\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/tavoli-mysql-cpanel-ssh-tunnel.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"hu\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/\",\"url\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/\",\"name\":\"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel &#8226; Versanus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/tavoli-mysql-cpanel-ssh-tunnel.jpg\",\"datePublished\":\"2019-06-19T09:35:00+00:00\",\"dateModified\":\"2026-05-28T20:10:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/tavoli-mysql-cpanel-ssh-tunnel.jpg\",\"contentUrl\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/tavoli-mysql-cpanel-ssh-tunnel.jpg\",\"width\":650,\"height\":433},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/blog\\\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"F\u0151oldal\",\"item\":\"https:\\\/\\\/versa.host\\\/hu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#website\",\"url\":\"https:\\\/\\\/versa.host\\\/hu\\\/\",\"name\":\"Versanus\",\"description\":\"Electronic Store Website\",\"publisher\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/versa.host\\\/hu\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#organization\",\"name\":\"Versanus Kft.\",\"url\":\"https:\\\/\\\/versa.host\\\/hu\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/versanus.png\",\"contentUrl\":\"https:\\\/\\\/versa.host\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/versanus.png\",\"width\":385,\"height\":33,\"caption\":\"Versanus Kft.\"},\"image\":{\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/versanus.eu\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/versanus-eu\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/versa.host\\\/hu\\\/#\\\/schema\\\/person\\\/e3d8a534a10d06ad9c4051c078b03eec\",\"name\":\"M\u00e9h\u00e9sz P\u00e1l\",\"sameAs\":[\"https:\\\/\\\/versa.host\"],\"url\":\"https:\\\/\\\/versa.host\\\/hu\\\/author\\\/versa_crm\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel &#8226; Versanus","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"hu_HU","og_type":"article","og_title":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel","og_description":"Volt m\u00e1r kor\u00e1bban egy cikk\u00fcnk arr\u00f3l, hogy a cPanel PREMIUM&nbsp;webt\u00e1rhely&nbsp;csomagunkat igazi kock\u00e1knak tervezt\u00fck, de mondhatn\u00e1nk \u00fagy is, hogy igazi fejleszt\u0151knek. Azt\u00e1n elind\u00edtottuk a&nbsp;Python&nbsp;csomagot is, amelyben szint\u00e9n el\u00e9rhet\u0151 a GIT \u00e9s az SSH. Most ezt terjesztj\u00fck ki SSH Tunnelel, t\u00e1voli MySQL el\u00e9r\u00e9s\u00e9hez. SSH hozz\u00e1f\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa: Miut\u00e1n megkapta a cPanel hozz\u00e1f\u00e9r\u00e9st, l\u00e9pjen be. A Vez\u00e9rl\u0151pulton keresse meg [&hellip;]","og_url":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/","og_site_name":"Versanus","article_publisher":"https:\/\/www.facebook.com\/versanus.eu","article_published_time":"2019-06-19T09:35:00+00:00","article_modified_time":"2026-05-28T20:10:54+00:00","og_image":[{"width":650,"height":433,"url":"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg","type":"image\/jpeg"}],"author":"M\u00e9h\u00e9sz P\u00e1l","twitter_card":"summary_large_image","twitter_misc":{"Szerz\u0151:":"M\u00e9h\u00e9sz P\u00e1l","Becs\u00fclt olvas\u00e1si id\u0151":"6 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#article","isPartOf":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/"},"author":{"name":"M\u00e9h\u00e9sz P\u00e1l","@id":"https:\/\/versa.host\/hu\/#\/schema\/person\/e3d8a534a10d06ad9c4051c078b03eec"},"headline":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel","datePublished":"2019-06-19T09:35:00+00:00","dateModified":"2026-05-28T20:10:54+00:00","mainEntityOfPage":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/"},"wordCount":1213,"publisher":{"@id":"https:\/\/versa.host\/hu\/#organization"},"image":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#primaryimage"},"thumbnailUrl":"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg","articleSection":["Blog"],"inLanguage":"hu"},{"@type":"WebPage","@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/","url":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/","name":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel &#8226; Versanus","isPartOf":{"@id":"https:\/\/versa.host\/hu\/#website"},"primaryImageOfPage":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#primaryimage"},"image":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#primaryimage"},"thumbnailUrl":"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg","datePublished":"2019-06-19T09:35:00+00:00","dateModified":"2026-05-28T20:10:54+00:00","breadcrumb":{"@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#primaryimage","url":"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg","contentUrl":"https:\/\/versa.host\/wp-content\/uploads\/2024\/03\/tavoli-mysql-cpanel-ssh-tunnel.jpg","width":650,"height":433},{"@type":"BreadcrumbList","@id":"https:\/\/versa.host\/hu\/blog\/tavoli-mysql-adatbazis-eleres-beallitasa-ssh-tunnelel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"F\u0151oldal","item":"https:\/\/versa.host\/hu\/"},{"@type":"ListItem","position":2,"name":"T\u00e1voli MySQL adatb\u00e1zis el\u00e9r\u00e9s be\u00e1ll\u00edt\u00e1sa SSH Tunnelel"}]},{"@type":"WebSite","@id":"https:\/\/versa.host\/hu\/#website","url":"https:\/\/versa.host\/hu\/","name":"Versanus","description":"Electronic Store Website","publisher":{"@id":"https:\/\/versa.host\/hu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/versa.host\/hu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/versa.host\/hu\/#organization","name":"Versanus Kft.","url":"https:\/\/versa.host\/hu\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/versa.host\/hu\/#\/schema\/logo\/image\/","url":"https:\/\/versa.host\/wp-content\/uploads\/2024\/12\/versanus.png","contentUrl":"https:\/\/versa.host\/wp-content\/uploads\/2024\/12\/versanus.png","width":385,"height":33,"caption":"Versanus Kft."},"image":{"@id":"https:\/\/versa.host\/hu\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/versanus.eu","https:\/\/www.linkedin.com\/company\/versanus-eu\/"]},{"@type":"Person","@id":"https:\/\/versa.host\/hu\/#\/schema\/person\/e3d8a534a10d06ad9c4051c078b03eec","name":"M\u00e9h\u00e9sz P\u00e1l","sameAs":["https:\/\/versa.host"],"url":"https:\/\/versa.host\/hu\/author\/versa_crm\/"}]}},"_links":{"self":[{"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/posts\/897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/comments?post=897"}],"version-history":[{"count":1,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/posts\/897\/revisions"}],"predecessor-version":[{"id":9333,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/posts\/897\/revisions\/9333"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/media\/6677"}],"wp:attachment":[{"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/media?parent=897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/categories?post=897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/versa.host\/hu\/wp-json\/wp\/v2\/tags?post=897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}