{"id":3704,"date":"2025-03-26T23:00:00","date_gmt":"2025-03-26T14:00:00","guid":{"rendered":"https:\/\/jikoman.sin-cos.com\/blog\/?p=3704"},"modified":"2025-03-26T23:00:00","modified_gmt":"2025-03-26T14:00:00","slug":"vps-15","status":"publish","type":"post","link":"https:\/\/jikoman.sin-cos.com\/blog\/2025\/03\/vps-15\/","title":{"rendered":"VPS\u3067AlmaLinux (15) MariaDB\u306e\u69cb\u7bc9"},"content":{"rendered":"\n<p><a href=\"\/blog\/2025\/03\/vps-14\/\" data-type=\"post\" data-id=\"3426\">\u524d\u56de<\/a>\u306f\u3001Web\u30b5\u30fc\u30d0\u306eSSL\u5316\u3092\u884c\u3063\u305f\u3002<br>\u4eca\u56de\u306f\u3001MariaDB\u306e\u69cb\u7bc9\u3092\u884c\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n\n\n\n<p>MariaDB\u306f\u3001MySQL\u5f8c\u7d99\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u3001MariaDB\u306e\u516c\u5f0f\u30b5\u30a4\u30c8(<a href=\"https:\/\/mariadb.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/mariadb.org\/<\/a>)\u3078\u884c\u304d\u3001\u300cDownload\u300d\u3092\u9078\u629e\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"404\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-71-1024x404.png\" alt=\"\" class=\"wp-image-3710\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-71-1024x404.png 1024w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-71-300x118.png 300w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-71-768x303.png 768w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-71.png 1098w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u300cthe latest&nbsp;<strong>long-term release<\/strong>&nbsp;is&nbsp;MariaDB 11.4, which is&nbsp;maintained for five years.\u300d<\/p>\n\n\n\n<p>\u73fe\u6642\u70b9\u3067\u306e\u9577\u671f\u4fdd\u5b88\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u300111.4\u3068\u306e\u3053\u3068\u306a\u306e\u3067\u3001\u300cMariaDB Server Repositories\u300d\u30bf\u30d6\u3067\u3001\u6b21\u3092\u9078\u629e\u3002<\/p>\n\n\n\n<!--more-->\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose a distribution\u300cRed Hat Enterprise Linux 9\u300d<\/li>\n\n\n\n<li>Choose a MariaDB Server vertson\u300c11.4\u300d<\/li>\n\n\n\n<li>Mirror\uff08\u9069\u5f53\uff09<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"723\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-73.png\" alt=\"\" class=\"wp-image-3712\" srcset=\"https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-73.png 739w, https:\/\/jikoman.sin-cos.com\/blog\/wp-content\/uploads\/2025\/03\/image-73-300x294.png 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/figure>\n\n\n\n<p>\u307e\u305a\u306f\u3001\u30ec\u30dd\u30b8\u30c8\u30ea\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/yum.repos.d\/MariaDB.repo<\/pre>\n\n\n\n<p>\u4e2d\u8eab\u306f\u3001\u30b5\u30a4\u30c8\u306b\u8868\u793a\u3055\u308c\u305f\u3082\u306e\u3092\u30b3\u30d4\u30da\u3059\u308c\u3070\u826f\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># MariaDB 11.4 RedHatEnterpriseLinux repository list - created 2025-03-23 07:28 UTC<br># https:\/\/mariadb.org\/download\/<br>[mariadb]<br>name = MariaDB<br># rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https:\/\/mariadb.org\/mirrorbits\/ for details.<br># baseurl = https:\/\/rpm.mariadb.org\/11.4\/rhel\/$releasever\/$basearch<br>baseurl = https:\/\/ftp.yz.yamagata-u.ac.jp\/pub\/dbms\/mariadb\/yum\/11.4\/rhel\/$releasever\/$basearch<br># gpgkey = https:\/\/rpm.mariadb.org\/RPM-GPG-KEY-MariaDB<br>gpgkey = https:\/\/ftp.yz.yamagata-u.ac.jp\/pub\/dbms\/mariadb\/yum\/RPM-GPG-KEY-MariaDB<br>gpgcheck = 1<\/pre>\n\n\n\n<p>\u305d\u3057\u3066\u3001\u307e\u305f\u30b5\u30a4\u30c8\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo dnf -y install MariaDB-server<br>\u3000\uff1a<br>Installed:<br>  MariaDB-client-11.4.5-1.el9.x86_64                     MariaDB-common-11.4.5-1.el9.x86_64                    MariaDB-server-11.4.5-1.el9.x86_64                <br>  MariaDB-shared-11.4.5-1.el9.x86_64                     boost-program-options-1.75.0-8.el9.x86_64             galera-4-26.4.21-1.el9.x86_64                     <br>  lsof-4.94.0-3.el9.x86_64                               perl-AutoLoader-5.74-481.el9.noarch                   perl-B-1.80-481.el9.x86_64                        <br>  perl-Carp-1.50-460.el9.noarch                          perl-Class-Struct-0.66-481.el9.noarch                 perl-DBI-1.643-9.el9.x86_64                       <br>  perl-Data-Dumper-2.174-462.el9.x86_64                  perl-Digest-1.19-4.el9.noarch                         perl-Digest-MD5-2.58-4.el9.x86_64                 <br>  perl-DynaLoader-1.47-481.el9.x86_64                    perl-Encode-4:3.08-462.el9.x86_64                     perl-Errno-1.30-481.el9.x86_64                    <br>  perl-Exporter-5.74-461.el9.noarch                      perl-Fcntl-1.13-481.el9.x86_64                        perl-File-Basename-2.85-481.el9.noarch            <br>  perl-File-Copy-2.34-481.el9.noarch                     perl-File-Path-2.18-4.el9.noarch                      perl-File-Temp-1:0.231.100-4.el9.noarch           <br>  perl-File-stat-1.09-481.el9.noarch                     perl-FileHandle-2.03-481.el9.noarch                   perl-Getopt-Long-1:2.52-4.el9.noarch              <br>  perl-Getopt-Std-1.12-481.el9.noarch                    perl-HTTP-Tiny-0.076-462.el9.noarch                   perl-IO-1.43-481.el9.x86_64                       <br>  perl-IO-Socket-IP-0.41-5.el9.noarch                    perl-IO-Socket-SSL-2.073-2.el9.noarch                 perl-IPC-Open3-1.21-481.el9.noarch                <br>  perl-MIME-Base64-3.16-4.el9.x86_64                     perl-Math-BigInt-1:1.9998.18-460.el9.noarch           perl-Math-Complex-1.59-481.el9.noarch             <br>  perl-Mozilla-CA-20200520-6.el9.noarch                  perl-NDBM_File-1.15-481.el9.x86_64                    perl-Net-SSLeay-1.94-1.el9.x86_64                 <br>  perl-POSIX-1.94-481.el9.x86_64                         perl-PathTools-3.78-461.el9.x86_64                    perl-Pod-Escapes-1:1.07-460.el9.noarch            <br>  perl-Pod-Perldoc-3.28.01-461.el9.noarch                perl-Pod-Simple-1:3.42-4.el9.noarch                   perl-Pod-Usage-4:2.01-4.el9.noarch                <br>  perl-Scalar-List-Utils-4:1.56-462.el9.x86_64           perl-SelectSaver-1.02-481.el9.noarch                  perl-Socket-4:2.031-4.el9.x86_64                  <br>  perl-Storable-1:3.21-460.el9.x86_64                    perl-Symbol-1.08-481.el9.noarch                       perl-Sys-Hostname-1.23-481.el9.x86_64             <br>  perl-Term-ANSIColor-5.01-461.el9.noarch                perl-Term-Cap-1.17-460.el9.noarch                     perl-Text-ParseWords-3.30-460.el9.noarch          <br>  perl-Text-Tabs+Wrap-2013.0523-460.el9.noarch           perl-Time-Local-2:1.300-7.el9.noarch                  perl-URI-5.09-3.el9.noarch                        <br>  perl-base-2.27-481.el9.noarch                          perl-constant-1.33-461.el9.noarch                     perl-if-0.60.800-481.el9.noarch                   <br>  perl-interpreter-4:5.32.1-481.el9.x86_64               perl-libnet-3.13-4.el9.noarch                         perl-libs-4:5.32.1-481.el9.x86_64                 <br>  perl-mro-1.23-481.el9.x86_64                           perl-overload-1.31-481.el9.noarch                     perl-overloading-0.02-481.el9.noarch              <br>  perl-parent-1:0.238-460.el9.noarch                     perl-podlators-1:4.14-460.el9.noarch                  perl-subs-1.03-481.el9.noarch                     <br>  perl-vars-1.05-481.el9.noarch                          pv-1.6.20-1.el9.x86_64                                socat-1.7.4.1-6.el9.x86_64                        <br><br>Complete!<\/pre>\n\n\n\n<p>\u30b5\u30fc\u30d0\u30fc\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u81ea\u52d5\u8d77\u52d5\u306b\u8a2d\u5b9a\u3057\u3001\u540c\u6642\u306b\u8d77\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl enable --now mariadb.service<br>Created symlink \/etc\/systemd\/system\/multi-user.target.wants\/mariadb.service \u2192 \/usr\/lib\/systemd\/system\/mariadb.service.<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u78ba\u8a8d\u3068\u8a2d\u5b9a<\/h3>\n\n\n\n<p>\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u78ba\u8a8d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mariadb --version<br>mariadb from 11.4.5-MariaDB, client 15.2 for Linux (x86_64) using  EditLine wrapper<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c<\/h3>\n\n\n\n<p>\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u9ad8\u3081\u308b\u305f\u3081\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo \/usr\/bin\/mariadb-secure-installation<br><br>NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB<br>      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!<br><br>In order to log into MariaDB to secure it, we'll need the current<br>password for the root user. If you've just installed MariaDB, and<br>haven't set the root password yet, you should just press enter here.<br><br>Enter current password for root (enter for none): <br>OK, successfully used password, moving on...<br><br>Setting the root password or using the unix_socket ensures that nobody<br>can log into the MariaDB root user without the proper authorisation.<br><br>You already have your root account protected, so you can safely answer 'n'.<br><br>Switch to unix_socket authentication [Y\/n] <br>Enabled successfully!<br>Reloading privilege tables..<br> ... Success!<br><br><br>You already have your root account protected, so you can safely answer 'n'.<br><br>Change the root password? [Y\/n] n<br> ... skipping.<br><br>By default, a MariaDB installation has an anonymous user, allowing anyone<br>to log into MariaDB without having to have a user account created for<br>them.  This is intended only for testing, and to make the installation<br>go a bit smoother.  You should remove them before moving into a<br>production environment.<br><br>Remove anonymous users? [Y\/n] <br> ... Success!<br><br>Normally, root should only be allowed to connect from 'localhost'.  This<br>ensures that someone cannot guess at the root password from the network.<br><br>Disallow root login remotely? [Y\/n] <br> ... Success!<br><br>By default, MariaDB comes with a database named 'test' that anyone can<br>access.  This is also intended only for testing, and should be removed<br>before moving into a production environment.<br><br>Remove test database and access to it? [Y\/n] <br> - Dropping test database...<br> ... Success!<br> - Removing privileges on test database...<br> ... Success!<br><br>Reloading the privilege tables will ensure that all changes made so far<br>will take effect immediately.<br><br>Reload privilege tables now? [Y\/n] <br> ... Success!<br><br>Cleaning up...<br><br>All done!  If you've completed all of the above steps, your MariaDB<br>installation should now be secure.<br><br>Thanks for using MariaDB!<\/pre>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u3001\u30bb\u30ad\u30e5\u30a2\u306b\u306a\u3063\u305f\u3002<\/p>\n\n\n\n<p>root\u3067mariadb\u3092\u5b9f\u884c\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u6a29\u9650\u306e\u78ba\u8a8d\u3092\u884c\u3046\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo mariadb<br>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br>Your MariaDB connection id is 12<br>Server version: 11.4.5-MariaDB MariaDB Server<br><br>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br><br>Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<br><br>MariaDB [(none)]&gt; show grants for root@localhost;<br>+-----------------------------------------------------------------------------------------------------------------------------------------+<br>| Grants for root@localhost                                                                                                               |<br>+-----------------------------------------------------------------------------------------------------------------------------------------+<br>| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING <strong>'invalid' OR unix_socket<\/strong> WITH GRANT OPTION |<br>| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |<br>+-----------------------------------------------------------------------------------------------------------------------------------------+<br>2 rows in set (0.001 sec)<\/pre>\n\n\n\n<p>\u300c&#8217;invalid&#8217; OR unix_socket\u300d\u3068\u306e\u3053\u3068\u3067\u3001UNIX\u30e6\u30fc\u30b6\u30fc\u8a8d\u8a3c\u306e\u307f\u3067\u63a5\u7d9a\u53ef\u80fd\u3002<\/p>\n\n\n\n<p>\u4ed6\u306e\u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u6b21\u306eSQL\u3067\u30e6\u30fc\u30b6\u30fc\u3092\u8ffd\u52a0\u3057\u3066\u53cd\u6620\u3055\u305b\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MariaDB [(none)]&gt; CREATE USER \"nori\"@\"localhost\";<br>Query OK, 0 rows affected (0.012 sec)<br><br>MariaDB [(none)]&gt; flush privileges;<br>Query OK, 0 rows affected (0.001 sec)<\/pre>\n\n\n\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u3067\u306f\u306a\u304f\u3001UNIX\u30e6\u30fc\u30b6\u30fc\u3067\u306e\u8a8d\u8a3c\u306e\u305f\u3081\u3001\u540c\u3058\u30e6\u30fc\u30b6\u30fc\u540d\u3067\u3042\u308c\u3070DB\u306b\u63a5\u7d9a\u53ef\u80fd\u3002<\/p>\n\n\n\n<p>\u73fe\u6642\u70b9\u3067\u306e\u30e6\u30fc\u30b6\u30fc\u60c5\u5831\u3092\u77e5\u308a\u305f\u3044\u5834\u5408\u306f\u3001\u6b21\u306eSQL\u3067\u78ba\u8a8d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MariaDB [(none)]&gt; select * FROM mysql.global_priv;<br>+-----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| Host      | User        | Priv                                                                                                                                                                                     |<br>+-----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>| localhost | mariadb.sys | {\"access\":0,\"plugin\":\"mysql_native_password\",\"authentication_string\":\"\",\"account_locked\":true,\"password_last_changed\":0}                                                                 |<br>| localhost | root        | {\"access\": 10000000000000000000, \"plugin\": \"mysql_native_password\", \"authentication_string\": \"invalid\", \"auth_or\": [{}, {\"plugin\": \"unix_socket\"}], \"password_last_changed\": 1111111111} |<br>| localhost | mysql       | {\"access\":10000000000000000000,\"plugin\":\"mysql_native_password\",\"authentication_string\":\"invalid\",\"auth_or\":[{},{\"plugin\":\"unix_socket\"}]}                                               |<br>|           | PUBLIC      | {\"access\":0,\"is_role\":true}                                                                                                                                                              |<br>| localhost | nori        | {\"access\":0,\"version_id\":110405,\"plugin\":\"mysql_native_password\",\"authentication_string\":\"*XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\",\"password_last_changed\":1111111111}                 |<br>+-----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>5 rows in set (0.001 sec)<br><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u5909\u66f4<\/h3>\n\n\n\n<p>\u6b21\u306b\u3001\u6587\u5b57\u30b3\u30fc\u30c9\u3092\uff14\u30d0\u30a4\u30c8\u306eUTF-8\u3001\u3064\u307e\u308autf8mb4\u306b\u5909\u66f4\u3057\u305f\u3044\u3002<\/p>\n\n\n\n<p>\u30d8\u30eb\u30d7\u306b\u3088\u308b\u3068\u3001\u300c<code>utf8(utf8mb3) \u3068\u3044\u3046\u540d\u524d\u306e\u6587\u5b57\u30bb\u30c3\u30c8\u306f\u3001\u6587\u5b57\u3042\u305f\u308a\u6700\u5927 3 \u30d0\u30a4\u30c8\u3092\u4f7f\u7528\u3057\u3001BMP \u6587\u5b57\u3060\u3051\u3092\u542b\u307f\u307e\u3059\u3002utf8mb4 \u6587\u5b57\u30bb\u30c3\u30c8\u306f\u3001\u6587\u5b57\u3054\u3068\u306b\u6700\u5927 4 \u30d0\u30a4\u30c8\u3092\u4f7f\u7528\u3057\u3001\u88dc\u52a9\u6587\u5b57\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/code>\u300d\u3068\u306e\u3053\u3068\u3067\u3001\u88dc\u52a9\u6587\u5b57\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u306b\u306f\u3001utf8mb4\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u3001\u73fe\u72b6\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u53c2\u7167\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo mariadb<br>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br>Your MariaDB connection id is 12<br>Server version: 11.4.5-MariaDB MariaDB Server<br><br>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br><br>Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<br><br>MariaDB [(none)]&gt; show variables like \"character%\";<br>+--------------------------+------------------------------+<br>| Variable_name            | Value                        |<br>+--------------------------+------------------------------+<br>| character_set_client     | utf8mb3                      |<br>| character_set_collations |                              |<br>| character_set_connection | utf8mb3                      |<br>| character_set_database   | latin1                       |<br>| character_set_filesystem | binary                       |<br>| character_set_results    | utf8mb3                      |<br>| character_set_server     | latin1                       |<br>| character_set_system     | utf8mb3                      |<br>| character_sets_dir       | \/usr\/share\/mariadb\/charsets\/ |<br>+--------------------------+------------------------------+<br>9 rows in set (0.001 sec)<br><br>MariaDB [(none)]&gt; show variables like \"collation%\";<br>+----------------------+--------------------+<br>| Variable_name        | Value              |<br>+----------------------+--------------------+<br>| collation_connection | utf8mb3_general_ci |<br>| collation_database   | latin1_swedish_ci  |<br>| collation_server     | latin1_swedish_ci  |<br>+----------------------+--------------------+<br>3 rows in set (0.001 sec)<br><br>MariaDB [(none)]&gt; quit<br>Bye<\/pre>\n\n\n\n<p>\u30b5\u30fc\u30d0\u30fc\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u66f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/my.cnf.d\/server.cnf<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"># This group is read by both MariaDB and MySQL servers<br>[mysqld]<br>character-set-server=utf8mb4\u3000\u2190\u8ffd\u52a0<br>collation-server=utf8mb4_general_ci\u3000\u2190\u8ffd\u52a0<\/pre>\n\n\n\n<p>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306e\u8a2d\u5b9a\u3082\u5909\u66f4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/my.cnf.d\/mysql-clients.cnf<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">[mysql]<br>default-character-set=utf8mb4\u3000\u2190\u8ffd\u52a0<br><br>[mysqldump]<br>default-character-set=utf8mb4\u3000\u2190\u8ffd\u52a0<\/pre>\n\n\n\n<p>MariaDB\u3092\u518d\u8d77\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mariadb<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u51fa\u529b<\/h3>\n\n\n\n<p>\u5909\u66f4\u5f8c\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u78ba\u8a8d\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo mariadb<br>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br>Your MariaDB connection id is 3<br>Server version: 11.4.5-MariaDB MariaDB Server<br><br>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br><br>Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<br><br>MariaDB [(none)]&gt; show variables like \"character%\";<br>+--------------------------+------------------------------+<br>| Variable_name            | Value                        |<br>+--------------------------+------------------------------+<br>| character_set_client     | utf8mb4                      |<br>| character_set_collations |                              |<br>| character_set_connection | utf8mb4                      |<br>| character_set_database   | utf8mb4                      |<br>| character_set_filesystem | binary                       |<br>| character_set_results    | utf8mb4                      |<br>| character_set_server     | utf8mb4                      |<br>| character_set_system     | utf8mb3                      |<br>| character_sets_dir       | \/usr\/share\/mariadb\/charsets\/ |<br>+--------------------------+------------------------------+<br>9 rows in set (0.001 sec)<br><br>MariaDB [(none)]&gt; show variables like \"collation%\";<br>+----------------------+--------------------+<br>| Variable_name        | Value              |<br>+----------------------+--------------------+<br>| collation_connection | utf8mb4_general_ci |<br>| collation_database   | utf8mb4_general_ci |<br>| collation_server     | utf8mb4_general_ci |<br>+----------------------+--------------------+<br>3 rows in set (0.001 sec)<br><br>MariaDB [(none)]&gt; quit<br>Bye<\/pre>\n\n\n\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30ed\u30b0\u304c\u51fa\u529b\u3055\u308c\u306a\u3044\u3002\u30a8\u30e9\u30fc\u30ed\u30b0\u3060\u3051\u51fa\u3057\u3066\u304a\u304f\u305f\u3081\u306b\u3001\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306b\u8a2d\u5b9a\u3092\u8ffd\u52a0\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo vi \/etc\/my.cnf.d\/server.cnf<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">[mysqld]<br>log_error=\/var\/log\/mysql\/error.log<br>log_output = FILE<br>log_warnings = 1<br>long_query_time = 3<br>slow_query_log = 1<br>slow_query_log_file = \/var\/log\/mysql\/slow.log<\/pre>\n\n\n\n<p>MariaDB\u3092\u518d\u8d77\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mariadb<\/pre>\n\n\n\n<p>\u4ee5\u4e0a\u3067\u521d\u671f\u8a2d\u5b9a\u306f\u5b8c\u4e86\uff01<\/p>\n\n\n\n<p><a href=\"\/blog\/2025\/03\/vps-16\">\u6b21\u56de<\/a>\u306f\u3001phpMyAdmin\u3092\u5c0e\u5165\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u304a\u53cb\u9054\u7d39\u4ecb\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5229\u7528\u3057\u3066\u5951\u7d04\u3059\u308b\u306810%OFF\u306b\u306a\u308b\u305d\u3046\u306a\u306e\u3067\u3001<br>\u3082\u3057\u3088\u308d\u3057\u3051\u308c\u3070\u6b21\u306e\u753b\u50cf\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/vps.xserver.ne.jp\/?referral_token=64605993567cf006eae78d\" target=\"_blank\" rel=\" noreferrer noopener\"><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/2025\/03\/image-36-1.png\" alt=\"\" class=\"wp-image-3494\"\/><\/a><\/figure>\n\n\n\n<p>\u6295\u7a3f\u4e00\u89a7\u306f\u3053\u3061\u3089\u2192\u300c<a href=\"\/blog\/vps\/\" data-type=\"page\" data-id=\"3450\">VPS\u3067AlmaLinux<\/a>\u300d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin\u306e\u5c0e\u5165<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129],"tags":[9,43,50],"class_list":["post-3704","post","type-post","status-publish","format-standard","hentry","category-pc","tag-almalinux","tag-vps","tag-xserver"],"_links":{"self":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/3704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/comments?post=3704"}],"version-history":[{"count":0,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/posts\/3704\/revisions"}],"wp:attachment":[{"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/media?parent=3704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/categories?post=3704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jikoman.sin-cos.com\/blog\/wp-json\/wp\/v2\/tags?post=3704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}