\u5728\u5b98\u7f51\u4e0a\u4e0b\u8f7d\u5305\u4ee5\u540e\u89e3\u538b\u7136\u540e\u5b89\u88c5\u4f9d\u8d56\u5305
\nyum -y install gcc gcc-c++ gcc-g77 kernel-devel autoconf automake make cmake perl ncurses-devel libmcrypt* libtool-ltdl-devel* readline-devel pcre-devel openssl-devel openssl
\n\u6211\u590d\u5236\u4e86\u4e00\u4e2a5.7\u7684my.cnf\u6587\u4ef6\uff0c\u5728\u6267\u884c\u5982\u4e0b\u5b89\u88c5\u7684\u65f6\u5019\u62a5\u4e86\u4ee5\u4e0b\u7684\u9519\uff1a<\/p>\n
.\/mysqld \u2013defaults-file=\/u01\/my3306\/my.cnf \u2013initialize \u2013user=mysql \u2013basedir=\/u01\/mysql8.0 \u2013datadir=\/u01\/my3306\/data\/<\/p>\n
\u9ed8\u8ba4\u53d6\u6d88\u4e86query_cache\u76f8\u5173\u7684\u53c2\u6570\u3002
\n[ERROR] unknown variable \u2018innodb_file_format=Barracuda\u2019
\n[ERROR] unknown variable \u2018log_warnings=1\u2019
\n[ERROR] unknown variable \u2018query_cache_limit=1M\u2019
\n[ERROR] unknown variable \u2018query_cache_type=0\u2019
\n[ERROR] unknown variable \u2018show_compatibility_56=on\u2019<\/p>\n
\u548c5.7\u4e00\u6837\u7684 \u5b89\u88c5\u6210\u529f\u4ee5\u540e\u4e5f\u662f\u5728alert.log\u91cc\u751f\u4ea7\u95ee\u9898
\n2017-11-06T08:11:35.865054Z 5 [Note] A temporary password is generated for root@localhost: \/8Kk-gIhJF+H<\/p>\n
\u4f46\u662f\u5728\u8d77\u52a8\u7684\u65f6\u5019\u53c8\u62a5\u9519\u4e86\u3002
\n\u6709\u4e9b\u53c2\u6570\u662f\u5728\u5b89\u88c5\u7684\u65f6\u5019\u53bb\u68c0\u67e5 \u6709\u4e9b\u53c2\u6570\u5219\u662f\u5728\u8d77\u52a8\u7684\u65f6\u5019\u624d\u4f1a\u53bb\u68c0\u67e5
\n2017-11-06 16:15:38 32381 [ERROR] \/usr\/sbin\/mysqld: unknown variable \u2018slave-parallel-type=LOGICAL_CLOCK\u2019<\/p>\n
\u53ef\u4ee5\u770b\u51fa\u6765\u4e86\u591a\u4e86\u5f88\u591asdi\u7684\u6587\u4ef6 \u8fd8\u6709tablespaces \u8fd8\u6709undo
\n$ls
\nauto.cnf ibdata1 ib_logfile0 ib_logfile2 ibtmp1 mysql_1.sdi performance_sche_3.sdi sys tablespaces.open.1 test undo_001
\nib_buffer_pool ibdata2 ib_logfile1 ib_logfile3 mysql mysql.ibd performance_schema sys_4.sdi tablespaces.open.2 test_5.sdi undo_002
\n\u6253\u5f00\u4e00\u4e2asdi\u67e5\u770b\u53ef\u4ee5\u770b\u51fa\u6765\u662fjson\u7684\u63cf\u8ff0\u6587\u4ef6
\n$cat test_5.sdi
\n{
\n\u201cmysqld_version_id\u201d: 80003,
\n\u201cdd_version\u201d: 1,
\n\u201csdi_version\u201d: 1,
\n\u201cdd_object_type\u201d: \u201cSchema\u201d,
\n\u201cdd_object\u201d: {
\n\u201cname\u201d: \u201ctest\u201d,
\n\u201cdefault_collation_id\u201d: 255,
\n\u201ccreated\u201d: 0,
\n\u201clast_altered\u201d: 0
\n}<\/p>\n
\u8fdb\u5230mysql\u7684\u6587\u4ef6\u91cc \u53ef\u4ee5\u770b\u51fa\u6765\u548c\u4ee5\u524d\u7684\u5b8c\u5168\u4e0d\u4e00\u6837<\/p>\n
$ls
\ngeneral_log_195.sdi general_log.CSM general_log.CSV slow_log_196.sdi slow_log.CSM slow_log.CSV<\/p>\n
5.7\u7248\u672c\u5982\u4e0b\uff1a
\n[12-MySQL-Inst@db106 \/u01\/my3313\/data\/mysql]
\n$ls
\ncolumns_priv.frm event.MYI help_keyword.frm ndb_binlog_index.MYD proxies_priv.MYD slave_worker_info.ibd time_zone_name.frm
\ncolumns_priv.MYD func.frm help_keyword.ibd ndb_binlog_index.MYI proxies_priv.MYI slow_log.CSM time_zone_name.ibd
\ncolumns_priv.MYI func.MYD help_relation.frm plugin.frm server_cost.frm slow_log.CSV time_zone_transition.frm
\ndb.frm func.MYI help_relation.ibd plugin.ibd server_cost.ibd slow_log.frm time_zone_transition.ibd
\ndb.MYD general_log.CSM help_topic.frm proc.frm servers.frm tables_priv.frm time_zone_transition_type.frm
\ndb.MYI general_log.CSV help_topic.ibd proc.MYD servers.ibd tables_priv.MYD time_zone_transition_type.ibd
\ndb.opt general_log.frm innodb_index_stats.frm proc.MYI slave_master_info.frm tables_priv.MYI user.frm
\nengine_cost.frm gtid_executed.frm innodb_index_stats.ibd procs_priv.frm slave_master_info.ibd time_zone.frm user.MYD
\nengine_cost.ibd gtid_executed.ibd innodb_table_stats.frm procs_priv.MYD slave_relay_log_info.frm time_zone.ibd user.MYI
\nevent.frm help_category.frm innodb_table_stats.ibd procs_priv.MYI slave_relay_log_info.ibd time_zone_leap_second.frm
\nevent.MYD help_category.ibd ndb_binlog_index.frm proxies_priv.frm slave_worker_info.frm time_zone_leap_second.ibd<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u5b98\u7f51\u4e0a\u4e0b\u8f7d\u5305\u4ee5\u540e\u89e3\u538b\u7136\u540e\u5b89\u88c5\u4f9d\u8d56\u5305 yum -y install gcc gcc-c++ gcc-g77 k […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-1370","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1370"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1370\/revisions"}],"predecessor-version":[{"id":1371,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1370\/revisions\/1371"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}