{"id":1907,"date":"2019-09-29T11:36:00","date_gmt":"2019-09-29T09:36:00","guid":{"rendered":"https:\/\/myoceane.fr\/?p=1907"},"modified":"2019-09-30T10:33:47","modified_gmt":"2019-09-30T08:33:47","slug":"manage-mysql-privileges","status":"publish","type":"post","link":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/","title":{"rendered":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n\n<p>\u5728\u7ba1\u7406 MySQL \u7684\u6642\u5019\u9700\u8981\u614e\u91cd\u5730\u7ba1\u7406\u6b0a\u9650\uff0c\u4e00\u822c\u4f86\u8aaa\u7ba1\u7406\u8207\u67e5\u770b MySQL \u8cc7\u6599\u5eab\u6709\u4e09\u500b\u8fa6\u6cd5\uff1a<\/p>\n<ol>\n<li style=\"text-align: justify;\">\u4f7f\u7528 root \u5f9e localhost \u4e5f\u5c31\u662f\u5f9e\u4f3a\u670d\u5668\u7aef\u767b\u5165<\/li>\n<li>\u4f7f\u7528 phpmyadmin \u767b\u5165\u7ba1\u7406<\/li>\n<li>\u4f7f\u7528\u5176\u4ed6\u8cc7\u6599\u5eab\u8edf\u9ad4 (\u4f8b\u5982 SQLDeveloper) \u767b\u5165<\/li>\n<\/ol>\n<p>\u9019\u4e09\u500b\u7ba1\u7406\u8fa6\u6cd5\u537b\u9700\u8981\u76f8\u5c0d\u61c9\u7684\u6b0a\u9650\uff0c\u672c\u7bc7\u60f3\u8981\u7e3d\u7d50\u4e00\u4e9b\u6709\u7528\u7684 MySQL \u6307\u4ee4\u5145\u5206\u7ba1\u7406 MySQL \u7684\u6b0a\u9650\uff0c\u65b9\u6cd5\u4e00\u901a\u5e38\u5728\u8cc7\u6599\u5eab\u751f\u6210\u7684\u6642\u5019\u5c31\u6703\u555f\u52d5\u3002<\/p>\n<h5>\u67e5\u770b\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u5217\u8868<\/h5>\n<p>\u9996\u5148\u6211\u5011\u5148\u5229\u7528\u4ee5\u4e0b\u6307\u4ee4\u67e5\u770b\u6240\u6709\u7684\u5728 mysql \u88e1\u9762\u7684\u4f7f\u7528\u8005\u4ed6\u5011\u8207\u4ed6\u5011\u7684 host.<\/p>\n<pre class=\"lang:sql\">SELECT user,host FROM mysql.user;<\/pre>\n<p>\u5f9e\u5f97\u5230\u7684\u8cc7\u8a0a\u6211\u5011\u77e5\u9053\u76ee\u524d\uff0croot \u53ea\u80fd\u5f9e localhost \u7684 host \u767b\u5165<\/p>\n<pre class=\"lang:bash\">+------------------+-----------+\n| user             | host      |\n+------------------+-----------+\n| postfix          | localhost |\n| root             | localhost |\n| user             | localhost |\n+------------------+-----------+\n2 rows in set (0.00 sec)<\/pre>\n<p style=\"text-align: justify;\">\u4f46\u662f\u6b64\u6642\u5982\u679c\u4f7f\u7528 phpmyadmin \u8207 root \u767b\u5165\u7684\u6642\u5019\u537b\u6703\u767c\u751f\u4ee5\u4e0b\u7684\u60c5\u6cc1\uff0c\u5176\u4e2d\u6709\u932f\u8aa4\u8a0a\u606f #1045 &#8211; Access denied for user &#8216;root&#8217;@&#8217;localhost&#8217; (using password: YES) \u7684\u932f\u8aa4\u8a0a\u606f\uff0c\u4f46\u662f\u4f7f\u7528 user \u5e33\u865f\u537b\u53ef\u4ee5\u767b\u5165\uff0c\u76ee\u524d\u70ba\u6b62\u9084\u4e0d\u77e5\u9053\u8981\u600e\u9ebc\u7d66\u4e88 root \u5f9e phpmyadmin \u767b\u5165\u7684\u6b0a\u9650\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/myoceane.fr\/wp-content\/uploads\/2019\/09\/\u87a2\u5e55\u5feb\u7167-2019-09-29-\u4e0b\u53481.02.47-1024x515.png\" alt=\"\" class=\"wp-image-1931\" srcset=\"https:\/\/myoceane.fr\/wp-content\/uploads\/2019\/09\/\u87a2\u5e55\u5feb\u7167-2019-09-29-\u4e0b\u53481.02.47-1024x515.png 1024w, https:\/\/myoceane.fr\/wp-content\/uploads\/2019\/09\/\u87a2\u5e55\u5feb\u7167-2019-09-29-\u4e0b\u53481.02.47-300x151.png 300w, https:\/\/myoceane.fr\/wp-content\/uploads\/2019\/09\/\u87a2\u5e55\u5feb\u7167-2019-09-29-\u4e0b\u53481.02.47-768x386.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h5>\u65b0\u589e\u4f7f\u7528\u8005<\/h5>\n<p>\u70ba\u4e86\u555f\u52d5\u9060\u7aef\u767b\u5165\uff0c\u6211\u5011\u9700\u8981\u8f38\u5165\u4ee5\u4e0b\u6307\u4ee4\u3002<\/p>\n<pre class=\"lang:sql\">CREATE USER 'user'@'%' IDENTIFIED BY 'password';<\/pre>\n<pre class=\"lang:bash\">+------------------+-----------+\n| user             | host      |\n+------------------+-----------+\n| user             | %         |\n| postfix          | localhost |\n| root             | localhost |\n| user             | localhost |\n+------------------+-----------+\n3 rows in set (0.00 sec)<\/pre>\n<h5>\u67e5\u770b\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u6b0a\u9650<\/h5>\n<p>\u5728\u5229\u7528 mysql \u6307\u4ee4\u767b\u5165\u4e4b\u5f8c\uff0c\u6211\u5011\u53ef\u4ee5\u5229\u7528\u4ee5\u4e0b\u7684\u6307\u4ee4\u67e5\u770b\u6b0a\u9650\uff1a<\/p>\n<pre class=\"lang:sql\">SHOW GRANTS for user@localhost;\nSHOW GRANTS for user@'%';<\/pre>\n<p>\u7d50\u679c\u986f\u793a\u5f9e localhost \u7aef\u4f7f\u7528 root \u767b\u5165\u53ef\u4ee5\u4eab\u6709 ALL PRIVILEGES \u7684\u6b0a\u9650<\/p>\n<pre class=\"lang:bash\">+---------------------------------------------------------------------------------------------------------------+\n| Grants for user@localhost                                                                                     |\n+---------------------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD '*****************************************'   |\n| GRANT ALL PRIVILEGES ON `example\\_%`.* TO 'user'@'localhost'                                                  |\n+---------------------------------------------------------------------------------------------------------------+\n\n+-----------------------------------------------------------------------------------------------------+\n| Grants for user@%                                                                                   |\n+-----------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD '*****************************************' |\n+-----------------------------------------------------------------------------------------------------+<\/pre>\n\n\n\n<h5>\u65b0\u589e\u4f7f\u7528\u8005\u6b0a\u9650<\/h5>\n<p>\u4e0b\u5217\u7684\u6307\u4ee4\u53ef\u4ee5\u7d66\u4e88 user \u4f7f\u7528\u8005\u5f9e\u4efb\u4f55\u5730\u65b9\u767b\u5165 (%) \u67e5\u770b\u6216\u662f\u4fee\u6539 example_ \u958b\u982d\u7684\u6240\u6709\u8cc7\u6599\u5eab\u3002<\/p>\n<pre class=\"lang:sql\">GRANT ALL PRIVILEGES ON `example\\_%`.* TO 'user'@'%';<\/pre>\n\n\n\n<p>\u65b0\u589e\u5b8c\u6b64\u4e00\u500b\u6b0a\u9650\u4e4b\u5f8c\uff0c\u6211\u5011\u518d\u91cd\u65b0\u67e5\u770b\u4f7f\u7528\u8005\u6b0a\u9650\u6703\u767c\u73fe\u4ee5\u4e0b\u8cc7\u8a0a\uff1a<\/p>\n<pre class=\"lang:bash\">+-------------------------------------------------------------------------------------------------------+\n| Grants for user@%                                                                                   |\n+-------------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD '*****************************************' |\n| GRANT ALL PRIVILEGES ON `example\\_%`.* TO 'user'@'%'                                               |\n+-------------------------------------------------------------------------------------------------------+<\/pre>\n<h5>\u522a\u9664\u4f7f\u7528\u8005\u6b0a\u9650<\/h5>\n<p>\u5982\u679c\u60f3\u8981\u522a\u9664\u6b0a\u9650\u7684\u6642\u5019\u5247\u662f\u4f7f\u7528\u4ee5\u4e0b\u6307\u4ee4\uff0c\u57f7\u884c\u4e4b\u5f8c user \u7684\u6b0a\u9650\u56de\u5fa9\u5230\u6700\u521d\u7684\u6a23\u8c8c\uff01<\/p>\n<pre class=\"lang:bash\">REVOKE ALL ON `example\\_%`.* from 'user'@'%';<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u7ba1\u7406 MySQL \u7684\u6642\u5019\u9700\u8981\u614e\u91cd\u5730\u7ba1\u7406\u6b0a\u9650\uff0c\u4e00\u822c\u4f86\u8aaa\u7ba1\u7406\u8207\u67e5\u770b MySQL \u8cc7\u6599\u5eab\u6709\u4e09\u500b\u8fa6\u6cd5\uff1a1. \u4f7f\u7528 root \u5f9e localhost \u4e5f\u5c31\u662f\u5f9e\u4f3a\u670d\u5668\u7aef\u767b\u5165\u30022. \u4f7f\u7528 phpmyadmin \u767b\u5165\u30023. \u4f7f\u7528\u5176\u4ed6\u8cc7\u6599\u5eab\u8edf\u9ad4 (\u4f8b\u5982 SQLDeveloper) \u767b\u5165\u3002\u9019\u4e09\u500b\u7ba1\u7406\u8fa6\u6cd5\u537b\u9700\u8981\u76f8\u5c0d\u61c9\u7684\u6b0a\u9650\uff0c\u672c\u7bc7\u60f3\u8981\u7e3d\u7d50\u4e00\u4e9b\u6709\u7528\u7684 MySQL \u6307\u4ee4\u5145\u5206\u7ba1\u7406 MySQL \u7684\u6b0a\u9650\uff0c\u65b9\u6cd5\u4e00\u901a\u5e38\u5728\u8cc7\u6599\u5eab\u751f\u6210\u7684\u6642\u5019\u5c31\u6703\u555f\u52d5\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[33,40,41],"class_list":["post-1907","post","type-post","status-publish","format-standard","hentry","category-website","tag-mysql","tag-phpmyadmin","tag-41"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\" \/>\n<meta property=\"og:description\" content=\"\u5728\u7ba1\u7406 MySQL \u7684\u6642\u5019\u9700\u8981\u614e\u91cd\u5730\u7ba1\u7406\u6b0a\u9650\uff0c\u4e00\u822c\u4f86\u8aaa\u7ba1\u7406\u8207\u67e5\u770b MySQL \u8cc7\u6599\u5eab\u6709\u4e09\u500b\u8fa6\u6cd5\uff1a1. \u4f7f\u7528 root \u5f9e localhost \u4e5f\u5c31\u662f\u5f9e\u4f3a\u670d\u5668\u7aef\u767b\u5165\u30022. \u4f7f\u7528 phpmyadmin \u767b\u5165\u30023. \u4f7f\u7528\u5176\u4ed6\u8cc7\u6599\u5eab\u8edf\u9ad4 (\u4f8b\u5982 SQLDeveloper) \u767b\u5165\u3002\u9019\u4e09\u500b\u7ba1\u7406\u8fa6\u6cd5\u537b\u9700\u8981\u76f8\u5c0d\u61c9\u7684\u6b0a\u9650\uff0c\u672c\u7bc7\u60f3\u8981\u7e3d\u7d50\u4e00\u4e9b\u6709\u7528\u7684 MySQL \u6307\u4ee4\u5145\u5206\u7ba1\u7406 MySQL \u7684\u6b0a\u9650\uff0c\u65b9\u6cd5\u4e00\u901a\u5e38\u5728\u8cc7\u6599\u5eab\u751f\u6210\u7684\u6642\u5019\u5c31\u6703\u555f\u52d5\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\" \/>\n<meta property=\"og:site_name\" content=\"\u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-29T09:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-30T08:33:47+00:00\" \/>\n<meta name=\"author\" content=\"\u6ab8\u6aac\u7238\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6ab8\u6aac\u7238\" \/>\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:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\"},\"author\":{\"name\":\"\u6ab8\u6aac\u7238\",\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"headline\":\"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650\",\"datePublished\":\"2019-09-29T09:36:00+00:00\",\"dateModified\":\"2019-09-30T08:33:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\"},\"wordCount\":38,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"keywords\":[\"MySQL\",\"phpmyadmin\",\"\u4f7f\u7528\u8005\u6b0a\u9650\"],\"articleSection\":[\"Website\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\",\"url\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\",\"name\":\"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\",\"isPartOf\":{\"@id\":\"https:\/\/myoceane.fr\/#website\"},\"datePublished\":\"2019-09-29T09:36:00+00:00\",\"dateModified\":\"2019-09-30T08:33:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myoceane.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myoceane.fr\/#website\",\"url\":\"https:\/\/myoceane.fr\/\",\"name\":\"M-Y-Oceane \u60f3\u65b9\u6d89\u6cd5\u3002\u91cf\u74f6\u5916\u7684\u5929\u7a7a\",\"description\":\"\u60f3\u65b9\u6d89\u6cd5, France, Taiwan, Health, Information Technology\",\"publisher\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myoceane.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\",\"name\":\"\u6ab8\u6aac\u7238\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g\",\"caption\":\"\u6ab8\u6aac\u7238\"},\"logo\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/myoceane.fr\/index.php\/author\/johnny5584767gmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/","og_locale":"en_US","og_type":"article","og_title":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","og_description":"\u5728\u7ba1\u7406 MySQL \u7684\u6642\u5019\u9700\u8981\u614e\u91cd\u5730\u7ba1\u7406\u6b0a\u9650\uff0c\u4e00\u822c\u4f86\u8aaa\u7ba1\u7406\u8207\u67e5\u770b MySQL \u8cc7\u6599\u5eab\u6709\u4e09\u500b\u8fa6\u6cd5\uff1a1. \u4f7f\u7528 root \u5f9e localhost \u4e5f\u5c31\u662f\u5f9e\u4f3a\u670d\u5668\u7aef\u767b\u5165\u30022. \u4f7f\u7528 phpmyadmin \u767b\u5165\u30023. \u4f7f\u7528\u5176\u4ed6\u8cc7\u6599\u5eab\u8edf\u9ad4 (\u4f8b\u5982 SQLDeveloper) \u767b\u5165\u3002\u9019\u4e09\u500b\u7ba1\u7406\u8fa6\u6cd5\u537b\u9700\u8981\u76f8\u5c0d\u61c9\u7684\u6b0a\u9650\uff0c\u672c\u7bc7\u60f3\u8981\u7e3d\u7d50\u4e00\u4e9b\u6709\u7528\u7684 MySQL \u6307\u4ee4\u5145\u5206\u7ba1\u7406 MySQL \u7684\u6b0a\u9650\uff0c\u65b9\u6cd5\u4e00\u901a\u5e38\u5728\u8cc7\u6599\u5eab\u751f\u6210\u7684\u6642\u5019\u5c31\u6703\u555f\u52d5\u3002","og_url":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/","og_site_name":"\u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","article_published_time":"2019-09-29T09:36:00+00:00","article_modified_time":"2019-09-30T08:33:47+00:00","author":"\u6ab8\u6aac\u7238","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u6ab8\u6aac\u7238","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#article","isPartOf":{"@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/"},"author":{"name":"\u6ab8\u6aac\u7238","@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"headline":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650","datePublished":"2019-09-29T09:36:00+00:00","dateModified":"2019-09-30T08:33:47+00:00","mainEntityOfPage":{"@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/"},"wordCount":38,"commentCount":0,"publisher":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"keywords":["MySQL","phpmyadmin","\u4f7f\u7528\u8005\u6b0a\u9650"],"articleSection":["Website"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/","url":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/","name":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650 - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","isPartOf":{"@id":"https:\/\/myoceane.fr\/#website"},"datePublished":"2019-09-29T09:36:00+00:00","dateModified":"2019-09-30T08:33:47+00:00","breadcrumb":{"@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/myoceane.fr\/index.php\/manage-mysql-privileges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myoceane.fr\/"},{"@type":"ListItem","position":2,"name":"[Website] \u7ba1\u7406 MySQL \u6b0a\u9650"}]},{"@type":"WebSite","@id":"https:\/\/myoceane.fr\/#website","url":"https:\/\/myoceane.fr\/","name":"M-Y-Oceane \u60f3\u65b9\u6d89\u6cd5\u3002\u91cf\u74f6\u5916\u7684\u5929\u7a7a","description":"\u60f3\u65b9\u6d89\u6cd5, France, Taiwan, Health, Information Technology","publisher":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myoceane.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b","name":"\u6ab8\u6aac\u7238","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/myoceane.fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g","caption":"\u6ab8\u6aac\u7238"},"logo":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/image\/"},"url":"https:\/\/myoceane.fr\/index.php\/author\/johnny5584767gmail-com\/"}]}},"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/1907","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/comments?post=1907"}],"version-history":[{"count":95,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/1907\/revisions"}],"predecessor-version":[{"id":2004,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/1907\/revisions\/2004"}],"wp:attachment":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/media?parent=1907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/categories?post=1907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/tags?post=1907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}