{"id":421,"date":"2022-07-22T14:49:11","date_gmt":"2022-07-22T05:49:11","guid":{"rendered":"https:\/\/www.bees-team.com\/?p=421"},"modified":"2022-07-22T15:26:04","modified_gmt":"2022-07-22T06:26:04","slug":"mysql-grant-xem-va-cap-quyen-cho-user","status":"publish","type":"post","link":"https:\/\/www.bees-team.com\/?p=421","title":{"rendered":"MySQL – GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user."},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>33 Second <\/div>\n\n <\/div>

T\u1ea1o user cho c\u01a1 s\u1edf d\u1eef li\u1ec7u Mysql.<\/h3>\n

CREATE USER 'user_name'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'password';<\/code>
\nCREATE USER 'user_name'@'%' IDENTIFIED BY 'password';<\/code>
\nCREATE USER 'user_name'@'localhost' IDENTIFIED BY 'password';<\/code><\/p>\n

Set l\u1ea1i Password cho User<\/h3>\n

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='user_name';<\/code><\/p>\n

Xem quy\u1ec1n hi\u1ec7n t\u1ea1i c\u1ee7a user<\/h3>\n

show grants FOR 'user_name'<\/code><\/p>\n

C\u1ea5p quy\u1ec1n cho user.<\/h3>\n

Cho user \u0111\u01b0\u1ee3c to\u00e0n quy\u1ec1n tr\u00ean DB.
\nGRANT all ON database_name.* TO 'user_name'@'%' IDENTIFIED BY PASSWORD '*E6E1D7001B7D56F...';<\/code>
\nCho user ch\u1ec9 c\u00f3 quy\u1ec1n Select v\u00e0 xem
\nGRANT SELECT, EXECUTE, SHOW VIEW ON `database_name`.* TO 'user_name'@'xxx.xxx.xxx.xxx'<\/code><\/p>\n

\n
\n \n
\n \n \"Happy\"\n <\/a>\n
\n Happy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sad\"\n <\/a>\n
\n Sad <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Excited\"\n <\/a>\n
\n Excited <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sleepy\"\n <\/a>\n
\n Sleepy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Angry\"\n <\/a>\n
Angry<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n \n <\/div>\n <\/div>\n\n
\n \n \"Surprise\"\n <\/a>\n
Surprise<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n <\/div>\n <\/div>\n\n <\/div>","protected":false},"excerpt":{"rendered":"

T\u1ea1o user cho c\u01a1 s\u1edf d\u1eef li\u1ec7u Mysql. CREATE USERRead More<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":428,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-experiment-about-sql"],"yoast_head":"\nMySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log\" \/>\n<meta property=\"og:description\" content=\"T\u1ea1o user cho c\u01a1 s\u1edf d\u1eef li\u1ec7u Mysql. CREATE USERRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bees-team.com\/?p=421\" \/>\n<meta property=\"og:site_name\" content=\"Experiment Log\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-22T05:49:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T06:26:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bees-Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bees-Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421\"},\"author\":{\"name\":\"Bees-Team\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\"},\"headline\":\"MySQL – GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user.\",\"datePublished\":\"2022-07-22T05:49:11+00:00\",\"dateModified\":\"2022-07-22T06:26:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421\"},\"wordCount\":69,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/mysql_grant.png\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.bees-team.com\\\/?p=421#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421\",\"name\":\"MySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/mysql_grant.png\",\"datePublished\":\"2022-07-22T05:49:11+00:00\",\"dateModified\":\"2022-07-22T06:26:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bees-team.com\\\/?p=421\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#primaryimage\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/mysql_grant.png\",\"contentUrl\":\"https:\\\/\\\/www.bees-team.com\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/mysql_grant.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/?p=421#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.bees-team.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL – GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#website\",\"url\":\"https:\\\/\\\/www.bees-team.com\\\/\",\"name\":\"Experiment Log\",\"description\":\"Just note what I did\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bees-team.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bees-team.com\\\/#\\\/schema\\\/person\\\/974321230684f994b6f3a28aa132b197\",\"name\":\"Bees-Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g\",\"caption\":\"Bees-Team\"},\"sameAs\":[\"https:\\\/\\\/www.bees-team.com\\\/\"],\"url\":\"https:\\\/\\\/www.bees-team.com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"MySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log","og_description":"T\u1ea1o user cho c\u01a1 s\u1edf d\u1eef li\u1ec7u Mysql. CREATE USERRead More","og_url":"https:\/\/www.bees-team.com\/?p=421","og_site_name":"Experiment Log","article_published_time":"2022-07-22T05:49:11+00:00","article_modified_time":"2022-07-22T06:26:04+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png","type":"image\/png"}],"author":"Bees-Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bees-Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bees-team.com\/?p=421#article","isPartOf":{"@id":"https:\/\/www.bees-team.com\/?p=421"},"author":{"name":"Bees-Team","@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197"},"headline":"MySQL – GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user.","datePublished":"2022-07-22T05:49:11+00:00","dateModified":"2022-07-22T06:26:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bees-team.com\/?p=421"},"wordCount":69,"commentCount":0,"image":{"@id":"https:\/\/www.bees-team.com\/?p=421#primaryimage"},"thumbnailUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bees-team.com\/?p=421#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bees-team.com\/?p=421","url":"https:\/\/www.bees-team.com\/?p=421","name":"MySQL - GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user. - Experiment Log","isPartOf":{"@id":"https:\/\/www.bees-team.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bees-team.com\/?p=421#primaryimage"},"image":{"@id":"https:\/\/www.bees-team.com\/?p=421#primaryimage"},"thumbnailUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png","datePublished":"2022-07-22T05:49:11+00:00","dateModified":"2022-07-22T06:26:04+00:00","author":{"@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197"},"breadcrumb":{"@id":"https:\/\/www.bees-team.com\/?p=421#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bees-team.com\/?p=421"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bees-team.com\/?p=421#primaryimage","url":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png","contentUrl":"https:\/\/www.bees-team.com\/wp-content\/uploads\/2022\/07\/mysql_grant.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.bees-team.com\/?p=421#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bees-team.com\/"},{"@type":"ListItem","position":2,"name":"MySQL – GRANT: T\u1ea1o user, set l\u1ea1i password, xem v\u00e0 c\u1ea5p quy\u1ec1n cho user."}]},{"@type":"WebSite","@id":"https:\/\/www.bees-team.com\/#website","url":"https:\/\/www.bees-team.com\/","name":"Experiment Log","description":"Just note what I did","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bees-team.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.bees-team.com\/#\/schema\/person\/974321230684f994b6f3a28aa132b197","name":"Bees-Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/add4cc7534eb8184e1e6e0291e67fde3d200af851c04f17ba570f8c50e71f09f?s=96&d=monsterid&r=g","caption":"Bees-Team"},"sameAs":["https:\/\/www.bees-team.com\/"],"url":"https:\/\/www.bees-team.com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=421"}],"version-history":[{"count":12,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":434,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions\/434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=\/wp\/v2\/media\/428"}],"wp:attachment":[{"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bees-team.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}