其实现在我用MariaDB更多一些，不过，有些项目还是用的Mysql，所以,在Mysql方面也不能落下，这次就来学习一下Linux下采用Mysql二进制方式安装。
首先，去官网下载相应的版本的 压缩包
但是，你们都知道的，如果直接在官网下载，需要花费很多时间，因为，太慢了，所以，我找了一个镜像地址
一分钟不到就下载了好了，
[root@VM_175_142_centos mysql]# ls
mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz
先解压
[root@VM_175_142_centos mysql]# xz -d mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz
[root@VM_175_142_centos mysql]# ls
mysql-8.0.21-linux-glibc2.12-x86_64.tar
[root@VM_175_142_centos mysql]# tar xvf mysql-8.0.21-linux-glibc2.12-x86_64.tar
mysql-8.0.21-linux-glibc2.12-x86_64/
mysql-8.0.21-linux-glibc2.12-x86_64/LICENSE
mysql-8.0.21-linux-glibc2.12-x86_64/man/
mysql-8.0.21-linux-glibc2.12-x86_64/man/man8/
mysql-8.0.21-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlman.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlimport.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqladmin.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/myisamlog.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/myisampack.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlrouter.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/my_print_defaults.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlpump.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/lz4_decompress.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/zlib_decompress.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlshow.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlslap.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/ibd2sdi.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/perror.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_config.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/comp_err.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/myisamchk.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysql.server.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/innochecksum.1
mysql-8.0.21-linux-glibc2.12-x86_64/man/man1/mysqlcheck.1
mysql-8.0.21-linux-glibc2.12-x86_64/support-files/
mysql-8.0.21-linux-glibc2.12-x86_64/support-files/mysql-log-rotate
mysql-8.0.21-linux-glibc2.12-x86_64/support-files/mysql.server
mysql-8.0.21-linux-glibc2.12-x86_64/support-files/mysqld_multi.server
mysql-8.0.21-linux-glibc2.12-x86_64/bin/
mysql-8.0.21-linux-glibc2.12-x86_64/bin/innochecksum
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlpump
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_upgrade
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlshow
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_secure_installation
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlbinlog
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlslap
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlcheck
mysql-8.0.21-linux-glibc2.12-x86_64/bin/perror
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_config_editor
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqld
mysql-8.0.21-linux-glibc2.12-x86_64/bin/myisamchk
mysql-8.0.21-linux-glibc2.12-x86_64/bin/myisamlog
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqlimport
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql_config
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqldump
mysql-8.0.21-linux-glibc2.12-x86_64/bin/my_print_defaults
mysql-8.0.21-linux-glibc2.12-x86_64/bin/myisampack
mysql-8.0.21-linux-glibc2.12-x86_64/bin/lz4_decompress
mysql-8.0.21-linux-glibc2.12-x86_64/bin/zlib_decompress
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqladmin
mysql-8.0.21-linux-glibc2.12-x86_64/bin/ibd2sdi
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysql
mysql-8.0.21-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-8.0.21-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-8.0.21-linux-glibc2.12-x86_64/share/
mysql-8.0.21-linux-glibc2.12-x86_64/share/norwegian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/norwegian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/messages_to_error_log.txt
mysql-8.0.21-linux-glibc2.12-x86_64/share/german/
mysql-8.0.21-linux-glibc2.12-x86_64/share/german/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/install_rewriter.sql
mysql-8.0.21-linux-glibc2.12-x86_64/share/norwegian-ny/
mysql-8.0.21-linux-glibc2.12-x86_64/share/norwegian-ny/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/uninstall_rewriter.sql
mysql-8.0.21-linux-glibc2.12-x86_64/share/english/
mysql-8.0.21-linux-glibc2.12-x86_64/share/english/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/aclocal/
mysql-8.0.21-linux-glibc2.12-x86_64/share/aclocal/mysql.m4
mysql-8.0.21-linux-glibc2.12-x86_64/share/messages_to_clients.txt
mysql-8.0.21-linux-glibc2.12-x86_64/share/swedish/
mysql-8.0.21-linux-glibc2.12-x86_64/share/swedish/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/greek/
mysql-8.0.21-linux-glibc2.12-x86_64/share/greek/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/dutch/
mysql-8.0.21-linux-glibc2.12-x86_64/share/dutch/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/japanese/
mysql-8.0.21-linux-glibc2.12-x86_64/share/japanese/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/spanish/
mysql-8.0.21-linux-glibc2.12-x86_64/share/spanish/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/italian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/italian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/latin7.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp1257.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/greek.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/keybcs2.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/macce.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/geostd8.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/koi8u.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/latin5.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/latin1.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/koi8r.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/hebrew.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/Index.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/swe7.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/dec8.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp1256.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/macroman.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp1250.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/ascii.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp852.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/hp8.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/armscii8.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/latin2.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp1251.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp850.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/cp866.xml
mysql-8.0.21-linux-glibc2.12-x86_64/share/charsets/README
mysql-8.0.21-linux-glibc2.12-x86_64/share/hungarian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/hungarian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/czech/
mysql-8.0.21-linux-glibc2.12-x86_64/share/czech/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/innodb_memcached_config.sql
mysql-8.0.21-linux-glibc2.12-x86_64/share/polish/
mysql-8.0.21-linux-glibc2.12-x86_64/share/polish/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/estonian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/estonian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/russian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/russian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/romanian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/romanian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/dictionary.txt
mysql-8.0.21-linux-glibc2.12-x86_64/share/ukrainian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/ukrainian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/slovak/
mysql-8.0.21-linux-glibc2.12-x86_64/share/slovak/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/bulgarian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/bulgarian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/portuguese/
mysql-8.0.21-linux-glibc2.12-x86_64/share/portuguese/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/serbian/
mysql-8.0.21-linux-glibc2.12-x86_64/share/serbian/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/danish/
mysql-8.0.21-linux-glibc2.12-x86_64/share/danish/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/korean/
mysql-8.0.21-linux-glibc2.12-x86_64/share/korean/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/share/french/
mysql-8.0.21-linux-glibc2.12-x86_64/share/french/errmsg.sys
mysql-8.0.21-linux-glibc2.12-x86_64/include/
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql_time.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysqlx_version.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/my_command.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/field_types.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/errmsg.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/my_compress.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysqlx_ername.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql_version.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/my_list.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql_com.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysqlx_error.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql/
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.21-linux-glibc2.12-x86_64/include/mysql/client_plugin.h
mysql-8.0.21-linux-glibc2.12-x86_64/lib/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/libmysqlclient.a
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libcrypto.so.1.1
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libssl.so.1.1
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libprotobuf.so.3.11.4
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libcrypto.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libssl.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/private/libprotobuf-lite.so.3.11.4
mysql-8.0.21-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21
mysql-8.0.21-linux-glibc2.12-x86_64/lib/pkgconfig/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.21-linux-glibc2.12-x86_64/lib/libmysqlclient.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21.1.21
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/mysql_clone.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/libmemcached.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_syseventlog.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/auth_socket.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_json.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/group_replication.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_validate_password.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/adt_null.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/semisync_master.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/keyring_file.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_mysqlbackup.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/rewriter.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/validate_password.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/mypluglib.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/semisync_slave.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/ha_mock.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_log_filter_dragnet.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/locking_service.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/keyring_udf.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/innodb_engine.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/libpluginmecab.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/mysql_no_login.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/version_token.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/ddl_rewriter.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/connection_control.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/plugin/component_audit_api_message_emit.so
mysql-8.0.21-linux-glibc2.12-x86_64/lib/libmysqlservices.a
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/unk.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/sys.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/matrix.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/pos-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/right-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/rewrite.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/etc/
mysql-8.0.21-linux-glibc2.12-x86_64/lib/mecab/etc/mecabrc
mysql-8.0.21-linux-glibc2.12-x86_64/docs/
mysql-8.0.21-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.21-linux-glibc2.12-x86_64/docs/INFO_BIN
mysql-8.0.21-linux-glibc2.12-x86_64/docs/ChangeLog
mysql-8.0.21-linux-glibc2.12-x86_64/README
我们把文件重命名成简单一点的名字
[root@VM_175_142_centos mysql]# ls
mysql-8.0.21-linux-glibc2.12-x86_64 mysql-8.0.21-linux-glibc2.12-x86_64.tar
[root@VM_175_142_centos mysql]# mv mysql-8.0.21-linux-glibc2.12-x86_64 mysql-8.0.21
[root@VM_175_142_centos mysql]# ls
mysql-8.0.21 mysql-8.0.21-linux-glibc2.12-x86_64.tar
ok，一切准备就绪，接下来就开始进入主题吧，这里我mysql的解压目录是/root/mysql/mysql-8.0.21,
我们还是新建一个data文件夹和一个my.cnf文件，
mkdir data&&touch my.cnf
在my.cnf配置数据文件地址
basedir=/root/mysql/mysql-8.0.21
# set datadir to the location of your data directory
datadir=/root/mysql/mysql-8.0.21/data
我们需要做个软连接到环境变量的目录，或者自行去配置环境变量,在或者直接去bin目录，不然会出现
[root@VM_175_142_centos mysql-8.0.21]# mysql
-bash: mysql: 未找到命令
我们先直接进入到bin目录来操作吧，很不巧，出问题了
[root@VM_175_142_centos bin]# mysqld --initialize --user=mysql
mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
一般这种问题就是没有找到相应的文件，所需，需要安装对应的依赖包，
[root@VM_175_142_centos bin]# yum -y install numactl
已加载插件：fastestmirror, langpacks
Determining fastest mirrors
docker-ce-stable | 3.5 kB 00:00:00
epel | 4.7 kB 00:00:00
extras | 2.9 kB 00:00:00
os | 3.6 kB 00:00:00
updates | 2.9 kB 00:00:00
(1/8): epel/7/x86_64/group_gz | 95 kB 00:00:00
(2/8): epel/7/x86_64/updateinfo | 1.0 MB 00:00:00
(3/8): os/7/x86_64/group_gz | 153 kB 00:00:00
(4/8): extras/7/x86_64/primary_db | 206 kB 00:00:00
(5/8): os/7/x86_64/primary_db | 6.1 MB 00:00:00
(6/8): updates/7/x86_64/primary_db | 4.5 MB 00:00:00
(7/8): epel/7/x86_64/primary_db | 6.9 MB 00:00:01
(8/8): docker-ce-stable/x86_64/primary_db | 46 kB 00:00:01
正在解决依赖关系
--> 正在检查事务
---> 软件包 numactl.x86_64.0.2.0.12-5.el7 将被 安装
--> 正在处理依赖关系 libnuma.so.1(libnuma_1.4)(64bit)，它被软件包 numactl-2.0.12-5.el7.x86_64 需要
--> 正在处理依赖关系 libnuma.so.1(libnuma_1.3)(64bit)，它被软件包 numactl-2.0.12-5.el7.x86_64 需要
--> 正在处理依赖关系 libnuma.so.1(libnuma_1.2)(64bit)，它被软件包 numactl-2.0.12-5.el7.x86_64 需要
--> 正在处理依赖关系 libnuma.so.1(libnuma_1.1)(64bit)，它被软件包 numactl-2.0.12-5.el7.x86_64 需要
--> 正在处理依赖关系 libnuma.so.1()(64bit)，它被软件包 numactl-2.0.12-5.el7.x86_64 需要
--> 正在检查事务
---> 软件包 numactl-libs.x86_64.0.2.0.12-5.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
===================================================================================================================================================================================================
Package 架构 版本 源 大小
===================================================================================================================================================================================================
正在安装:
numactl x86_64 2.0.12-5.el7 os 66 k
为依赖而安装:
numactl-libs x86_64 2.0.12-5.el7 os 30 k
事务概要
===================================================================================================================================================================================================
安装 1 软件包 (+1 依赖软件包)
总下载量：96 k
安装大小：191 k
Downloading packages:
(1/2): numactl-libs-2.0.12-5.el7.x86_64.rpm | 30 kB 00:00:00
(2/2): numactl-2.0.12-5.el7.x86_64.rpm | 66 kB 00:00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 261 kB/s | 96 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : numactl-libs-2.0.12-5.el7.x86_64 1/2
正在安装 : numactl-2.0.12-5.el7.x86_64 2/2
验证中 : numactl-libs-2.0.12-5.el7.x86_64 1/2
验证中 : numactl-2.0.12-5.el7.x86_64 2/2
已安装:
numactl.x86_64 0:2.0.12-5.el7
作为依赖被安装:
numactl-libs.x86_64 0:2.0.12-5.el7
完毕！
安装完成后，我们再来执行一次刚才的初始化命令
[root@VM_175_142_centos mysql-8.0.21]# bin/mysqld --defaults-file=/root/mysql/mysql-8.0.21/my.cnf --initialize --user=root
2020-09-28T14:55:36.787210Z 0 [System] [MY-013169] [Server] /root/mysql/mysql-8.0.21/bin/mysqld (mysqld 8.0.21) initializing of server in progress as process 2738
2020-09-28T14:55:36.877702Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-28T14:55:39.687677Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-09-28T14:55:43.015597Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fd6uB&W4e%Go
可以看到，首次初始化会给我们生成一个默认密码，我们一定要记住它,开启SSL
[root@VM_175_142_centos mysql-8.0.21]# bin/mysql_ssl_rsa_setup
启动服务
[root@VM_175_142_centos mysql-8.0.21]# bin/mysqld_safe --defaults-file=/root/mysql/mysql-8.0.21/my.cnf --user=root &
[1] 12196
[root@VM_175_142_centos mysql-8.0.21]# Logging to '/root/mysql/mysql-8.0.21/data/VM_175_142_centos.err'.
2020-09-28T14:57:42.907590Z mysqld_safe Starting mysqld daemon with databases from /root/mysql/mysql-8.0.21/data
现在，可以看到已经启动成功，我们新开一个窗口来连接一下
mysql -u root -p
我们先把默认密码修改掉ALTER USER '用户'@'主机' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY '新密码';
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'root';
Query OK, 0 rows affected (0.01 sec)
现在就可以使用我们的新密码重新登录了，现在，我们用HeidiSQL来连接我们远程的Mysql，在连接之前，我们需要先修改一下User里面的地址,不然会出现这种情况，
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| component |
| db |
| default_roles |
| engine_cost |
| func |
| general_log |
| global_grants |
| gtid_executed |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| password_history |
| plugin |
| procs_priv |
| proxies_priv |
| role_edges |
| server_cost |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
33 rows in set (0.00 sec)
mysql> SELECT HOST FROM USER;
ERROR 1146 (42S02): Table 'mysql.USER' doesn't exist
mysql> select host from user;;
+-----------+
| host |
+-----------+
| localhost |
| localhost |
| localhost |
| localhost |
+-----------+
4 rows in set (0.00 sec)
这里我们先把host都修改为%
mysql> update user set host ='%';
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4 Changed: 4 Warnings: 0
然后执行flush privileges使配置立即生效
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
现在就可以进行远程连接了
我只是记录我的学习过程，由于书读得少，可能很多地方表述或者是理解得不对，请轻喷并指正。