{"id":1985,"date":"2023-04-01T10:49:13","date_gmt":"2023-04-01T02:49:13","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=1985"},"modified":"2024-01-10T21:53:50","modified_gmt":"2024-01-10T13:53:50","slug":"amazon-rds-cannot-execute-set-global-command","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/amazon-rds-cannot-execute-set-global-command\/","title":{"rendered":"Amazon RDS\u65e0\u6cd5\u6267\u884cSET GLOBAL\u547d\u4ee4"},"content":{"rendered":"<p>\u5728AWS RDS\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u3002\u8fd0\u884c\u4e00\u4e9b<code>SET GLOBAL<\/code>\u547d\u4ee4\uff0c\u4f8b\u5982\uff1a<\/p>\n<pre><code class=\"language-sql\">SET GLOBAL group_concat_max_len = 10240<\/code><\/pre>\n<p>\u4f46\u662f\u5f53\u8fd0\u884c\u6b64\u547d\u4ee4\u65f6\u51fa\u73b0\u9519\u8bef\uff1a<\/p>\n<p><!-- more --><\/p>\n<pre><code class=\"language-sql\">SET GLOBAL group_concat_max_len = 10240\n\n[Err] #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation<\/code><\/pre>\n<p><div class=\"erphp-wppay payme payme-center\">\r\n                <div class=\"payme-toggle\">\r\n                <div id=\"wppay-payment-todo\" style=\"display: inline\">\r\n                  \u60a8\u9700\u8981\u5148\u652f\u4ed8 <b>0.2\u5143<\/b> \u624d\u80fd\u67e5\u770b\u6b64\u5904\u5185\u5bb9\uff01<br\/><br\/><a href=\"javascript:;\" class=\"erphp-wppay-loader btn btn-link\" data-post=\"1985\"><span style=\"color: white; \">\u7acb\u5373\u652f\u4ed8<\/span><\/a><br\/>\r\n                  <a id=\"wppay-query-link\" href=\"javascript:;\">\u5df2\u652f\u4ed8\uff1f\u70b9\u51fb\u8fd9\u91cc\u67e5\u8be2<\/a>\r\n                <\/div>\r\n\t\t\t\t<div id=\"wppay-payment-query\" style=\"display: none\">\r\n\t\t\t\t  <div id=\"wppay-query-form\">\r\n                    <input type=\"hidden\" name=\"post_id\" value=\"1985\">\r\n                    <input type=\"hidden\" name=\"post_title\" value=\"\">\r\n                    <input type=\"hidden\" name=\"post_url\" value=\"\">\r\n                    <input type=\"hidden\" name=\"post_price\" value=\"5.00\">\r\n                    <div>\r\n                        <label for=\"query_string\">\u5546\u5bb6\u8ba2\u5355\u53f7\/\u8ba2\u5355\u53f7\uff1a<\/label>\r\n                        <input type=\"text\" id=\"order_num\" name=\"order_num\" style=\"width:300px\" aria-required=\"true\" aria-invalid=\"true\" autofocus=\"\" placeholder=\"\u5546\u5bb6\u8ba2\u5355\u53f7\/\u8ba2\u5355\u53f7\">\r\n                        <button class=\"btn payme-btn\" name=\"button\" id=\"do-payment-query\"><span style=\"color: white; \">\u67e5 \u8be2<\/span><\/button>\r\n                    <\/div>\r\n                    <div>\r\n                        \uff08<a id=\"wppay-alipay-help-link\" href=\"javascript:;\">\u5982\u4f55\u67e5\u770b\u5546\u5bb6\u8ba2\u5355\u53f7\/\u8ba2\u5355\u53f7?<\/a>\uff09<br\/>\r\n                        <a id=\"wppay-pay-link\" href=\"javascript:;\">\u8fd4\u56de\u7ee7\u7eed\u652f\u4ed8<\/a><br\/>\r\n                        <div id=\"alipay-get-out-trade-no\" style=\"display: none;\">\r\n                          <br\/>\r\n                          <img decoding=\"async\" style=\"max-width: 100%\" src=\"\/wp-content\/uploads\/2024\/01\/get_alipay_out_trade_no.png\" alt=\"\"\/>\r\n                        <\/div>\r\n                    <\/div>\r\n                  <\/div>\r\n                <\/div>\r\n\t\t\t<\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728AWS RDS\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u3002\u8fd0\u884c\u4e00\u4e9bSET GLOBAL\u547d\u4ee4\uff0c\u4f8b\u5982\uff1a SET GLOBAL grou [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[90],"tags":[400,406],"class_list":["post-1985","post","type-post","status-publish","format-standard","hentry","category-cloud-devops","tag-aws","tag-rds"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1985"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1985\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}