{"id":1310,"date":"2018-12-10T22:03:17","date_gmt":"2018-12-10T21:03:17","guid":{"rendered":"https:\/\/www.websupport.sk\/podpora\/?post_type=ht_kb&#038;p=1310"},"modified":"2018-12-16T11:03:06","modified_gmt":"2018-12-16T10:03:06","slug":"pristup-k-mysql-cez-prikazovy-riadok","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/","title":{"rendered":"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok"},"content":{"rendered":"\n<p>Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera &nbsp;&#8211; pou\u017e\u00edvate\u013ea &nbsp;root .<\/p>\n\n\n\n<p>Pozor, tieto pr\u00edstupy s\u00fa odli\u0161ne od root hesla pre pr\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 svoj vlastn\u00fd syst\u00e9m pou\u017e\u00edvate\u013eov.&nbsp;<\/p>\n\n\n\n<p>Pre VPS zak\u00fapen\u00e9 so slu\u017ebou ServerManager n\u00e1jdete heslo v s\u00fabore \/root\/.mysqlpass . Spojenie v takom pr\u00edpade viete spravi\u0165 pomocou pr\u00edkazu&nbsp;<\/p>\n\n\n\n<p><strong><em>mysql -uroot -p`cat \/root\/.mysqlpass`<\/em><\/strong><\/p>\n\n\n\n<p>ServerManager potrebuje ma\u0165 pre korektn\u00fa spr\u00e1vu datab\u00e1z pr\u00edstupov\u00e9 heslo zap\u00edsan\u00e9 v tomto s\u00fabore, preto v pr\u00edpade jeho zmeny nezabudnite heslo vlo\u017eit aj do tohoto s\u00faboru.&nbsp;<\/p>\n\n\n\n<p>Pokia\u013e ServerManager nepou\u017e\u00edvate , je pred pr\u00edstupom potrebn\u00e9 heslo pre u\u017eivate\u013ea root nastavi\u0165.&nbsp;Heslo inicializujeme pomocou:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>mysqladmin password<\/em><\/pre>\n\n\n\n<p>Po zadan\u00ed a zopakovan\u00ed hesla sa m\u00f4\u017eete pripoji\u0165:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>mysql -uroot -pVASEHESLO<\/em><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera &nbsp;&#8211; pou\u017e\u00edvate\u013ea &nbsp;root . Pozor, tieto pr\u00edstupy s\u00fa odli\u0161ne od root hesla pre pr\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 svoj vlastn\u00fd syst\u00e9m pou\u017e\u00edvate\u013eov.&nbsp; Pre VPS zak\u00fapen\u00e9 so slu\u017ebou ServerManager n\u00e1jdete heslo v s\u00fabore&#8230;<\/p>\n","protected":false},"author":29,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[31,41],"ht-kb-tag":[],"class_list":["post-1310","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_category-databazy"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory<\/title>\n<meta name=\"description\" content=\"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.\" \/>\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.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory\" \/>\n<meta property=\"og:description\" content=\"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport centrum podpory\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-16T10:03:06+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 min\u00fata\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/pristup-k-mysql-cez-prikazovy-riadok\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/pristup-k-mysql-cez-prikazovy-riadok\\\/\",\"name\":\"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\"},\"datePublished\":\"2018-12-10T21:03:17+00:00\",\"dateModified\":\"2018-12-16T10:03:06+00:00\",\"description\":\"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/pristup-k-mysql-cez-prikazovy-riadok\\\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/pristup-k-mysql-cez-prikazovy-riadok\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/pristup-k-mysql-cez-prikazovy-riadok\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\",\"name\":\"Websupport centrum podpory\",\"description\":\"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory","description":"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.","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.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/","og_locale":"sk_SK","og_type":"article","og_title":"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory","og_description":"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.","og_url":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/","og_site_name":"Websupport centrum podpory","article_modified_time":"2018-12-16T10:03:06+00:00","twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"1 min\u00fata"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/","url":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/","name":"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok - Websupport centrum podpory","isPartOf":{"@id":"https:\/\/www.websupport.sk\/podpora\/#website"},"datePublished":"2018-12-10T21:03:17+00:00","dateModified":"2018-12-16T10:03:06+00:00","description":"Za \u00fa\u010delom spr\u00e1vy datab\u00e1z z pr\u00edkazov\u00e9ho riadku sa zvy\u010dajne spr\u00e1vca prip\u00e1ja pomocou pr\u00edstupov pre spr\u00e1vcu datab\u00e1zov\u00e9ho servera - pou\u017e\u00edvate\u013ea root.","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/pristup-k-mysql-cez-prikazovy-riadok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/podpora\/"},{"@type":"ListItem","position":2,"name":"Pr\u00edstup k MySQL cez pr\u00edkazov\u00fd riadok"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/podpora\/#website","url":"https:\/\/www.websupport.sk\/podpora\/","name":"Websupport centrum podpory","description":"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/users\/29"}],"version-history":[{"count":1,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1310\/revisions"}],"predecessor-version":[{"id":1311,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1310\/revisions\/1311"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/media?parent=1310"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1310"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}