{"id":28626,"date":"2023-07-01T21:52:38","date_gmt":"2023-09-23T08:14:21","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos7%e4%b8%8a%e6%90%ad%e5%bb%bamariadb%e7%9a%84%e6%96%b9%e6%b3%95\/"},"modified":"2025-08-12T09:13:35","modified_gmt":"2025-08-12T01:13:35","slug":"%e5%9c%a8centos7%e4%b8%8a%e6%90%ad%e5%bb%bamariadb%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos7%e4%b8%8a%e6%90%ad%e5%bb%bamariadb%e7%9a%84%e6%96%b9%e6%b3%95\/","title":{"rendered":"\u5728CentOS7\u4e0a\u642d\u5efaMariaDB\u7684\u65b9\u6cd5"},"content":{"rendered":"

\u5b89\u88c5<\/h2>\n

fastermirror\u5c0e\u5165<\/p>\n

terminal
\nyum -y install yum-fastestmirror<\/p>\n

\u3059\u3067\u306b\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u5165\u3063\u3066\u3044\u308b(\u304b\u3082\u3057\u308c\u306a\u3044)\u306e\u3067\u3001\u4e00\u65e6\u524a\u9664\u3059\u308b<\/p>\n

terminal
\nyum -y remove mariadb*<\/p>\n

GPG\u30ad\u30fc\u53d6\u5f97 & yum\u30ec\u30dd\u30b8\u30c8\u30ea\u3092\u8ffd\u52a0<\/p>\n

terminal
\nrpm –import https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/p>\n

cat << \\EOS > \/etc\/yum.repos.d\/mariadb.repo
\n[mariadb]
\nname=MariaDB
\nbaseurl=http:\/\/yum.mariadb.org\/10.1\/centos7-amd64
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\nenabled=0
\nEOS<\/p>\n

MariaDB\u30b5\u30fc\u30d0\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n

terminal
\nyum -y install mariadb-server –enablerepo=mariadb<\/p>\n

\u8bbe\u7f6e\u548c\u542f\u52a8<\/h2>\n

cnf\u30d5\u30a1\u30a4\u30eb\u3092\u914d\u7f6e<\/p>\n

terminal
\ncat << \\EOS > \/etc\/my.cnf.d\/local.cnf
\n[mysqld]<\/p>\n

# \u6587\u5b57\u30b3\u30fc\u30c9\u8a2d\u5b9a
\ncharacter-set-server=utf8mb4
\nskip-character-set-client-handshake<\/p>\n

# \u30ea\u30f3\u30af\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u3092\u8a31\u5bb9\u3059\u308b
\nsymbolic-links=0<\/p>\n

# \u30e1\u30e2\u30ea\u30b5\u30a4\u30ba\u62e1\u5f35
\nmax_allowed_packet=128MB<\/p>\n

# \u30c6\u30fc\u30d6\u30eb\u3001\u30ab\u30e9\u30e0\u540d\u3092\u5c0f\u6587\u5b57\u306b\u7d71\u4e00
\nlower_case_table_names=1<\/p>\n

# InnoDB\u8a2d\u5b9a
\ninnodb_buffer_pool_size = 512M<\/p>\n

# index\u30b5\u30a4\u30ba\u62e1\u5f35\u5bfe\u5fdc
\ninnodb_large_prefix=1
\ninnodb_file_per_table=1
\ninnodb_file_format=Barracuda
\ninnodb_file_format_max=Barracuda
\nEOS<\/p>\n

\u30b5\u30fc\u30d3\u30b9\u3092\u8d77\u52d5<\/p>\n

terminal
\nservice mariadb start<\/p>\n

\u6700\u521d\u7684\u8bbe\u5b9a<\/h2>\n

mysql_secure_installation\u3092\u4f7f\u3046\u3068\u3001\u4e0b\u8a18\u306e\u5185\u5bb9\u3092\u5bfe\u8a71\u5f62\u5f0f\u3067\u8a2d\u5b9a\u3067\u304d\u308b\u3002<\/p>\n

\u73fe\u5728\u306eroot\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u78ba\u8a8d(\u521d\u671f\u306f\u7a7a\u6587\u5b57)
\n\u65b0\u3057\u3044root\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a
\nroot\u3078\u306e\u30ea\u30e2\u30fc\u30c8\u30ed\u30b0\u30a4\u30f3\u8a2d\u5b9a
\nanonymous\u30e6\u30fc\u30b6\u30fc\u306e\u524a\u9664
\ntest\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u524a\u9664
\n\u4e0a\u8a18\u8a2d\u5b9a\u5909\u66f4\u306e\u53cd\u6620<\/p>\n

\u5b89\u5168\u8bbe\u7f6e<\/h3>\n

mysql_secure_installation\u3092\u4f7f\u3046\u5834\u5408\u3002<\/p>\n

terminal
\nmysql_secure_installation<\/p>\n

\u540c\u7b49\u306e\u3053\u3068\u3092\u3001Chef\/Ansible\u306a\u3069\u3067\u3084\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u3092\u53c2\u8003\u306b\u3002\u3002\u3002<\/p>\n

terminal
\nmysql -u root -p << \\EOS
\n\/* root\u30e6\u30fc\u30b6\u30fc\u4f5c\u6210 & \u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a *\/
\nGRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘[password]’ WITH GRANT OPTION;
\nGRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘[password]’ WITH GRANT OPTION;
\n\/* anonymas\u30e6\u30fc\u30b6\u30fc\u524a\u9664 *\/
\nDELETE FROM mysql.user WHERE User = ”;
\n\/* test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664 *\/
\nDROP DATABASE IF EXISTS test;
\n\/* \u6a29\u9650\u53cd\u6620 *\/
\nFLUSH PRIVILEGES;
\nEOS<\/p>\n

\u7ed3\u675f\u4e86<\/h2>\n