{"id":28453,"date":"2023-12-25T23:32:36","date_gmt":"2023-08-17T22:23:54","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/"},"modified":"2025-08-12T08:16:50","modified_gmt":"2025-08-12T00:16:50","slug":"%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/","title":{"rendered":"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c"},"content":{"rendered":"<h1>\u7b80\u800c\u8a00\u4e4b\u8fd9\u662f\u5173\u4e8e\u5c06MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7684\u5907\u5fd8\u5f55\u3002<\/p>\n<h2>\u6211\u8bd5\u7740\u7528yum\u6765\u505a\u4e00\u4e0b\u3002<\/p>\n<ul class=\"post-ul\">\u73fe\u5728\u306e\u8a2d\u5b9a\u3092\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>vi \/etc\/yum.repos.d\/MariaDB.repo\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u305f\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306bURL\u3092\u5909\u66f4<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u4eca\u56de\u306f10.1\u306e\u90e8\u5206\u309210.2\u306b\u66f8\u304d\u63db\u3048\u307e\u3057\u305f\u3002<\/ul>\n<pre class=\"post-pre\"><code># MariaDB 10.1 CentOS repository list - created 2016-03-13 07:22 UTC\r\n# http:\/\/mariadb.org\/mariadb\/repositories\/\r\n[mariadb]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.1\/centos6-amd64  # \u3053\u3053\u3092\u5909\u3048\u308b\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u73fe\u5728\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>rpm <span class=\"nt\">-qa<\/span> | <span class=\"nb\">grep<\/span> <span class=\"nt\">-i<\/span> mariadb\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> MariaDB-server MariaDB-client\r\n<\/code><\/pre>\n<p>\u8fd0\u884c\u7ed3\u679c<\/p>\n<pre class=\"post-pre\"><code>Loaded plugins: priorities, update-motd, upgrade-helper\r\namzn-main                                                          | 2.1 kB  00:00:00\r\namzn-updates                                                       | 2.3 kB  00:00:00\r\nmariadb                                                            | 2.9 kB  00:00:00\r\nmariadb\/primary_db                                                 |  42 kB  00:00:00\r\n89 packages excluded due to repository priority protections\r\nResolving Dependencies\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Running transaction check\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-client.x86_64 0:10.1.43-1.el6 will be updated\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-client.x86_64 0:10.2.30-1.el6 will be an update\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-server.x86_64 0:10.1.43-1.el6 will be updated\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-server.x86_64 0:10.2.30-1.el6 will be an update\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n<span class=\"o\">==========================================================================================<\/span>\r\n Package                 Arch            Version                   Repository        Size\r\n<span class=\"o\">==========================================================================================<\/span>\r\nUpdating:\r\n MariaDB-client          x86_64          10.2.30-1.el6             mariadb           49 M\r\n MariaDB-server          x86_64          10.2.30-1.el6             mariadb          112 M\r\n\r\nTransaction Summary\r\n<span class=\"o\">==========================================================================================<\/span>\r\nUpgrade  2 Packages\r\n\r\nTotal download size: 161 M\r\nDownloading packages:\r\n<span class=\"o\">(<\/span>1\/2<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-client.rpm                   |  49 MB  00:00:09\r\n<span class=\"o\">(<\/span>2\/2<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-server.rpm                   | 112 MB  00:00:20\r\n<span class=\"nt\">------------------------------------------------------------------------------------------<\/span>\r\nTotal                                                     8.0 MB\/s | 161 MB  00:00:20\r\nRunning transaction check\r\nRunning transaction <span class=\"nb\">test\r\n<\/span>Transaction <span class=\"nb\">test <\/span>succeeded\r\nRunning transaction\r\n  Updating   : MariaDB-client-10.2.30-1.el6.x86_64                                    1\/4\r\n\r\n<span class=\"k\">******************************************************************<\/span>\r\nA MySQL or MariaDB server package <span class=\"o\">(<\/span>MariaDB-server-10.1.43-1.el6.x86_64<span class=\"o\">)<\/span> is installed.\r\n\r\nUpgrading directly from MySQL 10.1 to MariaDB 10.2 may not\r\nbe safe <span class=\"k\">in <\/span>all cases.  A manual dump and restore using mysqldump is\r\nrecommended.  It is important to review the MariaDB manual<span class=\"s1\">'s Upgrading\r\nsection for version-specific incompatibilities.\r\n\r\nA manual upgrade is required.\r\n\r\n- Ensure that you have a complete, working backup of your data and my.cnf\r\n  files\r\n- Shut down the MySQL server cleanly\r\n- Remove the existing MySQL packages.  Usually this command will\r\n  list the packages you should remove:\r\n  rpm -qa | grep -i '<\/span>^mysql-<span class=\"s1\">'\r\n\r\n  You may choose to use '<\/span>rpm <span class=\"nt\">--nodeps<\/span> <span class=\"nt\">-ev<\/span> &lt;package-name&gt;<span class=\"s1\">' to remove\r\n  the package which contains the mysqlclient shared library.  The\r\n  library will be reinstalled by the MariaDB-shared package.\r\n- Install the new MariaDB packages supplied by MariaDB Foundation\r\n- Ensure that the MariaDB server is started\r\n- Run the '<\/span>mysql_upgrade<span class=\"s1\">' program\r\n\r\nThis is a brief description of the upgrade process.  Important details\r\ncan be found in the MariaDB manual, in the Upgrading section.\r\n******************************************************************\r\nerror: %pre(MariaDB-server-10.2.30-1.el6.x86_64) scriptlet failed, exit status 1\r\nError in PREIN scriptlet in rpm package MariaDB-server-10.2.30-1.el6.x86_64\r\nerror: MariaDB-server-10.2.30-1.el6.x86_64: install failed\r\nerror: MariaDB-server-10.1.43-1.el6.x86_64: erase skipped\r\n  Cleanup    : MariaDB-client-10.1.43-1.el6.x86_64                                    3\/4\r\n  Verifying  : MariaDB-client-10.2.30-1.el6.x86_64                                    1\/4\r\n  Verifying  : MariaDB-client-10.1.43-1.el6.x86_64                                    2\/4\r\n  Verifying  : MariaDB-server-10.2.30-1.el6.x86_64                                    3\/4\r\nMariaDB-server-10.1.43-1.el6.x86_64 was supposed to be removed but is not!\r\n  Verifying  : MariaDB-server-10.1.43-1.el6.x86_64                                    4\/4\r\n\r\nUpdated:\r\n  MariaDB-client.x86_64 0:10.2.30-1.el6\r\n\r\nFailed:\r\n  MariaDB-server.x86_64 0:10.1.43-1.el6       MariaDB-server.x86_64 0:10.2.30-1.el6\r\n\r\nComplete\r\n<\/span><\/code><\/pre>\n<p>\u88ab\u544a\u77e5\u8981\u624b\u52a8\u66f4\u65b0<\/p>\n<h2>\u624b\u52d5\u66f4\u65b0<\/p>\n<h3>1. \u5907\u4efd<\/p>\n<ul class=\"post-ul\">\u4e00\u5fdc\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068my.conf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u308a\u307e\u3059<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo cp<\/span> \/etc\/my.cnf \/etc\/my.cnf.org\r\n<\/code><\/pre>\n<h3>2. MariaDB\u505c\u6b62\u8fd0\u884c<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>service mysql stop\r\nShutting down MariaDB... SUCCESS!\r\n<\/code><\/pre>\n<h3>3. \u5220\u9664\u65e7\u7248\u7684MariaDB<\/p>\n<ul class=\"post-ul\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308bMariaDB\u3092\u78ba\u8a8d(\u4e0a\u3067update\u3092\u8a66\u884c\u3057\u3066\u3044\u308b\u306e\u3067\u3001client\u3060\u305110.2\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002)<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>yum list installed | <span class=\"nb\">grep <\/span>maria\r\nMariaDB-client.x86_64                10.2.30-1.el6                 @mariadb\r\nMariaDB-common.x86_64                10.1.43-1.el6                 @mariadb\r\nMariaDB-compat.x86_64                10.1.43-1.el6                 @mariadb\r\nMariaDB-server.x86_64                10.1.43-1.el6                 @mariadb\r\ngalera.x86_64                        25.3.28-1.rhel6.el6           @mariadb\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u4eca\u56de\u306f10.1\u304b\u308910.2\u306b\u3059\u308b\u306e\u3067\u3001MariaDB-common.x86_64\u3092\u6d88\u3059<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>yum remove MariaDB-common.x86_64\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u6d88\u3048\u305f\u304b\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>yum list installed | <span class=\"nb\">grep <\/span>maria\r\ngalera.x86_64                        25.3.28-1.rhel6.el6           @mariadb\r\n<\/code><\/pre>\n<p>\u7531\u4e8e\u4f9d\u5b58\u5173\u7cfb\uff0c\u6240\u6709\u76f8\u5173\u7684\u4e8b\u7269\u90fd\u88ab\u6e05\u9664\u4e86\uff0c\u6240\u4ee5MariaDB\u76f8\u5173\u90e8\u5206\u90fd\u6d88\u5931\u4e86\u3002<br \/>\n\u7ed3\u679c\u662f\uff0c\u7248\u672c10.1\u76f8\u5173\u7684\u4e5f\u90fd\u6d88\u5931\u4e86\u3002<\/p>\n<h3>4. \u5b89\u88c5\u65b0\u7684MariaDB<\/p>\n<pre class=\"post-pre\"><code>\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> MariaDB-server MariaDB-client\r\n<\/code><\/pre>\n<p>\u6267\u884c\u7ed3\u679c (sh\u00ed ji\u00e9 gu\u01d2)<\/p>\n<pre class=\"post-pre\"><code>Loaded plugins: priorities, update-motd, upgrade-helper\r\n89 packages excluded due to repository priority protections\r\nResolving Dependencies\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Running transaction check\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-client.x86_64 0:10.2.30-1.el6 will be installed\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Processing Dependency: MariaDB-common <span class=\"k\">for <\/span>package: MariaDB-client-10.2.30-1.el6.x86_64\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-server.x86_64 0:10.2.30-1.el6 will be installed\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Running transaction check\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-common.x86_64 0:10.2.30-1.el6 will be installed\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Processing Dependency: MariaDB-compat <span class=\"k\">for <\/span>package: MariaDB-common-10.2.30-1.el6.x86_64\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Running transaction check\r\n<span class=\"nt\">---<\/span><span class=\"o\">&gt;<\/span> Package MariaDB-compat.x86_64 0:10.2.30-1.el6 will be installed\r\n<span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n<span class=\"o\">==========================================================================================<\/span>\r\n Package                 Arch            Version                   Repository        Size\r\n<span class=\"o\">==========================================================================================<\/span>\r\nInstalling:\r\n MariaDB-client          x86_64          10.2.30-1.el6             mariadb           49 M\r\n MariaDB-server          x86_64          10.2.30-1.el6             mariadb          112 M\r\nInstalling <span class=\"k\">for <\/span>dependencies:\r\n MariaDB-common          x86_64          10.2.30-1.el6             mariadb          173 k\r\n MariaDB-compat          x86_64          10.2.30-1.el6             mariadb          4.0 M\r\n\r\nTransaction Summary\r\n<span class=\"o\">==========================================================================================<\/span>\r\nInstall  2 Packages <span class=\"o\">(<\/span>+2 Dependent packages<span class=\"o\">)<\/span>\r\n\r\nTotal download size: 166 M\r\nInstalled size: 699 M\r\nDownloading packages:\r\n<span class=\"o\">(<\/span>1\/4<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-common.rpm                   | 173 kB  00:00:01\r\n<span class=\"o\">(<\/span>2\/4<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-compat.rpm                   | 4.0 MB  00:00:01\r\n<span class=\"o\">(<\/span>3\/4<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-client.rpm                   |  49 MB  00:00:10\r\n<span class=\"o\">(<\/span>4\/4<span class=\"o\">)<\/span>: MariaDB-10.2.30-centos6-x86_64-server.rpm                   | 112 MB  00:00:13\r\n<span class=\"nt\">------------------------------------------------------------------------------------------<\/span>\r\nTotal                                                      10 MB\/s | 166 MB  00:00:16\r\nRunning transaction check\r\nRunning transaction <span class=\"nb\">test\r\n<\/span>Transaction <span class=\"nb\">test <\/span>succeeded\r\nRunning transaction\r\n  Installing : MariaDB-common-10.2.30-1.el6.x86_64                                    1\/4\r\n  Installing : MariaDB-compat-10.2.30-1.el6.x86_64                                    2\/4\r\n  Installing : MariaDB-client-10.2.30-1.el6.x86_64                                    3\/4\r\n  Installing : MariaDB-server-10.2.30-1.el6.x86_64                                    4\/4\r\n\/usr\/sbin\/semodule: SELinux policy is not managed or store cannot be accessed.\r\n  Verifying  : MariaDB-compat-10.2.30-1.el6.x86_64                                    1\/4\r\n  Verifying  : MariaDB-common-10.2.30-1.el6.x86_64                                    2\/4\r\n  Verifying  : MariaDB-server-10.2.30-1.el6.x86_64                                    3\/4\r\n  Verifying  : MariaDB-client-10.2.30-1.el6.x86_64                                    4\/4\r\n\r\nInstalled:\r\n  MariaDB-client.x86_64 0:10.2.30-1.el6       MariaDB-server.x86_64 0:10.2.30-1.el6\r\n\r\nDependency Installed:\r\n  MariaDB-common.x86_64 0:10.2.30-1.el6       MariaDB-compat.x86_64 0:10.2.30-1.el6\r\n\r\nComplete!\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u304b\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>yum list installed | <span class=\"nb\">grep <\/span>maria\r\nMariaDB-client.x86_64                10.2.30-1.el6                 @mariadb\r\nMariaDB-common.x86_64                10.2.30-1.el6                 @mariadb\r\nMariaDB-compat.x86_64                10.2.30-1.el6                 @mariadb\r\nMariaDB-server.x86_64                10.2.30-1.el6                 @mariadb\r\ngalera.x86_64                        25.3.28-1.rhel6.el6           @mariadb\r\n<\/code><\/pre>\n<p>\u6211\u786e\u8ba4\u4e86\u4ece10.1\u66f4\u6539\u81f310.2\u7684\u7248\u672c\u3002<\/p>\n<h3>\u5f00\u59cb<\/p>\n<ul class=\"post-ul\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u304a\u3044\u305fconf\u3092\u518d\u8a2d\u5b9a<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo mv<\/span> \/etc\/my.cnf.org \/etc\/my.cnf\r\n<\/code><\/pre>\n<ul class=\"post-ul\">MariaDB\u8d77\u52d5<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>service mysql start\r\n<\/code><\/pre>\n<h2>\u5982\u679c\u65e0\u6cd5\u767b\u5f55<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u5f8c\u306b\u30ed\u30b0\u30a4\u30f3\u306f\u304a\u308d\u304b\u3001mysql &#8211;version\u3082\u3067\u304d\u306a\u304f\u306a\u3063\u305f<\/ul>\n<\/li>\n<\/ul>\n<p>mysql.user\u30c6\u30fc\u30d6\u30eb\u304c\u521d\u671f\u5316\u3055\u308c\u305f\u3063\u307d\u3044(\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u6b8b\u3063\u3066\u308b\u306e\u306b\u3001\u3001)<\/p>\n<pre class=\"post-pre\"><code>ERROR 1045 <span class=\"o\">(<\/span>28000<span class=\"o\">)<\/span>: Access denied <span class=\"k\">for <\/span>user <span class=\"s1\">'username'<\/span>@<span class=\"s1\">'localhost'<\/span> <span class=\"o\">(<\/span>using password: NO<span class=\"o\">)<\/span>\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30bb\u30fc\u30d5\u30e2\u30fc\u30c9\u3067\u8d77\u52d5<\/ul>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>mysqld_safe <span class=\"nt\">--skip-grant-tables<\/span> &amp;\r\n<span class=\"nv\">$ <\/span>mysql <span class=\"nt\">-uroot<\/span>\r\n<\/code><\/pre>\n<p>\u767b\u5f55\u4e4b\u540e\uff0c\u53ef\u4ee5\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u7ed9\u4e88\u7528\u6237\u6743\u9650\u3002<\/p>\n<p>\u4fee\u6539\u5df2\u5b58\u5728\u7528\u6237\u7684\u5bc6\u7801<\/p>\n<pre class=\"post-pre\"><code>  <span class=\"o\">&gt;<\/span> <span class=\"k\">UPDATE<\/span> <span class=\"n\">mysql<\/span><span class=\"p\">.<\/span><span class=\"k\">user<\/span> <span class=\"k\">SET<\/span> <span class=\"n\">authentication_string<\/span> <span class=\"o\">=<\/span> <span class=\"n\">PASSWORD<\/span><span class=\"p\">(<\/span><span class=\"s1\">'your_password'<\/span><span class=\"p\">)<\/span> <span class=\"k\">WHERE<\/span> <span class=\"k\">User<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'your_username'<\/span> <span class=\"k\">AND<\/span> <span class=\"k\">Host<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'localhost'<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u521b\u5efa\u4e00\u4e2a\u5e26\u5bc6\u7801\u7684\u7528\u6237<\/p>\n<pre class=\"post-pre\"><code>  <span class=\"o\">&gt;<\/span> <span class=\"k\">grant<\/span> <span class=\"k\">all<\/span> <span class=\"k\">privileges<\/span> <span class=\"k\">on<\/span> <span class=\"o\">*<\/span><span class=\"p\">.<\/span><span class=\"o\">*<\/span> <span class=\"k\">to<\/span> <span class=\"n\">your_username<\/span><span class=\"o\">@<\/span><span class=\"n\">localhost<\/span> <span class=\"n\">identified<\/span> <span class=\"k\">by<\/span> <span class=\"s1\">'your_password'<\/span> <span class=\"k\">with<\/span> <span class=\"k\">grant<\/span> <span class=\"k\">option<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u65e0\u9700\u5bc6\u7801\u5373\u53ef\u521b\u5efa\u7528\u6237<\/p>\n<pre class=\"post-pre\"><code>  <span class=\"o\">&gt;<\/span> <span class=\"n\">flush<\/span> <span class=\"k\">privileges<\/span><span class=\"p\">;<\/span>\r\n  <span class=\"o\">&gt;<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">USER<\/span> <span class=\"n\">your_username<\/span><span class=\"o\">@<\/span><span class=\"n\">localhost<\/span>\r\n<\/code><\/pre>\n<ul class=\"post-ul\">MariaDB\u518d\u8d77\u52d5<\/ul>\n<pre class=\"post-pre\"><code>$ sudo service mysql restart\r\n<\/code><\/pre>\n<h1>\u8bf7\u63d0\u4f9b\u66f4\u591a\u7684\u4e0a\u4e0b\u6587\u4fe1\u606f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b80\u800c\u8a00\u4e4b\u8fd9\u662f\u5173\u4e8e\u5c06MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7684\u5907\u5fd8\u5f55\u3002 \u6211\u8bd5\u7740\u7528yum\u6765\u505a\u4e00\u4e0b\u3002 \u73fe\u5728\u306e\u8a2d\u5b9a\u3092\u78ba\u8a8d [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28453","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06amazonlinux\u4e0a\u7684mariadb\u4ece10-1\u5347\u7ea7\u523010-2\u7248\u672c\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06amazonlinux\u4e0a\u7684mariadb\u4ece10-1\u5347\u7ea7\u523010-2\u7248\u672c\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-17T22:23:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T00:16:50+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/\",\"name\":\"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-17T22:23:54+00:00\",\"dateModified\":\"2025-08-12T00:16:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"description\":\"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c - Blog - Silicon Cloud","description":"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0","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:\/\/www.silicloud.com\/zh\/blog\/\u5c06amazonlinux\u4e0a\u7684mariadb\u4ece10-1\u5347\u7ea7\u523010-2\u7248\u672c\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c","og_description":"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06amazonlinux\u4e0a\u7684mariadb\u4ece10-1\u5347\u7ea7\u523010-2\u7248\u672c\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-17T22:23:54+00:00","article_modified_time":"2025-08-12T00:16:50+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/","name":"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-17T22:23:54+00:00","dateModified":"2025-08-12T00:16:50+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"description":"\u5173\u4e8e\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c06AmazonLinux\u4e0a\u7684MariaDB\u4ece10.1\u5347\u7ea7\u523010.2\u7248\u672c"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86amazonlinux%e4%b8%8a%e7%9a%84mariadb%e4%bb%8e10-1%e5%8d%87%e7%ba%a7%e5%88%b010-2%e7%89%88%e6%9c%ac%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28453"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28453\/revisions"}],"predecessor-version":[{"id":111332,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28453\/revisions\/111332"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}