{"id":490,"date":"2021-03-05T15:29:59","date_gmt":"2021-03-05T15:29:59","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=490"},"modified":"2021-06-24T10:57:30","modified_gmt":"2021-06-24T08:57:30","slug":"pristup-k-mysql-pres-prikazovy-radek","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/","title":{"rendered":"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek"},"content":{"rendered":"\n<p>Za \u00fa\u010delem spr\u00e1vy datab\u00e1z\u00ed z p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku se oby\u010dejn\u011b p\u0159ipojuje pomoc\u00ed p\u0159\u00edstup\u016f pro spr\u00e1vce datab\u00e1zov\u00e9ho serveru \u00a0&#8211; u\u017eivatele root .<\/p>\n\n\n\n<p>Pozor, tyto p\u0159\u00edstupy jsou odli\u0161n\u00e9 od root hesla pro p\u0159\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 sv\u016fj vlastn\u00ed syst\u00e9m u\u017eivatel\u016f.\u00a0<\/p>\n\n\n\n<p>Pro VPS zakoupen\u00e9 se slu\u017ebou ServerManager najdete heslo v souboru \/root\/.mysqlpass . Spojen\u00ed v takov\u00e9m p\u0159\u00edpad\u011b m\u016f\u017eete ud\u011blat pomoc\u00ed p\u0159\u00edkazu\u00a0<\/p>\n\n\n\n<p><strong><em>mysql -uroot -p`cat \/root\/.mysqlpass`<\/em><\/strong><\/p>\n\n\n\n<p>ServerManager pot\u0159ebuje m\u00edt pro korektn\u00ed spr\u00e1vu datab\u00e1z\u00ed p\u0159\u00edstupov\u00e9 heslo zapsan\u00e9 v tomto souboru, proto v p\u0159\u00edpad\u011b jeho zm\u011bny nezapome\u0148te heslo vlo\u017eit i do tohoto souboru.\u00a0<\/p>\n\n\n\n<p>Pokud ServerManager nepou\u017e\u00edv\u00e1te, je p\u0159ed p\u0159\u00edstupem pot\u0159ebn\u00e9 heslo pro u\u017eivatele root nastavit.\u00a0Heslo inicializujeme pomoc\u00ed:<\/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 se m\u016f\u017eete p\u0159ipojit:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>mysql -uroot -pVASEHESLO<\/em><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Za \u00fa\u010delem spr\u00e1vy datab\u00e1z\u00ed z p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku se oby\u010dejn\u011b p\u0159ipojuje pomoc\u00ed p\u0159\u00edstup\u016f pro spr\u00e1vce datab\u00e1zov\u00e9ho serveru \u00a0&#8211; u\u017eivatele root . Pozor, tyto p\u0159\u00edstupy jsou odli\u0161n\u00e9 od root hesla pro p\u0159\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 sv\u016fj vlastn\u00ed syst\u00e9m u\u017eivatel\u016f.\u00a0 Pro VPS zakoupen\u00e9 se slu\u017ebou ServerManager najdete heslo v souboru&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[57,15],"ht-kb-tag":[],"class_list":["post-490","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaze","ht_kb_category-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy<\/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.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"Za \u00fa\u010delem spr\u00e1vy datab\u00e1z\u00ed z p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku se oby\u010dejn\u011b p\u0159ipojuje pomoc\u00ed p\u0159\u00edstup\u016f pro spr\u00e1vce datab\u00e1zov\u00e9ho serveru \u00a0&#8211; u\u017eivatele root . Pozor, tyto p\u0159\u00edstupy jsou odli\u0161n\u00e9 od root hesla pro p\u0159\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 sv\u016fj vlastn\u00ed syst\u00e9m u\u017eivatel\u016f.\u00a0 Pro VPS zakoupen\u00e9 se slu\u017ebou ServerManager najdete heslo v souboru...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-24T08:57:30+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuta\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\",\"name\":\"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/#website\"},\"datePublished\":\"2021-03-05T15:29:59+00:00\",\"dateModified\":\"2021-06-24T08:57:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.websupport.cz\/podpora\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/#website\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/\",\"name\":\"Websupport Centrum n\u00e1pov\u011bdy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy","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.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/","og_locale":"cs_CZ","og_type":"article","og_title":"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy","og_description":"Za \u00fa\u010delem spr\u00e1vy datab\u00e1z\u00ed z p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku se oby\u010dejn\u011b p\u0159ipojuje pomoc\u00ed p\u0159\u00edstup\u016f pro spr\u00e1vce datab\u00e1zov\u00e9ho serveru \u00a0&#8211; u\u017eivatele root . Pozor, tyto p\u0159\u00edstupy jsou odli\u0161n\u00e9 od root hesla pro p\u0159\u00edstup k VPS , datab\u00e1zov\u00fd server m\u00e1 sv\u016fj vlastn\u00ed syst\u00e9m u\u017eivatel\u016f.\u00a0 Pro VPS zakoupen\u00e9 se slu\u017ebou ServerManager najdete heslo v souboru...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2021-06-24T08:57:30+00:00","twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/","name":"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"datePublished":"2021-03-05T15:29:59+00:00","dateModified":"2021-06-24T08:57:30+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/pristup-k-mysql-pres-prikazovy-radek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"P\u0159\u00edstup k MySQL p\u0159es p\u0159\u00edkazov\u00fd \u0159\u00e1dek"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/podpora\/#website","url":"https:\/\/www.websupport.cz\/podpora\/","name":"Websupport Centrum n\u00e1pov\u011bdy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":1,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/490\/revisions"}],"predecessor-version":[{"id":2322,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/490\/revisions\/2322"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=490"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=490"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}