{"id":6357,"date":"2020-08-11T10:20:13","date_gmt":"2020-08-11T08:20:13","guid":{"rendered":"https:\/\/www.webonic.hu\/support\/?post_type=ht_kb&p=6357"},"modified":"2020-08-11T10:20:13","modified_gmt":"2020-08-11T08:20:13","slug":"adatbazis-kapcsolodasok","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/","title":{"rendered":"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok"},"content":{"rendered":"\n

Az al\u00e1bbi t\u00e1bl\u00e1zatba \u00f6sszegy\u0171jt\u00f6tt\u00fck az eddigi adatb\u00e1zis kapcsol\u00f3d\u00e1si lehet\u0151s\u00e9geinket.<\/p>\n\n\n\n

T\u00edpus<\/th>PhpMyAdmin<\/th>Server (host)<\/th>Port<\/th>Socket<\/th>Shell parancs<\/th><\/tr><\/thead>
MySQL 5.0<\/td>https:\/\/db50.webonic.hu\/<\/a><\/td>mysql50.websupport.sk<\/a><\/td>3308<\/td>\/tmp\/mysql50.sock
<\/td>		mysql -u USER -p -h mariadb50.websupport.sk -P 3308 DATABASE

<\/td><\/tr>
MySQL 5.1<\/td>https:\/\/db51.webonic.hu<\/a><\/td>
mysql51.websupport.sk<\/a><\/td>		3309<\/td>\/tmp\/mysql51.sock<\/td>mysql -u USER -p -h mariadb51.websupport.sk -P 3309 DATABASE<\/td><\/tr>
MySQL 5.7<\/td>
https:\/\/db57.webonic.hu\/<\/a><\/td>		mysql57.websupport.sk<\/a><\/td>3311<\/td>\/tmp\/mysql57.sock<\/td>mysql -u USER -p -h mysql57.websupport.sk -P 3311 DATABASE<\/td><\/tr>
MySQL 8.0<\/td>
https:\/\/db80.webonic.hu\/<\/a><\/td>
mysql80.websupport.sk<\/a><\/td>		3314<\/td>\/tmp\/mysql80.sock<\/td>mysql -u USER -p -h mysql80.websupport.sk -P 3314 DATABASE<\/td><\/tr>
MariaDB 5.5<\/td>https:\/\/db55.webonic.hu\/<\/a><\/td>mariadb55.websupport.sk<\/a><\/td>3310<\/td>\/tmp\/mariadb55.sock<\/td>mysql -u USER -p -h mariadb55.websupport.sk -P 3310 DATABASE<\/td><\/tr>
MariaDB 10.1<\/td>https:\/\/db101.webonic.hu\/<\/a><\/td>mariadb101.websupport.sk<\/a><\/td>3312<\/td>\/tmp\/mariadb101.sock<\/td>mysql -u USER -p -h mariadb101.websupport.sk -P 3312 DATABASE<\/td><\/tr>
MariaDB 10.3<\/td>https:\/\/db103.webonic.hu\/<\/a><\/td>mariadb103.websupport.sk<\/a><\/td>3313<\/td>\/tmp\/mariadb103.sock<\/td>mysql -u USER -p -h mariadb103.websupport.sk -P 3313 DATABASE<\/td><\/tr>
PostgreSQL 9.0<\/td>https:\/\/dbpg.webonic.hu\/<\/a><\/td>
postgresql.websupport.sk<\/a><\/td>		5432<\/td>host=localhost<\/td><\/td><\/tr>
PostgreSQL 10.0<\/td>https:\/\/dbpg.webonic.hu\/<\/a><\/td>
postgresql.websupport.sk<\/a><\/td>		5432<\/td>host=localhost<\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

A PHP MyAdmin fel\u00fclet a https:\/\/dbadmin.webonic.hu\/<\/a> oldalon is el\u00e9rhet\u0151.
Itt \u00fcgyelj\u00fcnk arra, hogy a „Szerver v\u00e1laszt\u00e1sa<\/strong>” r\u00e9szn\u00e9l a megfelel\u0151 t\u00edpus\u00fa adatb\u00e1zishoz kapcsol\u00f3djunk.<\/p>\n\n\n\n

Tov\u00e1bbi hasznos inform\u00e1ci\u00f3k<\/h2>\n\n\n\n

Localhost<\/strong> helyett c\u00e9lszer\u0171bb \u00edgy megadni a kapcsol\u00f3d\u00e1st, ha a webadmin<\/a> fel\u00fcleten el\u00e9rhet\u0151 php be\u00e1ll\u00edt\u00e1sokban nem a haszn\u00e1lt adatb\u00e1zis t\u00edpus van be\u00e1ll\u00edtva localhostnak:
szerver:port (p\u00e9ld\u00e1ul: mysql57.websupport.sk:3311<\/strong>)<\/p>\n\n\n\n

PDO<\/strong> kapcsol\u00f3d\u00e1s eset\u00e9n a k\u00f6vetez\u0151 szintaktika minta javasolt: 
mariadb55.websupport.sk;port=3310<\/strong><\/p>\n\n\n\n

Shell parancsor csatlakoz\u00e1sn\u00e1l a parancsot \u00edrjuk be rendesen. Ha a t\u00e1bl\u00e1zatb\u00f3l ctrl+c – ctrl+v seg\u00edts\u00e9g\u00e9vel \u00e1tm\u00e1soljuk „Unknown MySQL server host<\/em>” hib\u00e1t dobhat ki az elt\u00e9r\u0151 karakterk\u00f3dol\u00e1sok v\u00e9gett.

\u00dcgyelj\u00fcnk a kis p \u00e9s nagy P bet\u0171kre!
-P = port
-p = jelsz\u00f3 bek\u00e9r\u00e9se a parancs kiad\u00e1sa ut\u00e1n<\/p>\n\n\n\n

\u00a0

<\/p>\n","protected":false},"excerpt":{"rendered":"

Az al\u00e1bbi t\u00e1bl\u00e1zatba \u00f6sszegy\u0171jt\u00f6tt\u00fck az eddigi adatb\u00e1zis kapcsol\u00f3d\u00e1si lehet\u0151s\u00e9geinket. T\u00edpus PhpMyAdmin Server (host) Port Socket Shell parancs MySQL 5.0 https:\/\/db50.webonic.hu\/ mysql50.websupport.sk 3308 \/tmp\/mysql50.sock mysql -u USER -p -h mariadb50.websupport.sk -P 3308 DATABASE MySQL 5.1 https:\/\/db51.webonic.hu mysql51.websupport.sk 3309 \/tmp\/mysql51.sock mysql -u USER -p -h mariadb51.websupport.sk -P 3309 DATABASE MySQL 5.7 https:\/\/db57.webonic.hu\/…<\/p>\n","protected":false},"author":19,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[100],"ht-kb-tag":[942],"class_list":["post-6357","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-adatbazis","ht_kb_tag-adatbazis"],"yoast_head":"\nAdatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta property=\"og:description\" content=\"Az al\u00e1bbi t\u00e1bl\u00e1zatba \u00f6sszegy\u0171jt\u00f6tt\u00fck az eddigi adatb\u00e1zis kapcsol\u00f3d\u00e1si lehet\u0151s\u00e9geinket. T\u00edpus PhpMyAdmin Server (host) Port Socket Shell parancs MySQL 5.0 https:\/\/db50.webonic.hu\/ mysql50.websupport.sk 3308 \/tmp\/mysql50.sock mysql -u USER -p -h mariadb50.websupport.sk -P 3308 DATABASE MySQL 5.1 https:\/\/db51.webonic.hu mysql51.websupport.sk 3309 \/tmp\/mysql51.sock mysql -u USER -p -h mariadb51.websupport.sk -P 3309 DATABASE MySQL 5.7 https:\/\/db57.webonic.hu\/...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/adatbazis-kapcsolodasok\\\/\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/adatbazis-kapcsolodasok\\\/\",\"name\":\"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\"},\"datePublished\":\"2020-08-11T08:20:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/adatbazis-kapcsolodasok\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/adatbazis-kapcsolodasok\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/adatbazis-kapcsolodasok\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\",\"name\":\"Websupport Tud\u00e1sb\u00e1zis\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/","og_locale":"hu_HU","og_type":"article","og_title":"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis","og_description":"Az al\u00e1bbi t\u00e1bl\u00e1zatba \u00f6sszegy\u0171jt\u00f6tt\u00fck az eddigi adatb\u00e1zis kapcsol\u00f3d\u00e1si lehet\u0151s\u00e9geinket. T\u00edpus PhpMyAdmin Server (host) Port Socket Shell parancs MySQL 5.0 https:\/\/db50.webonic.hu\/ mysql50.websupport.sk 3308 \/tmp\/mysql50.sock mysql -u USER -p -h mariadb50.websupport.sk -P 3308 DATABASE MySQL 5.1 https:\/\/db51.webonic.hu mysql51.websupport.sk 3309 \/tmp\/mysql51.sock mysql -u USER -p -h mariadb51.websupport.sk -P 3309 DATABASE MySQL 5.7 https:\/\/db57.webonic.hu\/...","og_url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/","og_site_name":"Websupport Tud\u00e1sb\u00e1zis","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/","url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/","name":"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok - Websupport Tud\u00e1sb\u00e1zis","isPartOf":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/#website"},"datePublished":"2020-08-11T08:20:13+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/adatbazis-kapcsolodasok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.hu\/tamogatas\/"},{"@type":"ListItem","position":2,"name":"Adatb\u00e1zis kapcsol\u00f3d\u00e1sok"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.hu\/tamogatas\/#website","url":"https:\/\/www.websupport.hu\/tamogatas\/","name":"Websupport Tud\u00e1sb\u00e1zis","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.hu\/tamogatas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/6357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/users\/19"}],"version-history":[{"count":0,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/6357\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/media?parent=6357"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-category?post=6357"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-tag?post=6357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}