{"id":148,"date":"2014-02-26T00:41:22","date_gmt":"2014-02-25T22:41:22","guid":{"rendered":"http:\/\/crazyice.net\/?p=148"},"modified":"2014-02-26T00:50:31","modified_gmt":"2014-02-25T22:50:31","slug":"mysql-sql-skript-zum-erstellen-eines-benutzers","status":"publish","type":"post","link":"https:\/\/crazyice.net\/?p=148","title":{"rendered":"MySQL – SQL Skript zum Erstellen eines Benutzers"},"content":{"rendered":"

Um einen Benutzer in MySQL per SQL Skript zu erstellen k\u00f6nnen folgende SQL Befehle verwendet werden:<\/p>\n

CREATE USER 'myusername'@'%' IDENTIFIED BY 'MyPw';<\/p>\n

GRANT USAGE ON * . * TO 'myusername'@'%' IDENTIFIED BY 'MyPw' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;<\/p>\n

GRANT ALL PRIVILEGES ON `myusername\\_%` . * TO 'mydatabase'@'%';<\/code><\/p>\n

Mit Hilfe dieses Skripts wird ein Benutzer mit dem Namen „myusername“ und dem Passwort „MyPw“ erstellt. Dieser darf sich auf alle Host verbinden und hat keine Einschr\u00e4nkungen in Hinblick auf „MAX_QUERIES_PER_HOUR“, „MAX_CONNECTIONS_PER_HOUR“, „MAX_UPDATES_PER_HOUR“, „MAX_USER_CONNECTIONS“.
\nWeiters erh\u00e4lt dieser volle Berechtigung (ALL PRIVILEGES) auf die Datenbank „mydatabase“.<\/p>\n","protected":false},"excerpt":{"rendered":"

Um einen Benutzer in MySQL per SQL Skript zu erstellen k\u00f6nnen folgende SQL Befehle verwendet werden: CREATE USER ‚myusername’@’%‘ IDENTIFIED BY ‚MyPw‘; GRANT USAGE ON * . * TO ‚myusername’@’%‘ IDENTIFIED BY ‚MyPw‘ WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; GRANT ALL PRIVILEGES ON `myusername\\_%` . * TO ‚mydatabase’@’%‘; Mit Hilfe dieses … MySQL – SQL Skript zum Erstellen eines Benutzers<\/span> weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[42,43,44,46,47,45],"class_list":["post-148","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-database","tag-datenbank-2","tag-mysql-2","tag-script","tag-skript","tag-sql"],"_links":{"self":[{"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/posts\/148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/crazyice.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=148"}],"version-history":[{"count":3,"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/posts\/148\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/crazyice.net\/index.php?rest_route=\/wp\/v2\/posts\/148\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/crazyice.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crazyice.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crazyice.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}