linux安装mysql_在Linux 中安装Mysql-8.0.21

其实现在我用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)

现在就可以进行远程连接了

我只是记录我的学习过程，由于书读得少，可能很多地方表述或者是理解得不对，请轻喷并指正。