{"id":1209,"date":"2016-07-13T11:49:00","date_gmt":"2016-07-13T03:49:00","guid":{"rendered":"https:\/\/umarzuki.org\/blogku\/?p=1209"},"modified":"2016-07-13T11:49:00","modified_gmt":"2016-07-13T03:49:00","slug":"ekstrak-grant-privilege-mysql","status":"publish","type":"post","link":"https:\/\/umarzuki.org\/blog\/2016\/07\/13\/ekstrak-grant-privilege-mysql\/","title":{"rendered":"ekstrak grant privilege mysql"},"content":{"rendered":"<p>Sumber:<\/p>\n<p><code>mysql -uroot -p -sNe\"`mysql -uroot -p -se\"SELECT CONCAT('SHOW GRANTS FOR \\'',user,'\\'@\\'',host,'\\';') FROM mysql.user;\"`\" > grants.sql<br \/>\n<\/code><\/p>\n<p>Destinasi:<\/p>\n<p>Tambah semicolon pada end of line<br \/>\n<code>awk '{print $0\";\"}' grants.sql > grants2.sql<\/code><\/p>\n<p>Eksport<br \/>\n<code>mysql -uroot -p < grants2.sql<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sumber: mysql -uroot -p -sNe&#8221;`mysql -uroot -p -se&#8221;SELECT CONCAT(&#8216;SHOW GRANTS FOR \\&#8221;,user,&#8217;\\&#8217;@\\&#8221;,host,&#8217;\\&#8217;;&#8217;) FROM mysql.user;&#8221;`&#8221; > grants.sql Destinasi: Tambah semicolon pada end of line awk &#8216;{print $0&#8243;;&#8221;}&#8217; grants.sql > grants2.sql Eksport mysql -uroot -p < grants2.sql\n<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[405,406,407,357,149,408],"class_list":["post-1209","post","type-post","status-publish","format-standard","hentry","category-pengkalan-data","tag-all-user","tag-dump","tag-grants","tag-mariadb","tag-mysql","tag-show"],"_links":{"self":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/1209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/comments?post=1209"}],"version-history":[{"count":0,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/1209\/revisions"}],"wp:attachment":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/media?parent=1209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/categories?post=1209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/tags?post=1209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}