{"id":11962,"date":"2018-09-17T23:39:23","date_gmt":"2018-09-17T21:39:23","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=11962"},"modified":"2018-09-17T12:40:17","modified_gmt":"2018-09-17T10:40:17","slug":"shell-script-fuer-den-raspberry-pi-linux-zum-anlegen-einer-datenbank-und-user-fuer-mysql-und-maria-db","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=11962","title":{"rendered":"Shell Script f\u00fcr den Raspberry Pi (Linux) zum Anlegen einer Datenbank und User f\u00fcr MySQL und Maria DB"},"content":{"rendered":"<p>Manchmal m\u00f6chte man per Script (sh, bash) eine Datenbank mit User anlegen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/09\/img_3921.jpg\" class=\"wp-image-11967 size-full\" height=\"4032\" width=\"3024\"><\/p>\n<p>Das geht mit diesem Script:<\/p>\n<pre class=\"lang:sh decode:true \">\u2029\u2029sudo  mysql -u root -pPASSWORT &lt;&lt; EOF\u2029CREATE DATABASE DATENBANK-NAME;\u2029CREATE USER 'USER-NAME'@'DOMAIN-NAME';\u2029GRANT ALL PRIVILEGES ON DATENBANK-NAME.* TO 'USER-NAME'@'DOMAIN-NAME' IDENTIFIED BY 'USER-NAME';\u2029EOF\u2029\u2029<\/pre>\n<p>Zu ersetzen ist der DATENBANK-NAME, USER-NAME, DOMAIN-NAME und das PASSWORT. Das Passwort ohne blank nach dem -p angeben. Dann klappt alles automatisch.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Manchmal m\u00f6chte man per Script (sh, bash) eine Datenbank mit User anlegen. Das geht mit diesem Script: \u2029\u2029sudo mysql -u root -pPASSWORT &lt;&lt; EOF\u2029CREATE DATABASE DATENBANK-NAME;\u2029CREATE USER &#8218;USER-NAME&#8217;@&#8217;DOMAIN-NAME&#8216;;\u2029GRANT ALL PRIVILEGES ON DATENBANK-NAME.* TO &#8218;USER-NAME&#8217;@&#8217;DOMAIN-NAME&#8216; IDENTIFIED BY &#8218;USER-NAME&#8216;;\u2029EOF\u2029\u2029 Zu ersetzen ist der DATENBANK-NAME, USER-NAME, DOMAIN-NAME und das PASSWORT. Das Passwort ohne blank nach dem -p angeben. &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/blog.wenzlaff.de\/?p=11962\" class=\"more-link\"><span class=\"screen-reader-text\">\u201eShell Script f\u00fcr den Raspberry Pi (Linux) zum Anlegen einer Datenbank und User f\u00fcr MySQL und Maria DB\u201c <\/span>weiterlesen<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[220,2173,808,79,1023,3388],"tags":[3399,2046,3397,2045,1397,308,3398],"class_list":["post-11962","post","type-post","status-publish","format-standard","hentry","category-anleitung","category-debian","category-linux-2","category-programmierung","category-raspberry-pi","category-script","tag-datenbank-anlegen","tag-db","tag-maria-db","tag-mysql","tag-script","tag-user","tag-user-in-db-anlegen"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/11962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11962"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/11962\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11962"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}