{"id":73,"date":"2013-12-29T01:52:56","date_gmt":"2013-12-29T00:52:56","guid":{"rendered":"http:\/\/ts3index.com\/blog\/?p=73"},"modified":"2015-07-23T01:11:23","modified_gmt":"2015-07-23T00:11:23","slug":"zugangsdaten-der-mysql-datenbank-vergessen","status":"publish","type":"post","link":"https:\/\/ts3index.com\/blog\/73-zugangsdaten-der-mysql-datenbank-vergessen\/","title":{"rendered":"Zugangsdaten der MySQL-Datenbank vergessen"},"content":{"rendered":"<p><\/p>\n<p><p>Etwas zu vergessen, das geh\u00f6rt f\u00fcr Menschen zum Alltag. Ein wichtiges Passwort oder komplette Zugangsdaten zu vergessen kann ein gro\u00dfer Schock sein. Schlimm nur, wenn sonst keine Benutzer mit Adminrechten existieren. Es gibt einen einfachen Weg das Passwort des Benutzers &#8218;root&#8216; zu \u00e4ndern oder zur\u00fcckzusetzen.<!--more--><\/p>\n<p>Sollte der MySQL-Server direkt und \u00f6ffentlich \u00fcber das Internet erreichbar sein, sollte der Zugriff mit Hilfe einer iptables-Regel eingeschr\u00e4nkt werden, da sich nach der Durchf\u00fchrung alle User ohne Passwort einloggen k\u00f6nnen.<\/p>\n<p>1. MySQL-Server stoppen:<\/p>\n<pre class=\"lang:sh decode:true\">\/etc\/init.d\/mysql stop<\/pre>\n<p>2. Mit Hilfe von WinSCP oder Putty am Ende der Datei <code>\/etc\/mysql\/my.cnf<\/code> folgendes einf\u00fcgen:<\/p>\n<pre class=\"lang:sh decode:true\">--skip-grant-tables<\/pre>\n<p>Durch diesen Befehl wird nach dem Start die Berechtigungstabellen ignoriert und jeder(!) User kann sich ohne Kennwort einloggen.<\/p>\n<p>3. MySQL-Server starten:<\/p>\n<pre class=\"lang:sh decode:true\">\/etc\/init.d\/mysql start<\/pre>\n<p>4. MySQL-Client starten und neues Passwort festlegen:<\/p>\n<pre class=\"lang:sh decode:true\">mysql -u root mysql\r\nmysql> UPDATE users SET Password=PASSWORD(\u2018meingeheimespasswort\u2019) WHERE User=\u2019root\u2019;\r\nmysql> exit<\/pre>\n<p>Das Passwort ist in diesem Beispiel <code>meingeheimespasswort<\/code> und kann nat\u00fcrlich abge\u00e4ndert werden.<\/p>\n<p>5. MySQL-Server stoppen:<\/p>\n<pre class=\"lang:sh decode:true\">\/etc\/init.d\/mysql stop<\/pre>\n<p>6. \u201c\u2013skip-grant-tables\u201c wieder aus der Datei <code>\/etc\/mysql\/my.cnf<\/code> entfernen<\/p>\n<p>7. MySQL-Server starten:<\/p>\n<pre class=\"lang:sh decode:true\">\/etc\/init.d\/mysql start<\/pre>\n<p>Wenn keine Fehler aufgetreten sind, sollte der MySQL-Server laufen und das Passwort ge\u00e4ndert sein.<\/p>\n<\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Etwas zu vergessen, das geh\u00f6rt f\u00fcr Menschen zum Alltag. Ein wichtiges Passwort oder komplette Zugangsdaten zu vergessen kann ein gro\u00dfer Schock sein. Schlimm nur, wenn sonst keine Benutzer mit Adminrechten existieren. Es gibt einen&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[88],"tags":[23,26,27,87,14,29,28],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Zugangsdaten der MySQL-Datenbank vergessen<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/ts3index.com\/blog\/?p=73\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Zugangsdaten der MySQL-Datenbank vergessen\" \/>\n<meta property=\"og:description\" content=\"Etwas zu vergessen, das geh\u00f6rt f\u00fcr Menschen zum Alltag. Ein wichtiges Passwort oder komplette Zugangsdaten zu vergessen kann ein gro\u00dfer Schock sein. Schlimm nur, wenn sonst keine Benutzer mit Adminrechten existieren. Es gibt einen&#046;&#046;&#046;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/ts3index.com\/blog\/?p=73\" \/>\n<meta property=\"og:site_name\" content=\"TS3index.com Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ts3index\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-29T00:52:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-07-23T00:11:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/Zugangsdaten-der-MySQL-Datenbank-vergessen.png\" \/>\n\t<meta property=\"og:image:width\" content=\"520\" \/>\n\t<meta property=\"og:image:height\" content=\"245\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"TS3index.com\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"TS3index.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/ts3index.com\/blog\/?p=73#article\",\"isPartOf\":{\"@id\":\"http:\/\/ts3index.com\/blog\/?p=73\"},\"author\":{\"name\":\"TS3index.com\",\"@id\":\"http:\/\/ts3index.com\/blog\/#\/schema\/person\/ddaa3254c1cef894c9c3140cde198f91\"},\"headline\":\"Zugangsdaten der MySQL-Datenbank vergessen\",\"datePublished\":\"2013-12-29T00:52:56+00:00\",\"dateModified\":\"2015-07-23T00:11:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/ts3index.com\/blog\/?p=73\"},\"wordCount\":173,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/ts3index.com\/blog\/#organization\"},\"keywords\":[\"Linux\",\"MySQL\",\"Passwort\",\"Root\",\"Server\",\"SQL\",\"Zugangsdaten\"],\"articleSection\":[\"Linux\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/ts3index.com\/blog\/?p=73\",\"url\":\"http:\/\/ts3index.com\/blog\/?p=73\",\"name\":\"Zugangsdaten der MySQL-Datenbank vergessen\",\"isPartOf\":{\"@id\":\"http:\/\/ts3index.com\/blog\/#website\"},\"datePublished\":\"2013-12-29T00:52:56+00:00\",\"dateModified\":\"2015-07-23T00:11:23+00:00\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/ts3index.com\/blog\/?p=73\"]}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/ts3index.com\/blog\/#website\",\"url\":\"http:\/\/ts3index.com\/blog\/\",\"name\":\"TS3index.com Blog\",\"description\":\"Neuigkeiten, Fragen &amp; Antworten\",\"publisher\":{\"@id\":\"http:\/\/ts3index.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/ts3index.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/ts3index.com\/blog\/#organization\",\"name\":\"TS3index.com\",\"url\":\"http:\/\/ts3index.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"http:\/\/ts3index.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/ts3index_com_hosting_logo.png\",\"contentUrl\":\"https:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/ts3index_com_hosting_logo.png\",\"width\":125,\"height\":161,\"caption\":\"TS3index.com\"},\"image\":{\"@id\":\"http:\/\/ts3index.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ts3index\",\"https:\/\/twitter.com\/ts3index\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/ts3index.com\/blog\/#\/schema\/person\/ddaa3254c1cef894c9c3140cde198f91\",\"name\":\"TS3index.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"http:\/\/ts3index.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cf4450657d51a136b9d89c7b2d43c6a7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cf4450657d51a136b9d89c7b2d43c6a7?s=96&d=mm&r=g\",\"caption\":\"TS3index.com\"},\"url\":\"https:\/\/ts3index.com\/blog\/author\/ts3index\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Zugangsdaten der MySQL-Datenbank vergessen","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":"http:\/\/ts3index.com\/blog\/?p=73","og_locale":"de_DE","og_type":"article","og_title":"Zugangsdaten der MySQL-Datenbank vergessen","og_description":"Etwas zu vergessen, das geh\u00f6rt f\u00fcr Menschen zum Alltag. Ein wichtiges Passwort oder komplette Zugangsdaten zu vergessen kann ein gro\u00dfer Schock sein. Schlimm nur, wenn sonst keine Benutzer mit Adminrechten existieren. Es gibt einen&#46;&#46;&#46;","og_url":"http:\/\/ts3index.com\/blog\/?p=73","og_site_name":"TS3index.com Blog","article_publisher":"https:\/\/www.facebook.com\/ts3index","article_published_time":"2013-12-29T00:52:56+00:00","article_modified_time":"2015-07-23T00:11:23+00:00","og_image":[{"width":520,"height":245,"url":"http:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/Zugangsdaten-der-MySQL-Datenbank-vergessen.png","type":"image\/png"}],"author":"TS3index.com","twitter_misc":{"Verfasst von":"TS3index.com","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/ts3index.com\/blog\/?p=73#article","isPartOf":{"@id":"http:\/\/ts3index.com\/blog\/?p=73"},"author":{"name":"TS3index.com","@id":"http:\/\/ts3index.com\/blog\/#\/schema\/person\/ddaa3254c1cef894c9c3140cde198f91"},"headline":"Zugangsdaten der MySQL-Datenbank vergessen","datePublished":"2013-12-29T00:52:56+00:00","dateModified":"2015-07-23T00:11:23+00:00","mainEntityOfPage":{"@id":"http:\/\/ts3index.com\/blog\/?p=73"},"wordCount":173,"commentCount":0,"publisher":{"@id":"http:\/\/ts3index.com\/blog\/#organization"},"keywords":["Linux","MySQL","Passwort","Root","Server","SQL","Zugangsdaten"],"articleSection":["Linux"],"inLanguage":"de"},{"@type":"WebPage","@id":"http:\/\/ts3index.com\/blog\/?p=73","url":"http:\/\/ts3index.com\/blog\/?p=73","name":"Zugangsdaten der MySQL-Datenbank vergessen","isPartOf":{"@id":"http:\/\/ts3index.com\/blog\/#website"},"datePublished":"2013-12-29T00:52:56+00:00","dateModified":"2015-07-23T00:11:23+00:00","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["http:\/\/ts3index.com\/blog\/?p=73"]}]},{"@type":"WebSite","@id":"http:\/\/ts3index.com\/blog\/#website","url":"http:\/\/ts3index.com\/blog\/","name":"TS3index.com Blog","description":"Neuigkeiten, Fragen &amp; Antworten","publisher":{"@id":"http:\/\/ts3index.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/ts3index.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"http:\/\/ts3index.com\/blog\/#organization","name":"TS3index.com","url":"http:\/\/ts3index.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"http:\/\/ts3index.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/ts3index_com_hosting_logo.png","contentUrl":"https:\/\/ts3index.com\/blog\/wp-content\/uploads\/2013\/12\/ts3index_com_hosting_logo.png","width":125,"height":161,"caption":"TS3index.com"},"image":{"@id":"http:\/\/ts3index.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ts3index","https:\/\/twitter.com\/ts3index"]},{"@type":"Person","@id":"http:\/\/ts3index.com\/blog\/#\/schema\/person\/ddaa3254c1cef894c9c3140cde198f91","name":"TS3index.com","image":{"@type":"ImageObject","inLanguage":"de","@id":"http:\/\/ts3index.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cf4450657d51a136b9d89c7b2d43c6a7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cf4450657d51a136b9d89c7b2d43c6a7?s=96&d=mm&r=g","caption":"TS3index.com"},"url":"https:\/\/ts3index.com\/blog\/author\/ts3index\/"}]}},"_links":{"self":[{"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/posts\/73"}],"collection":[{"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":9,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":328,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions\/328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/media\/222"}],"wp:attachment":[{"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ts3index.com\/blog\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}