{"id":2708,"date":"2020-05-20T10:54:03","date_gmt":"2020-05-20T09:54:03","guid":{"rendered":"http:\/\/www.jmarior.net\/itank\/?p=2708"},"modified":"2020-05-20T15:18:25","modified_gmt":"2020-05-20T14:18:25","slug":"como-crear-una-base-de-datos-y-usuario-en-mysql-8","status":"publish","type":"post","link":"https:\/\/www.jmarior.net\/itank\/como-crear-una-base-de-datos-y-usuario-en-mysql-8\/","title":{"rendered":"C\u00f3mo crear una base de datos y usuario en MySQL 8"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2709 aligncenter\" src=\"https:\/\/www.jmarior.net\/itank\/files\/mysql-create-user.jpg\" alt=\"\" width=\"598\" height=\"318\" srcset=\"https:\/\/www.jmarior.net\/itank\/files\/mysql-create-user.jpg 598w, https:\/\/www.jmarior.net\/itank\/files\/mysql-create-user-400x213.jpg 400w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<p>Me apunto c\u00f3mo c\u00f3mo crear una base de datos y usuario en MySQL 8 pues el m\u00e9todo cambia con respecto a las versiones anteriores.<br \/>\n<code><br \/>\nCREATE DATABASE database_name;<br \/>\nCREATE USER 'user_name'@'localhost' IDENTIFIED WITH mysql_native_password BY '34$3ZAasSX.5234cdxaQX_ADSse';<br \/>\nGRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'localhost';<br \/>\nFLUSH PRIVILEGES;<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Me apunto c\u00f3mo c\u00f3mo crear una base de datos y usuario en MySQL 8 pues el m\u00e9todo cambia con respecto a las versiones anteriores. CREATE DATABASE database_name; CREATE USER &#8216;user_name&#8217;@&#8217;localhost&#8217; IDENTIFIED WITH mysql_native_password BY &#8217;34$3ZAasSX.5234cdxaQX_ADSse&#8217;; GRANT ALL PRIVILEGES ON database_name.* TO &#8216;user_name&#8217;@&#8217;localhost&#8217;; FLUSH PRIVILEGES;<\/p>\n","protected":false},"author":2,"featured_media":2709,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[123,55,41,1858],"class_list":["post-2708","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itank-ideas","tag-gnu-linux","tag-mysql","tag-ubuntu","tag-ubuntu-server"],"views":320,"_links":{"self":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts\/2708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/comments?post=2708"}],"version-history":[{"count":0,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/posts\/2708\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/media\/2709"}],"wp:attachment":[{"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/media?parent=2708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/categories?post=2708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jmarior.net\/itank\/wp-json\/wp\/v2\/tags?post=2708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}