{"id":903,"date":"2024-12-23T09:07:28","date_gmt":"2024-12-23T09:07:28","guid":{"rendered":"https:\/\/wiki.graven-ict.nl\/wordpress\/?p=903"},"modified":"2024-12-23T09:17:24","modified_gmt":"2024-12-23T09:17:24","slug":"reset-mariadb-mysql-password-in-docker-container","status":"publish","type":"post","link":"https:\/\/wiki.graven-ict.nl\/wordpress\/reset-mariadb-mysql-password-in-docker-container\/","title":{"rendered":"Reset mariadb\/mysql password in docker container"},"content":{"rendered":"\n<p>Een behoorlijke tijd geleden voor wat testjes een aantal docker containers aangemaakt 1 daarvan verzorgde een mariadb, al mijn verschillende wachtwoorden getest maar helaas geen werkte ik had de Database toch nodig. dus dan het root wachtwoord maar resetten. Ik start de containers op middels docker compose. om het wachtwoord te kunnen resetten voeg je de volgende regel toe aan je compose file.\u00a0<\/p>\n<pre>entrypoint: mysqld_safe --skip-grant-tables --user=mysql<\/pre>\n<p>start daarna je container op de normale manier met <strong>docker compose up &lt;container_naam&gt; -d <\/strong><\/p><div id=\"grave-439594416\" class=\"grave-content grave-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1970734611769428\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" \ndata-ad-client=\"ca-pub-1970734611769428\" \ndata-ad-slot=\"1820224830\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<pre>edwin@denver:~\/work\/docker-pr-raket$ sudo docker compose up maria-db -d \n[+] Running 2\/2\n &#x2714; Network docker-pr-raket_edwin         Created               0.2s \n &#x2714; Container docker-pr-raket-maria-db-1  Started               0.5s \nedwin@denver:~\/work\/docker-pr-raket$ \n<\/pre>\n<p>stap nu in de container met <strong>docker exec -ti &lt;container_naam&gt; bash<\/strong><\/p>\n<pre>edwin@denver:~\/work\/docker-pr-raket$ sudo docker exec -ti docker-pr-raket-maria-db-1 bash\nroot@ddf52afa1b40:\/# \n<\/pre>\n<p>Je staat nu in de container je kan nu op de normale manier je root password aanpassen.<br \/>mysql -u root -p<br \/>FLUSH PRIVILEGES;<br \/>ALTER USER &#8216;root&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;secret_pass&#8217;;<br \/>FLUSH PRIVILEGES;<\/p>\n<pre>root@aea5a0848b10:\/# mysql -u root -p\nEnter password: \nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 3\nServer version: 10.11.2-MariaDB-1:10.11.2+maria~ubu2204 mariadb.org binary distribution\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]&gt; FLUSH PRIVILEGES;\nQuery OK, 0 rows affected (0.002 sec)\n\nMariaDB [(none)]&gt; ALTER USER 'root'@'localhost' IDENTIFIED BY 'secret_pass';\nQuery OK, 0 rows affected (0.010 sec)\n\nMariaDB [(none)]&gt; FLUSH PRIVILEGES;\nQuery OK, 0 rows affected (0.002 sec)<\/pre>\n<p>Exit mysql en de container. stop je container en verwijder de entrypoint: regel uit de compose file. je kan de container weer opnieuw starten en dan kan je weer met nieuwe password inloggen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Een behoorlijke tijd geleden voor wat testjes een aantal docker containers aangemaakt 1 daarvan verzorgde een mariadb, al mijn verschillende wachtwoorden getest maar helaas geen werkte ik had de Database toch nodig. dus dan het root wachtwoord maar resetten. Ik start de containers op middels docker compose. om het wachtwoord te kunnen resetten voeg je ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/wiki.graven-ict.nl\/wordpress\/reset-mariadb-mysql-password-in-docker-container\/\" title=\"Meer lezen...\">Lees meer<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[93,38],"tags":[],"class_list":["post-903","post","type-post","status-publish","format-standard","hentry","category-docker-software","category-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/comments?post=903"}],"version-history":[{"count":2,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/903\/revisions"}],"predecessor-version":[{"id":906,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/903\/revisions\/906"}],"wp:attachment":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/media?parent=903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/categories?post=903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/tags?post=903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}