{"id":602,"date":"2023-09-20T14:59:29","date_gmt":"2023-09-20T12:59:29","guid":{"rendered":"http:\/\/www.tippex.net\/?p=602"},"modified":"2023-09-20T15:04:17","modified_gmt":"2023-09-20T13:04:17","slug":"mysql-passwort-unter-ubuntu-22-04-erstellen","status":"publish","type":"post","link":"https:\/\/www.tippex.net\/?p=602","title":{"rendered":"Mysql Passwort unter Ubuntu 22.04 erstellen"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Installiert man mysql-server unter Ubuntu 22.04 wird man w\u00e4hrend der Installationsroutine nicht nach einem Password gefragt. Damit das Root-Login sicher ist, m\u00fcssen wir diese Passwort erst noch selbst setzen. Dazu geht wie folgt vor:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1.) In einem beliebigen Verzeichnis erstellt ihr eine Datei mit z.B dem Namen <strong>&#8222;mysl-passwort&#8220;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.) In die Datei schreibt ihr diesen Inhalt: <code><strong>ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORT';<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">    Wobei  Ihr das Wort &#8218;Password&#8216; mit eurem eigenen Passwort austauscht. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3.) Nun stoppen wir den Mysql: <strong>sudo systemctl stop mysql<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4.) Wir lesen das Passwort ein: <strong>sudo mysqld -init-file=mysql-passwort<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5.) Wir k\u00f6nnen den Mysql Server wieder starten: <strong>sudo systemctl start mysql<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nun k\u00f6nnen wir uns mittels <strong>&#8222;mysql -u root -p&#8220;<\/strong>  in Mysql einloggen<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installiert man mysql-server unter Ubuntu 22.04 wird man w\u00e4hrend der Installationsroutine nicht nach einem Password gefragt. Damit das Root-Login sicher ist, m\u00fcssen wir diese Passwort erst noch selbst setzen. Dazu geht wie folgt vor: 1.) In einem beliebigen Verzeichnis erstellt ihr eine Datei mit z.B dem Namen &#8222;mysl-passwort&#8220; 2.) In die Datei schreibt ihr diesen [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":49,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,8,17],"tags":[69,71,70],"class_list":["post-602","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-anleitung","category-linux","category-security","tag-mysql","tag-passwort","tag-root","wpbf-post"],"_links":{"self":[{"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/posts\/602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tippex.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=602"}],"version-history":[{"count":2,"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/posts\/602\/revisions"}],"predecessor-version":[{"id":604,"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/posts\/602\/revisions\/604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tippex.net\/index.php?rest_route=\/wp\/v2\/media\/49"}],"wp:attachment":[{"href":"https:\/\/www.tippex.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tippex.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tippex.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}