{"id":13347,"date":"2023-08-25T00:00:00","date_gmt":"2023-08-25T00:00:00","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/jak-preinstalovat-mysql-pruvodce-krok-za-krokem\/"},"modified":"2023-08-25T00:00:00","modified_gmt":"2023-08-25T00:00:00","slug":"jak-preinstalovat-mysql-pruvodce-krok-za-krokem","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/jak-preinstalovat-mysql-pruvodce-krok-za-krokem\/","title":{"rendered":"Jak p\u0159einstalovat MySQL. Pr\u016fvodce krok za krokem"},"content":{"rendered":"
\n
<\/div>\n

Pro ukl\u00e1d\u00e1n\u00ed a spr\u00e1vu dat mnoho lid\u00ed vyu\u017e\u00edv\u00e1 zn\u00e1m\u00fd open-source syst\u00e9m pro spr\u00e1vu rela\u010dn\u00edch datab\u00e1z\u00ed zn\u00e1m\u00fd jako MySQL. P\u0159einstalov\u00e1n\u00ed MySQL m\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00fdm krokem v procesu \u0159e\u0161en\u00ed probl\u00e9m\u016f, pokud s n\u00edm n\u011bkdy naraz\u00edte na pot\u00ed\u017ee. V opera\u010dn\u00edch syst\u00e9mech Ubuntu i Windows v\u00e1s v tomto p\u0159\u00edsp\u011bvku provedeme procesem p\u0159einstalace MySQL. <\/p>\n

P\u0159einstalace MySQL v Ubuntu: <\/div>\n

1. Odeberte MySQL: P\u0159ed op\u011btovnou instalac\u00ed doporu\u010dujeme odinstalovat st\u00e1vaj\u00edc\u00ed instalaci MySQL, abyste p\u0159ede\u0161li p\u0159\u00edpadn\u00fdm probl\u00e9m\u016fm. Po otev\u0159en\u00ed termin\u00e1lu spus\u0165te n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz: Odstran\u011bn\u00ed konfigura\u010dn\u00edch soubor\u016f: Sudo “‘ <\/p>\n

<\/div>\n

apt-get purge mysql-server mysql-client “‘ <\/p>\n

<\/div>\n

mysql-common mysql-server-core mysql-client-core Odstran\u011bn\u00ed konfigura\u010dn\u00edch soubor\u016f: <\/p>\n

<\/div>\n

“‘ <\/p>\n

<\/div>\n

sudo rm -rf \/etc\/mysql\/ odstran\u00ed konfigura\u010dn\u00ed soubory MySQL, \u010d\u00edm\u017e zajist\u00ed \u010distou reinstalaci. <\/p>\n

<\/div>\n

„` <\/p>\n

<\/div>\n
<\/div>\n

Nainstalujte MySQL: V tomto okam\u017eiku m\u016f\u017eete zah\u00e1jit p\u0159einstalaci. Chcete-li nainstalovat MySQL, zadejte n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkaz: MySQL-Server lze nainstalovat zad\u00e1n\u00edm p\u0159\u00edkazu sudo apt-get install <\/p>\n

<\/div>\n

“‘ <\/p>\n

<\/div>\n

4. Ochra\u0148te MySQL: Po dokon\u010den\u00ed instalace je d\u016fle\u017eit\u00e9 chr\u00e1nit MySQL spu\u0161t\u011bn\u00edm bezpe\u010dnostn\u00edho skriptu: <\/p>\n

<\/div>\n

“‘ <\/p>\n

<\/div>\n

sudo mysql_secure_installation <\/p>\n

<\/div>\n

“‘ <\/p>\n

<\/div>\n

Pomoc\u00ed tohoto skriptu m\u016f\u017eete nastavit heslo roota, zbavit se anonymn\u00edch u\u017eivatel\u016f a prov\u00e9st dal\u0161\u00ed \u00fapravy souvisej\u00edc\u00ed se zabezpe\u010den\u00edm. <\/p>\n

Jak znovu nainstalovat MySQL v syst\u00e9mu Windows 10 po jeho odinstalov\u00e1n\u00ed: <\/div>\n

1. Odeberte MySQL: Klepn\u011bte na ikonu Ovl\u00e1dac\u00ed panely a pot\u00e9 vyberte „Programy“ > „Programy a funkce“. Pot\u00e9 klikn\u011bte prav\u00fdm tla\u010d\u00edtkem my\u0161i na polo\u017eku „MySQL“ v seznamu nainstalovan\u00fdch aplikac\u00ed a vyberte mo\u017enost „Odinstalovat“. Pro dokon\u010den\u00ed postupu odinstalace se dr\u017ete pokyn\u016f. <\/p>\n

<\/div>\n

2. Odstra\u0148te datovou slo\u017eku MySQL: P\u0159ed op\u011btovnou instalac\u00ed MySQL odstra\u0148te datovou slo\u017eku, abyste p\u0159ede\u0161li konflikt\u016fm. V\u00fdchoz\u00ed um\u00edst\u011bn\u00ed datov\u00e9 slo\u017eky pro star\u0161\u00ed verze MySQL je „C:ProgramDataMySQL“ nebo „C:Documents and SettingsAll UsersApplication DataMySQL“. Odstra\u0148te p\u0159\u00edslu\u0161nou slo\u017eku. 3. St\u00e1hn\u011bte si a nainstalujte MySQL: P\u0159ejd\u011bte na ofici\u00e1ln\u00ed webov\u00e9 str\u00e1nky MySQL (https:\/\/dev.mysql.com\/downloads\/mysql\/) a st\u00e1hn\u011bte si instala\u010dn\u00ed program MySQL pro Windows, kter\u00fd je vhodn\u00fd pro v\u00e1\u0161 opera\u010dn\u00ed syst\u00e9m. Chcete-li nainstalovat MySQL, spus\u0165te instala\u010dn\u00ed program a \u0159i\u010fte se pokyny na obrazovce. 4. Nastavte MySQL: V pr\u016fb\u011bhu instalace budete muset prov\u00e9st nastaven\u00ed MySQL. Stanovte heslo roota a vyberte po\u017eadovan\u00e9 mo\u017enosti nastaven\u00ed. Po dokon\u010den\u00ed instalace by m\u011bla b\u00fdt MySQL znovu nainstalov\u00e1na a p\u0159\u00edstupn\u00e1. <\/p>\n

Kroky pro nastaven\u00ed MySQL v syst\u00e9mu Windows: <\/div>\n

1. St\u00e1hn\u011bte si MySQL. P\u0159ejd\u011bte na ofici\u00e1ln\u00ed webov\u00e9 str\u00e1nky MySQL (https:\/\/dev.mysql.com\/downloads\/mysql\/) a z\u00edskejte tam instalaci MySQL pro Windows. <\/p>\n

<\/div>\n

2. Spus\u0165te instala\u010dn\u00ed program: Dvakr\u00e1t klikn\u011bte na sta\u017een\u00fd instala\u010dn\u00ed soubor a \u0159i\u010fte se pokyny, kter\u00e9 se objev\u00ed na obrazovce. Pokud nem\u00e1te zvl\u00e1\u0161tn\u00ed po\u017eadavky, m\u011bli byste zvolit „Typickou“ instalaci. 3. Nastavte MySQL: V pr\u016fb\u011bhu instalace budete muset nastavit MySQL. Stanovte heslo roota a vyberte po\u017eadovan\u00e9 mo\u017enosti nastaven\u00ed. MySQL mus\u00ed b\u00fdt po dokon\u010den\u00ed instalace nainstalov\u00e1na a p\u0159\u00edstupn\u00e1. Odstran\u00ed reinstalace MySQL datab\u00e1ze? <\/p>\n

<\/div>\n

P\u0159i p\u0159einstalaci MySQL se va\u0161e datab\u00e1ze nesma\u017eou. Abyste v\u0161ak p\u0159ede\u0161li ztr\u00e1t\u011b dat, je nutn\u00e9 p\u0159ed p\u0159einstalac\u00ed MySQL datab\u00e1zi z\u00e1lohovat. Datab\u00e1zov\u00e9 soubory se p\u0159i odinstalaci MySQL obvykle nema\u017eou, ale b\u011bhem procesu odinstalace m\u016f\u017eete zadat, \u017ee je chcete smazat. Chcete-li zachovat bezpe\u010dnost sv\u00fdch dat, doporu\u010dujeme p\u0159ed p\u0159einstalac\u00ed MySQL v\u017edy vytvo\u0159it z\u00e1lohu datab\u00e1ze. <\/p>\n

<\/div>\n

Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee p\u0159einstalov\u00e1n\u00ed MySQL m\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00fdm krokem p\u0159i \u0159e\u0161en\u00ed probl\u00e9m\u016f se syst\u00e9mem spr\u00e1vy datab\u00e1z\u00ed. A\u0165 u\u017e pou\u017e\u00edv\u00e1te Ubuntu nebo Windows, postup podle uveden\u00fdch krok\u016f v\u00e1s provede procesem p\u0159einstalace MySQL a zabezpe\u010den\u00edm va\u0161\u00ed instalace. P\u0159ed p\u0159einstalac\u00ed v\u017edy nezapome\u0148te z\u00e1lohovat datab\u00e1zi, abyste p\u0159ede\u0161li p\u0159\u00edpadn\u00e9 ztr\u00e1t\u011b dat.<\/p><\/div>\n

\n
FAQ<\/div>\n
\n
Jak lok\u00e1ln\u011b odinstalovat MySQL?<\/div>\n

Chcete-li odinstalovat MySQL lok\u00e1ln\u011b, m\u016f\u017eete postupovat podle n\u00e1sleduj\u00edc\u00edch krok\u016f: <\/p>\n

<\/div>\n

1. Zastavte server MySQL: <\/p>\n

<\/div>\n

– Otev\u0159ete p\u0159\u00edkazov\u00fd \u0159\u00e1dek nebo termin\u00e1l. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo service mysql stop` (pro Linux) nebo `net stop MySQL` (pro Windows). <\/p>\n

<\/div>\n

2. Odeberte MySQL pomoc\u00ed metody vhodn\u00e9 pro v\u00e1\u0161 opera\u010dn\u00ed syst\u00e9m: <\/p>\n

<\/div>\n

– V p\u0159\u00edpad\u011b syst\u00e9mu Windows: <\/p>\n

<\/div>\n

– V p\u0159\u00edpad\u011b syst\u00e9mu Windows pou\u017eijte n\u00e1sleduj\u00edc\u00ed postup: <\/p>\n

<\/div>\n

– Otev\u0159ete Ovl\u00e1dac\u00ed panely. <\/p>\n

<\/div>\n

– P\u0159ejd\u011bte do \u010d\u00e1sti „Programy“ nebo „Programy a funkce“. <\/p>\n

<\/div>\n

– V seznamu nainstalovan\u00fdch program\u016f vyhledejte MySQL. <\/p>\n

<\/div>\n

– Klikn\u011bte na MySQL a vyberte mo\u017enost „Odinstalovat“ nebo „Odebrat“. <\/p>\n

<\/div>\n

– Postupujte podle pokyn\u016f a dokon\u010dete proces odinstalace. <\/p>\n

<\/div>\n

– Pro syst\u00e9m MacOS: <\/p>\n

<\/div>\n

– Otev\u0159ete Termin\u00e1l. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/usr\/local\/mysql*`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/Library\/StartupItems\/MySQLCOM`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/Library\/PreferencePanes\/MySQL*`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `vim \/etc\/hostconfig` a odstra\u0148te \u0159\u00e1dek MYSQLCOM=-YES-. <\/p>\n

<\/div>\n

– Pro Linux: <\/p>\n

<\/div>\n

– Otev\u0159ete Termin\u00e1l. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo apt-get remove –purge mysql-server mysql-client mysql-common`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo apt-get autoremove`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo apt-get autoclean`. <\/p>\n

<\/div>\n

– Odstra\u0148te datov\u00fd adres\u00e1\u0159 MySQL: `sudo rm -rf \/var\/lib\/mysql`. <\/p>\n

<\/div>\n

3. Odstra\u0148te v\u0161echny zb\u00fdvaj\u00edc\u00ed konfigura\u010dn\u00ed soubory MySQL: <\/p>\n

<\/div>\n

– V p\u0159\u00edpad\u011b syst\u00e9mu Windows: <\/p>\n

<\/div>\n

– Vyma\u017ete v\u0161echny soubory MySQL: <\/p>\n

<\/div>\n

– Otev\u0159ete Pr\u016fzkumn\u00edka Windows. <\/p>\n

<\/div>\n

– Do adresn\u00edho \u0159\u00e1dku zadejte `%programdata%`. <\/p>\n

<\/div>\n

– Odstra\u0148te slo\u017eku s n\u00e1zvem „MySQL“. <\/p>\n

<\/div>\n

– V syst\u00e9mech MacOS a Linux odstra\u0148te konfigura\u010dn\u00ed soubory MySQL ru\u010dn\u011b: <\/p>\n

<\/div>\n

– Otev\u0159ete termin\u00e1l. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/etc\/mysql`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/var\/lib\/mysql`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/var\/log\/mysql*`. <\/p>\n

<\/div>\n

– Spus\u0165te p\u0159\u00edkaz: `sudo rm -rf \/usr\/local\/mysql`. <\/p>\n

<\/div>\n

Po dokon\u010den\u00ed t\u011bchto krok\u016f jste \u00fasp\u011b\u0161n\u011b odinstalovali MySQL z m\u00edstn\u00edho syst\u00e9mu.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Pro ukl\u00e1d\u00e1n\u00ed a spr\u00e1vu dat mnoho lid\u00ed vyu\u017e\u00edv\u00e1 zn\u00e1m\u00fd open-source syst\u00e9m pro spr\u00e1vu rela\u010dn\u00edch datab\u00e1z\u00ed zn\u00e1m\u00fd jako MySQL. P\u0159einstalov\u00e1n\u00ed MySQL m\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00fdm krokem v procesu \u0159e\u0161en\u00ed probl\u00e9m\u016f, pokud s n\u00edm n\u011bkdy naraz\u00edte na pot\u00ed\u017ee. V opera\u010dn\u00edch syst\u00e9mech Ubuntu i Windows v\u00e1s v tomto p\u0159\u00edsp\u011bvku provedeme procesem p\u0159einstalace MySQL. P\u0159einstalace MySQL v Ubuntu: 1. Odeberte … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":957,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[217],"tags":[],"class_list":["post-13347","post","type-post","status-publish","format-standard","hentry","category-instalace"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/13347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/957"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=13347"}],"version-history":[{"count":0,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/13347\/revisions"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=13347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=13347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=13347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}