• Linux Mysql8 安装教程

    一、下载mysql8 安装包

    1：官方地址

    https://dev.mysql.com/downloads/

    2：下载界面

    image

    3:下载地址

    wget  https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz

    或者：

    wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

    二：安装mysql 包

    1：查看系统版本

    uname -a

    image

    2：上传msyql安装包至linux服务器

    image

    3：解压 mysql 压缩包

    [root@192 home]# clear
[root@192 home]# pwd
/home
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# ll
total 672052
drwxr-xr-x. 2 root  root         21 May 18 10:57 Backup
-rw-r--r--. 1 root  root  148003999 May 18 10:48 jdk-8u331-linux-x64.tar.gz
-rw-r--r--. 1 root  root  540173160 May 18 11:56 mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz
drwx------. 3 redis redis        78 Jun 22  2021 redis
[root@192 home]# clear

[root@192 home]# tar xvf mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisamchk
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisamlog
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisampack
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_config_editor
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_migrate_keyring
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_secure_installation
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_upgrade
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqladmin
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlbinlog
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlcheck
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlimport
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlpump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlshow
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlslap
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_fido_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_kerberos_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_oci_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld-debug
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_config
mysql-8.0.29-linux-glibc2.12-x86_64/include/
mysql-8.0.29-linux-glibc2.12-x86_64/include/errmsg.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/field_types.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_command.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_compress.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_list.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/client_plugin.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_com.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_time.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_version.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_ername.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_error.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_version.h
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.a
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlservices.a
mysql-8.0.29-linux-glibc2.12-x86_64/lib/pkgconfig/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/aclocal/
mysql-8.0.29-linux-glibc2.12-x86_64/share/aclocal/mysql.m4
mysql-8.0.29-linux-glibc2.12-x86_64/docs/
mysql-8.0.29-linux-glibc2.12-x86_64/docs/ChangeLog
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.29-linux-glibc2.12-x86_64/docs/
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_BIN
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.29-linux-glibc2.12-x86_64/man/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/comp_err.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/ibd2sdi.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/innochecksum.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/lz4_decompress.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/my_print_defaults.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisamchk.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisamlog.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisampack.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql.server.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_config.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqladmin.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlcheck.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlimport.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlman.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlpump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlshow.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlslap.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/perror.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/zlib_decompress.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man8/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-8.0.29-linux-glibc2.12-x86_64/LICENSE
mysql-8.0.29-linux-glibc2.12-x86_64/README
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/ibd2sdi
mysql-8.0.29-linux-glibc2.12-x86_64/bin/innochecksum
mysql-8.0.29-linux-glibc2.12-x86_64/bin/lz4_decompress
mysql-8.0.29-linux-glibc2.12-x86_64/bin/my_print_defaults
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-8.0.29-linux-glibc2.12-x86_64/bin/perror
mysql-8.0.29-linux-glibc2.12-x86_64/bin/zlib_decompress
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/etc/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/etc/mecabrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/adt_null.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/auth_socket.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_audit_api_message_emit.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_filter_dragnet.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_json.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_syseventlog.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_mysqlbackup.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_query_attributes.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_reference_cache.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/connection_control.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ddl_rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/adt_null.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/auth_socket.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_audit_api_message_emit.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_filter_dragnet.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_sink_json.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_sink_syseventlog.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_mysqlbackup.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_query_attributes.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_reference_cache.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/connection_control.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ddl_rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/group_replication.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ha_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ha_mock.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/innodb_engine.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_udf.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/libmemcached.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/libpluginmecab.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/locking_service.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mypluglib.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mysql_clone.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mysql_no_login.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/rewrite_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_master.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_replica.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_slave.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_source.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/version_token.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/group_replication.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ha_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ha_mock.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/innodb_engine.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/keyring_udf.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/libmemcached.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/libpluginmecab.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/locking_service.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mypluglib.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mysql_clone.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mysql_no_login.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/rewrite_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_master.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_replica.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_slave.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_source.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/version_token.so
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/bulgarian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/bulgarian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/Index.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/README
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/armscii8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/ascii.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1250.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1251.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1256.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1257.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp850.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp852.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp866.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/dec8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/geostd8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/greek.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/hebrew.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/hp8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/keybcs2.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/koi8r.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/koi8u.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin1.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin2.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin5.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin7.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/macce.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/macroman.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/swe7.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/czech/
mysql-8.0.29-linux-glibc2.12-x86_64/share/czech/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/danish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/danish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/dictionary.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/dutch/
mysql-8.0.29-linux-glibc2.12-x86_64/share/dutch/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/english/
mysql-8.0.29-linux-glibc2.12-x86_64/share/english/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/estonian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/estonian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/french/
mysql-8.0.29-linux-glibc2.12-x86_64/share/french/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/german/
mysql-8.0.29-linux-glibc2.12-x86_64/share/german/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/greek/
mysql-8.0.29-linux-glibc2.12-x86_64/share/greek/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/hungarian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/hungarian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/innodb_memcached_config.sql
mysql-8.0.29-linux-glibc2.12-x86_64/share/italian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/italian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/japanese/
mysql-8.0.29-linux-glibc2.12-x86_64/share/japanese/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/korean/
mysql-8.0.29-linux-glibc2.12-x86_64/share/korean/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/messages_to_clients.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/messages_to_error_log.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian-ny/
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian-ny/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/polish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/polish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/portuguese/
mysql-8.0.29-linux-glibc2.12-x86_64/share/portuguese/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/romanian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/romanian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/russian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/russian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/serbian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/serbian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/slovak/
mysql-8.0.29-linux-glibc2.12-x86_64/share/slovak/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/spanish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/spanish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/swedish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/swedish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/ukrainian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/ukrainian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysql-log-rotate
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysql.server
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysqld_multi.server
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21.2.29
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/burmesedict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/char.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/cjdict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/de.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/el.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en_US.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en_US_POSIX.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/es.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/fr.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/it.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/ja.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/khmerdict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/laodict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_loose.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_loose_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_normal.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_normal_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/pt.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/res_index.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/root.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/ru.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/sent.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/sent_el.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/thaidict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/title.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/word.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/word_POSIX.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/zh.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/zh_Hant.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/unames.icu
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so.3.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcrypto.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcrypto.so.1.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libfido2.so.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libfido2.so.1.5.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so.2.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so.3.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so.3.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so.0.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber-2.4.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber-2.4.so.2.11.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r-2.4.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r-2.4.so.2.11.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libprotobuf-lite.so.3.19.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libprotobuf.so.3.19.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libssl.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libssl.so.1.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/install_rewriter.sql
mysql-8.0.29-linux-glibc2.12-x86_64/share/uninstall_rewriter.sql
[root@192 home]#
    View Code

    4、重命名

    [root@192 home]# mv mysql-8.0.29-linux-glibc2.12-x86_64 mysql-8.0
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]#
    View Code

    5、移动重命名后的文件

    为了方便管理，我们将下载后用户软件统一放到usr/local下

    [root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# mv mysql-8.0 /usr/local/
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# cd /usr/local/
[root@192 local]# ll
total 0
drwxr-xr-x. 2 root root 134 Jun 24  2021 bin
drwxr-xr-x. 2 root root   6 Apr 11  2018 etc
drwxr-xr-x. 2 root root   6 Apr 11  2018 games
drwxr-xr-x. 2 root root   6 Apr 11  2018 include
drwxr-xr-x. 2 root root   6 Apr 11  2018 lib
drwxr-xr-x. 2 root root   6 Apr 11  2018 lib64
drwxr-xr-x. 2 root root   6 Apr 11  2018 libexec
drwxr-xr-x. 9 root root 129 May 18 14:33 mysql-8.0
drwxr-xr-x. 2 root root   6 Apr 11  2018 sbin
drwxr-xr-x. 5 root root  49 Jun 22  2021 share
drwxr-xr-x. 3 root root  51 Jun 24  2021 soft
drwxr-xr-x. 2 root root   6 Apr 11  2018 src
[root@192 local]#
    View Code

    6、切换到mysql-8.0文件夹下

    [root@192 local]# cd mysql-8.0/
[root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ll
total 288
drwxr-xr-x.  2 7161 31415   4096 Mar 24 03:57 bin
drwxr-xr-x.  2 7161 31415     55 Mar 24 03:57 docs
drwxr-xr-x.  3 7161 31415   4096 Mar 24 03:57 include
drwxr-xr-x.  6 7161 31415    201 Mar 24 03:57 lib
-rw-r--r--.  1 7161 31415 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 7161 31415     30 Mar 24 03:57 man
-rw-r--r--.  1 7161 31415    666 Mar 23 21:52 README
drwxr-xr-x. 28 7161 31415   4096 Mar 24 03:57 share
drwxr-xr-x.  2 7161 31415     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]#
    View Code

    7、创建data文件夹存储文件

    [root@192 mysql-8.0]# mkdir data
[root@192 mysql-8.0]# ll
total 288
drwxr-xr-x.  2 7161 31415   4096 Mar 24 03:57 bin
drwxr-xr-x.  2 root root       6 May 18 14:45 data
drwxr-xr-x.  2 7161 31415     55 Mar 24 03:57 docs
drwxr-xr-x.  3 7161 31415   4096 Mar 24 03:57 include
drwxr-xr-x.  6 7161 31415    201 Mar 24 03:57 lib
-rw-r--r--.  1 7161 31415 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 7161 31415     30 Mar 24 03:57 man
-rw-r--r--.  1 7161 31415    666 Mar 23 21:52 README
drwxr-xr-x. 28 7161 31415   4096 Mar 24 03:57 share
drwxr-xr-x.  2 7161 31415     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]#
    View Code

    8、创建用户组以及用户和密码

    [root@192 mysql-8.0]# groupadd mysql
[root@192 mysql-8.0]# useradd -g mysql mysql
[root@192 mysql-8.0]#
    View Code

    9、授权用户

    [root@192 mysql-8.0]# chown -R mysql.mysql /usr/local/mysql-8.0
[root@192 mysql-8.0]#
    View Code

    10、切换到bin目录下

    [root@192 mysql-8.0]# cd bin/
[root@192 bin]# pwd
/usr/local/mysql-8.0/bin
[root@192 bin]# ll
total 774220
-rwxr-xr-x. 1 7161 31415    729098 Mar 24 03:31 ibd2sdi
-rwxr-xr-x. 1 7161 31415    568671 Mar 24 03:31 innochecksum
-rwxr-xr-x. 1 7161 31415    381296 Mar 24 03:30 lz4_decompress
-rwxr-xr-x. 1 7161 31415   7367501 Mar 24 03:31 myisamchk
-rwxr-xr-x. 1 7161 31415   7099077 Mar 24 03:31 myisam_ftdump
-rwxr-xr-x. 1 7161 31415   7071523 Mar 24 03:31 myisamlog
-rwxr-xr-x. 1 7161 31415   7173538 Mar 24 03:31 myisampack
-rwxr-xr-x. 1 7161 31415    464318 Mar 24 03:30 my_print_defaults
-rwxr-xr-x. 1 7161 31415   8599155 Mar 24 03:32 mysql
-rwxr-xr-x. 1 7161 31415   8190355 Mar 24 03:32 mysqladmin
-rwxr-xr-x. 1 7161 31415   8964064 Mar 24 03:33 mysqlbinlog
-rwxr-xr-x. 1 7161 31415   8211240 Mar 24 03:32 mysqlcheck
-rwxr-xr-x. 1 7161 31415      5074 Mar 24 03:29 mysql_config
-rwxr-xr-x. 1 7161 31415    454130 Mar 24 03:32 mysql_config_editor
-rwxr-xr-x. 1 7161 31415 119247542 Mar 24 03:43 mysqld
-rwxr-xr-x. 1 7161 31415 538304403 Mar 24 03:28 mysqld-debug
-rwxr-xr-x. 1 7161 31415     27492 Mar 24 03:29 mysqld_multi
-rwxr-xr-x. 1 7161 31415     29183 Mar 24 03:29 mysqld_safe
-rwxr-xr-x. 1 7161 31415   8295446 Mar 24 03:32 mysqldump
-rwxr-xr-x. 1 7161 31415      7669 Mar 24 03:29 mysqldumpslow
-rwxr-xr-x. 1 7161 31415   8179243 Mar 24 03:32 mysqlimport
-rwxr-xr-x. 1 7161 31415   8443977 Mar 24 03:32 mysql_migrate_keyring
-rwxr-xr-x. 1 7161 31415   9500995 Mar 24 03:33 mysqlpump
-rwxr-xr-x. 1 7161 31415   8164034 Mar 24 03:32 mysql_secure_installation
-rwxr-xr-x. 1 7161 31415   8179696 Mar 24 03:32 mysqlshow
-rwxr-xr-x. 1 7161 31415   8204198 Mar 24 03:32 mysqlslap
-rwxr-xr-x. 1 7161 31415    549833 Mar 24 03:30 mysql_ssl_rsa_setup
-rwxr-xr-x. 1 7161 31415    330062 Mar 24 03:31 mysql_tzinfo_to_sql
-rwxr-xr-x. 1 7161 31415   8461386 Mar 24 03:32 mysql_upgrade
-rwxr-xr-x. 1 7161 31415   1191036 Mar 24 03:31 perror
-rwxr-xr-x. 1 7161 31415    346497 Mar 24 03:30 zlib_decompress
[root@192 bin]#
    View Code

    11、初始化基础信息

    注意：本操作是预防一下问题：

如果在这里报错:./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

出现该问题首先检查该链接库文件有没有安装使用 rpm -qa|grep libaio命令进行核查 运行该命令后发现系统中无该链接库文件 使用命令，yum install libaio-devel.x86_64安装安装成功后
    View Code
    

    

    [root@192 jdk1.8.0_331]# rpm -qa|grep libaio
libaio-0.3.109-13.el7.x86_64
[root@192 jdk1.8.0_331]# yum install libaio-devel.x86_64
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * centos-sclo-rh: mirrors.aliyun.com
 * centos-sclo-sclo: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
Resolving Dependencies
--> Running transaction check
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================
 Package                             Arch                          Version                                Repository                   Size
============================================================================================================================================
Installing:
 libaio-devel                        x86_64                        0.3.109-13.el7                         base                         13 k

Transaction Summary
============================================================================================================================================
Install  1 Package

Total download size: 13 k
Installed size: 7.8 k
Is this ok [y/d/N]: y
Downloading packages:
libaio-devel-0.3.109-13.el7.x86_64.rpm                                                                               |  13 kB  00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 73 pre-existing rpmdb problem(s), 'yum check' output follows:
antlr-tool-2.7.7-30.el7.noarch has missing requires of java >= ('1', '1.7.0', None)
apache-commons-cli-1.2-13.el7.noarch has missing requires of java >= ('0', '1.5', None)
apache-commons-codec-1.8-7.el7.noarch has missing requires of java >= ('1', '1.6', None)
apache-commons-collections-3.2.1-22.el7_2.noarch has missing requires of java >= ('0', '1.5', None)
apache-commons-daemon-1.0.13-7.el7.x86_64 has missing requires of java >= ('0', '1.5', None)
apache-commons-dbcp-1.4-17.el7.noarch has missing requires of java >= ('1', '1.6', None)
1:apache-commons-io-2.4-12.el7.noarch has missing requires of java >= ('1', '1.6', None)
apache-commons-lang-2.6-15.el7.noarch has missing requires of java >= ('0', '1.3', None)
apache-commons-logging-1.1.2-7.el7.noarch has missing requires of java >= ('0', '1.5', None)
apache-commons-pool-1.6-9.el7.noarch has missing requires of java >= ('0', '1.5', None)
args4j-2.0.16-13.el7.noarch has missing requires of java >= ('0', '1.5', None)
cal10n-0.7.7-4.el7.noarch has missing requires of java >= ('0', '1.5', None)
codemodel-2.6-9.el7.noarch has missing requires of java
easymock2-2.5.2-12.el7.noarch has missing requires of java
1:ecj-4.5.2-3.el7.x86_64 has missing requires of java >= ('1', '1.6.0', None)
geronimo-jms-1.1.1-19.el7.noarch has missing requires of java >= ('0', '1.5', None)
geronimo-jta-1.1.1-17.el7.noarch has missing requires of java >= ('0', '1.5', None)
glassfish-dtd-parser-1.2-0.8.20120120svn.el7.noarch has missing requires of java >= ('0', '1.5', None)
glassfish-fastinfoset-1.2.12-9.el7.noarch has missing requires of java >= ('0', '1.5', None)
glassfish-jaxb-2.2.5-6.el7.noarch has missing requires of java
glassfish-jaxb-api-2.2.7-4.el7.noarch has missing requires of java >= ('1', '1.6.0', None)
guava-13.0-6.el7.noarch has missing requires of java >= ('1', '1.6', None)
hamcrest-1.3-6.el7.noarch has missing requires of java >= ('1', '1.6.0', None)
1:hsqldb-1.8.1.3-14.el7.noarch has missing requires of java
httpcomponents-client-4.2.5-5.el7_0.noarch has missing requires of java >= ('0', '1.5', None)
httpcomponents-core-4.2.4-6.el7.noarch has missing requires of java >= ('0', '1.5', None)
icedtea-web-1.7.1-2.el7_6.x86_64 has missing requires of java-1.8.0-openjdk
1:isorelax-0-0.15.release20050331.el7.noarch has missing requires of java
istack-commons-2.17-4.el7.noarch has missing requires of java
jackson-1.9.4-7.el7.noarch has missing requires of java
1:jakarta-commons-httpclient-3.1-16.el7_0.noarch has missing requires of java
javamail-1.4.6-8.el7.noarch has missing requires of java >= ('0', '1.5', None)
javassist-3.16.1-10.el7.noarch has missing requires of java >= ('0', '1.5', None)
jboss-annotations-1.1-api-1.0.1-0.6.20120212git76e1a2.el7.noarch has missing requires of java
jing-20091111-14.el7.noarch has missing requires of java-headless >= ('0', '1.5.0', None)
jline-1.0-8.el7.noarch has missing requires of java >= ('0', '1.5', None)
joda-convert-1.3-5.el7.noarch has missing requires of java >= ('1', '1.6', None)
joda-time-2.2-3.tzdata2013c.el7.noarch has missing requires of java >= ('0', '1.5', None)
jsr-311-1.1.1-6.el7.noarch has missing requires of java >= ('0', '1.5', None)
jss-4.4.9-3.el7.x86_64 has missing requires of java-1.8.0-openjdk-headless
junit-4.11-8.el7.noarch has missing requires of java >= ('1', '1.6.0', None)
log4j-1.2.17-16.el7_4.noarch has missing requires of java >= ('0', '1.5', None)
1:msv-msv-2013.5.1-7.el7.noarch has missing requires of java >= ('0', '1.5', None)
1:msv-xsdlib-2013.5.1-7.el7.noarch has missing requires of java >= ('0', '1.5', None)
nuxwdog-client-java-1.0.5-1.el7.x86_64 has missing requires of java-headless >= ('1', '1.6.0', None)
parfait-0.5.4-2.el7.noarch has missing requires of java >= ('1', '1.8', None)
pki-base-java-10.5.18-7.el7.noarch has missing requires of java-1.8.0-openjdk-headless
pki-ca-10.5.18-7.el7.noarch has missing requires of java-1.8.0-openjdk-headless
pki-kra-10.5.18-7.el7.noarch has missing requires of java-1.8.0-openjdk-headless
pki-server-10.5.18-7.el7.noarch has missing requires of java-1.8.0-openjdk-headless
pki-tools-10.5.18-7.el7.x86_64 has missing requires of java-1.8.0-openjdk-headless
qdox-1.12.1-10.el7.noarch has missing requires of java >= ('0', '1.5', None)
regexp-1.5-13.el7.noarch has missing requires of java
resteasy-base-atom-provider-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
resteasy-base-client-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
resteasy-base-jackson-provider-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
resteasy-base-jaxb-provider-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
resteasy-base-jaxrs-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
resteasy-base-jaxrs-api-3.0.6-4.el7.noarch has missing requires of java >= ('1', '1.6', None)
scannotation-1.0.3-0.7.r12.el7.noarch has missing requires of java
si-units-0.6.5-1.el7.noarch has missing requires of java >= ('1', '1.8', None)
slf4j-1.7.4-4.el7_4.noarch has missing requires of java >= ('0', '1.5', None)
stax-ex-1.7.1-6.el7.noarch has missing requires of java >= ('0', '1.5', None)
tomcat-7.0.76-15.el7.noarch has missing requires of java >= ('1', '1.6.0', None)
tomcatjss-7.2.5-1.el7.noarch has missing requires of java
txw2-20110809-8.el7.noarch has missing requires of java
unit-api-1.0-3.el7.noarch has missing requires of java >= ('1', '1.7', None)
uom-lib-1.0.1-5.el7.noarch has missing requires of java >= ('1', '1.7', None)
uom-se-1.0.4-3.el7.noarch has missing requires of java >= ('1', '1.8', None)
uom-systems-0.7-1.el7.noarch has missing requires of java >= ('1', '1.8', None)
xerces-j2-2.11.0-17.el7_0.noarch has missing requires of java
xml-commons-apis-1.4.01-16.el7.noarch has missing requires of java
xpp3-1.1.3.8-11.el7.noarch has missing requires of java
  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                                                       1/1
  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                                                       1/1

Installed:
  libaio-devel.x86_64 0:0.3.109-13.el7

Complete!
[root@192 jdk1.8.0_331]#
    

    
View Code
    



    

    

    [root@192 bin]# ./mysqld --user=mysql --basedir=/usr/local/mysql-8.0 --datadir=/usr/local/mysql-8.0/data/ --initialize
2022-05-18T06:52:34.985642Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2022-05-18T06:52:34.985956Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0/bin/mysqld (mysqld 8.0.29) initializing of server in progress as process 6629
2022-05-18T06:52:35.007218Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-18T06:52:40.632360Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-18T06:52:45.036301Z 6 [Note] [MY-010454] [Server] A temporary password is generated for 
    
root@localhost: 3rNk.RH6gauJ

    [root@192 bin]#
    

    

    
注意：，继续运行数据库的初始化命令，成功后得到临时密码“root@localhost: 3rNk.RH6gauJ”,记得保存，等会需要用
    
View Code
    



    12、编辑my.cnf文件
    

    

    vi /etc/my.cnf
    

    



    注释mysqld_safe,修改信息
    

    

    [mysqld]
  basedir=/usr/local/mysql-8.0/
  datadir=/usr/local/mysql-8.0/data/
  socket=/tmp/mysql.sock
  character-set-server=UTF8MB4

    

    



    

    

    [root@192 bin]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@192 bin]# vim  /etc/my.cnf
[root@192 bin]# cat /etc/my.cnf
[mysqld]

basedir=/usr/local/mysql-8.0/
datadir=/usr/local/mysql-8.0/data/
socket=/tmp/mysql.sock
character-set-server=UTF8MB4
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@192 bin]#

    

    
View Code
    



    13、添加mysqld服务到系统
    

    这里要切换到安装目录下执行
    

    

    [root@192 bin]# cd ..
[root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ll
total 292
drwxr-xr-x.  2 mysql mysql   4096 Mar 24 03:57 bin
drwxr-xr-x.  6 mysql mysql   4096 May 18 14:52 data
drwxr-xr-x.  2 mysql mysql     55 Mar 24 03:57 docs
drwxr-xr-x.  3 mysql mysql   4096 Mar 24 03:57 include
drwxr-xr-x.  6 mysql mysql    201 Mar 24 03:57 lib
-rw-r--r--.  1 mysql mysql 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 mysql mysql     30 Mar 24 03:57 man
-rw-r--r--.  1 mysql mysql    666 Mar 23 21:52 README
drwxr-xr-x. 28 mysql mysql   4096 Mar 24 03:57 share
drwxr-xr-x.  2 mysql mysql     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]# cp -a ./support-files/mysql.server /etc/init.d/mysql

    

    



    14、授权以及添加服务
    

    

    [root@192 mysql-8.0]# chmod +x /etc/init.d/mysql
[root@192 mysql-8.0]# chkconfig --add mysql
[root@192 mysql-8.0]# ll /etc/init.d/mysql
-rwxr-xr-x. 1 mysql mysql 10576 Mar 24 03:29 /etc/init.d/mysql
[root@192 mysql-8.0]#

    

    



    15、启动mysql服务
    

    

    [root@192 mysql-8.0]# service mysql start
Starting MySQL...... SUCCESS!
[root@192 mysql-8.0]#
    

    



    16、查看启动状态
    

    

    [root@192 mysql-8.0]# service mysql status
 SUCCESS! MySQL running (7269)
[root@192 mysql-8.0]#

    

    




    17、将mysql命令添加到服务
    

      

    • 1
      • 

    

     
    

    

    ln -s /usr/local/mysql/mysql-8.0.20/bin/mysql /usr/bin

    

    

    如果存在了,覆盖就执行
    

    

    ln -sf /usr/local/mysql/mysql-8.0.20/bin/mysql /usr/bin

    

    



    

    [root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ls ./bin/
ibd2sdi         myisampack         mysql_config         mysqldump                  mysqlshow            zlib_decompress
innochecksum    my_print_defaults  mysql_config_editor  mysqldumpslow              mysqlslap
lz4_decompress  mysql              mysqld               mysqlimport                mysql_ssl_rsa_setup
myisamchk       mysqladmin         mysqld-debug         mysql_migrate_keyring      mysql_tzinfo_to_sql
myisam_ftdump   mysqlbinlog        mysqld_multi         mysqlpump                  mysql_upgrade
myisamlog       mysqlcheck         mysqld_safe          mysql_secure_installation  perror

[root@192 mysql-8.0]# ln -sf /usr/local/mysql-8.0/bin/mysql /usr/bin
[root@192 mysql-8.0]#
    

    




    三 ：登录mysql
    

    18、用临时密码登录
    

    

    mysql  mysql -uroot -p
    

    




    

    

    [root@192 mysql-8.0]# mysql  mysql -uroot -p
Enter password:3rNk.RH6gauJ         #临时密码
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.29

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

    

    
View Code
    


    password填写刚才生产的临时密码，到此就说明安装成功了
    

    19、改root密码
    


    

    

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

    

    
View Code
    


    

    

    [root@192 mysql-8.0]# mysql  mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.29

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)

mysql>
    

    
View Code
    



    其中123456是新的密码
    

    

    [root@MiWiFi-R3600-srv datav-rest]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1298
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root@123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
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> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'abb  123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql>  SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.01 sec)

mysql> set global validate_password.policy=0
    -> ；
    -> ;
ERROR 1193 (HY000): Unknown system variable 'policy'
mysql> set global validate_password.policy=0 ;
ERROR 1193 (HY000): Unknown system variable 'policy'
mysql> set global validate_password.length=1;
ERROR 1193 (HY000): Unknown system variable 'length'
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> quit
Bye
[root@MiWiFi-R3600-srv datav-rest]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1367
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)

mysql> set  global  validate_password.policy =0;
ERROR 1193 (HY000): Unknown system variable 'policy'
mysql> ERROR 1193 (HY000): Unknown system variable 'policy'
    -> 
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ERROR 1193 (HY000): Unknown system variable 'policy'' at line 1
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.01 sec)

mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'validate%';
+-------------------+---------------+
| plugin_name       | plugin_status |
+-------------------+---------------+
| validate_password | ACTIVE        |
+-------------------+---------------+
1 row in set (0.00 sec)

mysql> install plugin validate_password soname 'validate_password.so';
ERROR 1125 (HY000): Function 'validate_password' already exists
mysql> select plugin_name, plugin_status from information_schema.plugins where plugin_name like 'validate%';
+-------------------+---------------+
| plugin_name       | plugin_status |
+-------------------+---------------+
| validate_password | ACTIVE        |
+-------------------+---------------+
1 row in set (0.00 sec)

mysql>  SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password.length=1;
ERROR 1193 (HY000): Unknown system variable 'length'
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> install plugin validate_password soname 'validate_password.so';
ERROR 1125 (HY000): Function 'validate_password' already exists
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password_check_user_name    | OFF   |
| validate_password_dictionary_file    |       |
| validate_password_length             | 8     |
| validate_password_mixed_case_count   | 1     |
| validate_password_number_count       | 1     |
| validate_password_policy             | LOW   |
| validate_password_special_char_count | 1     |
+--------------------------------------+-------+
7 rows in set (0.00 sec)

mysql> set global validate_password.length=1;
ERROR 1193 (HY000): Unknown system variable 'length'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'AB@123456';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> select user,plugin from user where user='root'; 
ERROR 1046 (3D000): No database selected
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> select user,plugin from user where user='root'; 
+------+-----------------------+
| user | plugin                |
+------+-----------------------+
| root | mysql_native_password |
+------+-----------------------+
1 row in set (0.02 sec)

mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| confluence    | %         |
| mysql.session | %         |
| mysql.sys     | %         |
| root          | %         |
| confluence    | localhost |
+---------------+-----------+
5 rows in set (0.09 sec)

mysql> alter user 'root'@'%' identified with mysql_native_password by 'root@123456';
Query OK, 0 rows affected (0.00 sec)

mysql> select user,plugin from user where user='root'; 
+------+-----------------------+
| user | plugin                |
+------+-----------------------+
| root | mysql_native_password |
+------+-----------------------+
1 row in set (0.00 sec)

mysql> 
    

    







    20、执行 flush privileges; 使密码生效
    

    

    

    mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

    

    
View Code
    



    21、选择mysql数据库 use mysql;
    

    

    

    [root@192 mysql-8.0]# mysql  mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.29

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> use mysql
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                                         |
| replication_asynchronous_connection_failover         |
| replication_asynchronous_connection_failover_managed |
| replication_group_configuration_version              |
| replication_group_member_actions                     |
| 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                                                 |
+------------------------------------------------------+
37 rows in set (0.02 sec)

mysql>

    

    
View Code
    



    22、修改远程连接并生效,退出
    

    

    

    mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit;
Bye
[root@192 mysql-8.0]#

    

    
View Code
    




    23、开放防火墙端口,加载生效
    


    

    

    [root@192 mysql-8.0]# firewall-cmd --add-port=3306/tcp --permanent
success
[root@192 mysql-8.0]# firewall-cmd --reload
success
[root@192 mysql-8.0]#

    

    
View Code
    



    image
    


    四：整个具体的安装过程
    

    

    [root@192 home]# clear
[root@192 home]# pwd
/home
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# ll
total 672052
drwxr-xr-x. 2 root  root         21 May 18 10:57 Backup
-rw-r--r--. 1 root  root  148003999 May 18 10:48 jdk-8u331-linux-x64.tar.gz
-rw-r--r--. 1 root  root  540173160 May 18 11:56 mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz
drwx------. 3 redis redis        78 Jun 22  2021 redis
[root@192 home]# clear

[root@192 home]# tar xvf mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisamchk
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisamlog
mysql-8.0.29-linux-glibc2.12-x86_64/bin/myisampack
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_config_editor
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_migrate_keyring
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_secure_installation
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_upgrade
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqladmin
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlbinlog
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlcheck
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlimport
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlpump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlshow
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqlslap
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_fido_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_kerberos_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/authentication_oci_client.so
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld-debug
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysql_config
mysql-8.0.29-linux-glibc2.12-x86_64/include/
mysql-8.0.29-linux-glibc2.12-x86_64/include/errmsg.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/field_types.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_command.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_compress.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/my_list.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/client_plugin.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_com.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_time.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysql_version.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_ername.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_error.h
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqlx_version.h
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.a
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlservices.a
mysql-8.0.29-linux-glibc2.12-x86_64/lib/pkgconfig/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/aclocal/
mysql-8.0.29-linux-glibc2.12-x86_64/share/aclocal/mysql.m4
mysql-8.0.29-linux-glibc2.12-x86_64/docs/
mysql-8.0.29-linux-glibc2.12-x86_64/docs/ChangeLog
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.29-linux-glibc2.12-x86_64/docs/
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_BIN
mysql-8.0.29-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.29-linux-glibc2.12-x86_64/man/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/comp_err.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/ibd2sdi.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/innochecksum.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/lz4_decompress.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/my_print_defaults.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisamchk.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisamlog.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/myisampack.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql.server.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_config.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqladmin.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlcheck.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlimport.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlman.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlpump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlshow.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqlslap.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/perror.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/zlib_decompress.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man8/
mysql-8.0.29-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-8.0.29-linux-glibc2.12-x86_64/LICENSE
mysql-8.0.29-linux-glibc2.12-x86_64/README
mysql-8.0.29-linux-glibc2.12-x86_64/bin/
mysql-8.0.29-linux-glibc2.12-x86_64/bin/ibd2sdi
mysql-8.0.29-linux-glibc2.12-x86_64/bin/innochecksum
mysql-8.0.29-linux-glibc2.12-x86_64/bin/lz4_decompress
mysql-8.0.29-linux-glibc2.12-x86_64/bin/my_print_defaults
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-8.0.29-linux-glibc2.12-x86_64/bin/perror
mysql-8.0.29-linux-glibc2.12-x86_64/bin/zlib_decompress
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/matrix.bin
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/pos-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/rewrite.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/right-id.def
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/sys.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/unk.dic
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/etc/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/mecab/etc/mecabrc
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/adt_null.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/auth_socket.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_audit_api_message_emit.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_filter_dragnet.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_json.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_log_sink_syseventlog.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_mysqlbackup.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_query_attributes.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_reference_cache.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/component_validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/connection_control.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ddl_rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/adt_null.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/auth_socket.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_audit_api_message_emit.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_filter_dragnet.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_sink_json.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_log_sink_syseventlog.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_mysqlbackup.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_query_attributes.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_reference_cache.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/component_validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/connection_control.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ddl_rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/group_replication.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ha_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/ha_mock.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/innodb_engine.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_udf.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/libmemcached.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/libpluginmecab.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/locking_service.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mypluglib.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mysql_clone.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/mysql_no_login.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/rewrite_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_master.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_replica.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_slave.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_source.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/debug/version_token.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/group_replication.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ha_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/ha_mock.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/innodb_engine.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/keyring_file.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/keyring_udf.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/libmemcached.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/libpluginmecab.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/locking_service.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mypluglib.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mysql_clone.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/mysql_no_login.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/rewrite_example.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/rewriter.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_master.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_replica.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_slave.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/semisync_source.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/validate_password.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/plugin/version_token.so
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/bulgarian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/bulgarian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/Index.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/README
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/armscii8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/ascii.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1250.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1251.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1256.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp1257.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp850.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp852.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/cp866.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/dec8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/geostd8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/greek.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/hebrew.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/hp8.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/keybcs2.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/koi8r.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/koi8u.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin1.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin2.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin5.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/latin7.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/macce.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/macroman.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/charsets/swe7.xml
mysql-8.0.29-linux-glibc2.12-x86_64/share/czech/
mysql-8.0.29-linux-glibc2.12-x86_64/share/czech/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/danish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/danish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/dictionary.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/dutch/
mysql-8.0.29-linux-glibc2.12-x86_64/share/dutch/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/english/
mysql-8.0.29-linux-glibc2.12-x86_64/share/english/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/estonian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/estonian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/french/
mysql-8.0.29-linux-glibc2.12-x86_64/share/french/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/german/
mysql-8.0.29-linux-glibc2.12-x86_64/share/german/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/greek/
mysql-8.0.29-linux-glibc2.12-x86_64/share/greek/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/hungarian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/hungarian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/innodb_memcached_config.sql
mysql-8.0.29-linux-glibc2.12-x86_64/share/italian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/italian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/japanese/
mysql-8.0.29-linux-glibc2.12-x86_64/share/japanese/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/korean/
mysql-8.0.29-linux-glibc2.12-x86_64/share/korean/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/messages_to_clients.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/messages_to_error_log.txt
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian-ny/
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian-ny/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/norwegian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/polish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/polish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/portuguese/
mysql-8.0.29-linux-glibc2.12-x86_64/share/portuguese/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/romanian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/romanian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/russian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/russian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/serbian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/serbian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/slovak/
mysql-8.0.29-linux-glibc2.12-x86_64/share/slovak/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/spanish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/spanish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/swedish/
mysql-8.0.29-linux-glibc2.12-x86_64/share/swedish/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/share/ukrainian/
mysql-8.0.29-linux-glibc2.12-x86_64/share/ukrainian/errmsg.sys
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysql-log-rotate
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysql.server
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysqld_multi.server
mysql-8.0.29-linux-glibc2.12-x86_64/lib/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21
mysql-8.0.29-linux-glibc2.12-x86_64/lib/libmysqlclient.so.21.2.29
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/burmesedict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/char.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/cjdict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/de.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/el.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en_US.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/en_US_POSIX.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/es.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/fr.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/it.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/ja.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/khmerdict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/laodict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_loose.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_loose_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_normal.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/line_normal_cj.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/pt.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/res_index.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/root.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/ru.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/sent.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/sent_el.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/thaidict.dict
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/title.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/word.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/word_POSIX.brk
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/zh.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/brkitr/zh_Hant.res
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/icudt69l/unames.icu
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcom_err.so.3.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcrypto.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libcrypto.so.1.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libfido2.so.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libfido2.so.1.5.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libgssapi_krb5.so.2.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libk5crypto.so.3.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5.so.3.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libkrb5support.so.0.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber-2.4.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber-2.4.so.2.11.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/liblber.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r-2.4.so.2
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r-2.4.so.2.11.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libldap_r.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libprotobuf-lite.so.3.19.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libprotobuf.so.3.19.4
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libsasl2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libssl.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/libssl.so.1.1
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libanonymous.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libcrammd5.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libdigestmd5.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgs2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libgssapiv2.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libplain.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so.3
mysql-8.0.29-linux-glibc2.12-x86_64/lib/private/sasl2/libscram.so.3.0.0
mysql-8.0.29-linux-glibc2.12-x86_64/share/
mysql-8.0.29-linux-glibc2.12-x86_64/share/install_rewriter.sql
mysql-8.0.29-linux-glibc2.12-x86_64/share/uninstall_rewriter.sql
[root@192 home]#
[root@192 home]# mv mysql-8.0.29-linux-glibc2.12-x86_64 mysql-8.0
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# mv mysql-8.0 /usr/local/
[root@192 home]# ls
Backup  jdk-8u331-linux-x64.tar.gz  mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz  redis
[root@192 home]# cd /usr/local/
[root@192 local]# ll
total 0
drwxr-xr-x. 2 root root 134 Jun 24  2021 bin
drwxr-xr-x. 2 root root   6 Apr 11  2018 etc
drwxr-xr-x. 2 root root   6 Apr 11  2018 games
drwxr-xr-x. 2 root root   6 Apr 11  2018 include
drwxr-xr-x. 2 root root   6 Apr 11  2018 lib
drwxr-xr-x. 2 root root   6 Apr 11  2018 lib64
drwxr-xr-x. 2 root root   6 Apr 11  2018 libexec
drwxr-xr-x. 9 root root 129 May 18 14:33 mysql-8.0
drwxr-xr-x. 2 root root   6 Apr 11  2018 sbin
drwxr-xr-x. 5 root root  49 Jun 22  2021 share
drwxr-xr-x. 3 root root  51 Jun 24  2021 soft
drwxr-xr-x. 2 root root   6 Apr 11  2018 src
[root@192 local]# cd mysql-8.0/
[root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ll
total 288
drwxr-xr-x.  2 7161 31415   4096 Mar 24 03:57 bin
drwxr-xr-x.  2 7161 31415     55 Mar 24 03:57 docs
drwxr-xr-x.  3 7161 31415   4096 Mar 24 03:57 include
drwxr-xr-x.  6 7161 31415    201 Mar 24 03:57 lib
-rw-r--r--.  1 7161 31415 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 7161 31415     30 Mar 24 03:57 man
-rw-r--r--.  1 7161 31415    666 Mar 23 21:52 README
drwxr-xr-x. 28 7161 31415   4096 Mar 24 03:57 share
drwxr-xr-x.  2 7161 31415     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]#
[root@192 mysql-8.0]# mkdir data
[root@192 mysql-8.0]# ll
total 288
drwxr-xr-x.  2 7161 31415   4096 Mar 24 03:57 bin
drwxr-xr-x.  2 root root       6 May 18 14:45 data
drwxr-xr-x.  2 7161 31415     55 Mar 24 03:57 docs
drwxr-xr-x.  3 7161 31415   4096 Mar 24 03:57 include
drwxr-xr-x.  6 7161 31415    201 Mar 24 03:57 lib
-rw-r--r--.  1 7161 31415 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 7161 31415     30 Mar 24 03:57 man
-rw-r--r--.  1 7161 31415    666 Mar 23 21:52 README
drwxr-xr-x. 28 7161 31415   4096 Mar 24 03:57 share
drwxr-xr-x.  2 7161 31415     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]#

[root@192 mysql-8.0]# groupadd mysql
[root@192 mysql-8.0]# useradd -g mysql mysql
[root@192 mysql-8.0]# chown -R mysql.mysql /usr/local/mysql-8.0
[root@192 mysql-8.0]# cd bin/
[root@192 bin]# pwd
/usr/local/mysql-8.0/bin
[root@192 bin]# ll
total 774220
-rwxr-xr-x. 1 7161 31415    729098 Mar 24 03:31 ibd2sdi
-rwxr-xr-x. 1 7161 31415    568671 Mar 24 03:31 innochecksum
-rwxr-xr-x. 1 7161 31415    381296 Mar 24 03:30 lz4_decompress
-rwxr-xr-x. 1 7161 31415   7367501 Mar 24 03:31 myisamchk
-rwxr-xr-x. 1 7161 31415   7099077 Mar 24 03:31 myisam_ftdump
-rwxr-xr-x. 1 7161 31415   7071523 Mar 24 03:31 myisamlog
-rwxr-xr-x. 1 7161 31415   7173538 Mar 24 03:31 myisampack
-rwxr-xr-x. 1 7161 31415    464318 Mar 24 03:30 my_print_defaults
-rwxr-xr-x. 1 7161 31415   8599155 Mar 24 03:32 mysql
-rwxr-xr-x. 1 7161 31415   8190355 Mar 24 03:32 mysqladmin
-rwxr-xr-x. 1 7161 31415   8964064 Mar 24 03:33 mysqlbinlog
-rwxr-xr-x. 1 7161 31415   8211240 Mar 24 03:32 mysqlcheck
-rwxr-xr-x. 1 7161 31415      5074 Mar 24 03:29 mysql_config
-rwxr-xr-x. 1 7161 31415    454130 Mar 24 03:32 mysql_config_editor
-rwxr-xr-x. 1 7161 31415 119247542 Mar 24 03:43 mysqld
-rwxr-xr-x. 1 7161 31415 538304403 Mar 24 03:28 mysqld-debug
-rwxr-xr-x. 1 7161 31415     27492 Mar 24 03:29 mysqld_multi
-rwxr-xr-x. 1 7161 31415     29183 Mar 24 03:29 mysqld_safe
-rwxr-xr-x. 1 7161 31415   8295446 Mar 24 03:32 mysqldump
-rwxr-xr-x. 1 7161 31415      7669 Mar 24 03:29 mysqldumpslow
-rwxr-xr-x. 1 7161 31415   8179243 Mar 24 03:32 mysqlimport
-rwxr-xr-x. 1 7161 31415   8443977 Mar 24 03:32 mysql_migrate_keyring
-rwxr-xr-x. 1 7161 31415   9500995 Mar 24 03:33 mysqlpump
-rwxr-xr-x. 1 7161 31415   8164034 Mar 24 03:32 mysql_secure_installation
-rwxr-xr-x. 1 7161 31415   8179696 Mar 24 03:32 mysqlshow
-rwxr-xr-x. 1 7161 31415   8204198 Mar 24 03:32 mysqlslap
-rwxr-xr-x. 1 7161 31415    549833 Mar 24 03:30 mysql_ssl_rsa_setup
-rwxr-xr-x. 1 7161 31415    330062 Mar 24 03:31 mysql_tzinfo_to_sql
-rwxr-xr-x. 1 7161 31415   8461386 Mar 24 03:32 mysql_upgrade
-rwxr-xr-x. 1 7161 31415   1191036 Mar 24 03:31 perror
-rwxr-xr-x. 1 7161 31415    346497 Mar 24 03:30 zlib_decompress
[root@192 bin]#
[root@192 bin]# ./mysqld --user=mysql --basedir=/usr/local/mysql-8.0 --datadir=/usr/local/mysql-8.0/data/ --initialize
2022-05-18T06:52:34.985642Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2022-05-18T06:52:34.985956Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0/bin/mysqld (mysqld 8.0.29) initializing of server in progress as process 6629
2022-05-18T06:52:35.007218Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-18T06:52:40.632360Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-18T06:52:45.036301Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 
    
3rNk.RH6gauJ

    [root@192 bin]#
[root@192 bin]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@192 bin]# vim  /etc/my.cnf
[root@192 bin]# cat /etc/my.cnf
[mysqld]

basedir=/usr/local/mysql-8.0/
datadir=/usr/local/mysql-8.0/data/
socket=/tmp/mysql.sock
character-set-server=UTF8MB4
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@192 bin]#
[root@192 bin]# cd ..
[root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ll
total 292
drwxr-xr-x.  2 mysql mysql   4096 Mar 24 03:57 bin
drwxr-xr-x.  6 mysql mysql   4096 May 18 14:52 data
drwxr-xr-x.  2 mysql mysql     55 Mar 24 03:57 docs
drwxr-xr-x.  3 mysql mysql   4096 Mar 24 03:57 include
drwxr-xr-x.  6 mysql mysql    201 Mar 24 03:57 lib
-rw-r--r--.  1 mysql mysql 276593 Mar 23 21:52 LICENSE
drwxr-xr-x.  4 mysql mysql     30 Mar 24 03:57 man
-rw-r--r--.  1 mysql mysql    666 Mar 23 21:52 README
drwxr-xr-x. 28 mysql mysql   4096 Mar 24 03:57 share
drwxr-xr-x.  2 mysql mysql     77 Mar 24 03:57 support-files
[root@192 mysql-8.0]# cp -a ./support-files/mysql.server /etc/init.d/mysql
[root@192 mysql-8.0]# chmod +x /etc/init.d/mysql
[root@192 mysql-8.0]# chkconfig --add mysql
[root@192 mysql-8.0]# ll /etc/init.d/mysql
-rwxr-xr-x. 1 mysql mysql 10576 Mar 24 03:29 /etc/init.d/mysql
[root@192 mysql-8.0]#
[root@192 mysql-8.0]# service mysql start
Starting MySQL...... SUCCESS!

[root@192 mysql-8.0]# service mysql status
 SUCCESS! MySQL running (7269)
[root@192 mysql-8.0]#
[root@192 mysql-8.0]# pwd
/usr/local/mysql-8.0
[root@192 mysql-8.0]# ls ./bin/
ibd2sdi         myisampack         mysql_config         mysqldump                  mysqlshow            zlib_decompress
innochecksum    my_print_defaults  mysql_config_editor  mysqldumpslow              mysqlslap
lz4_decompress  mysql              mysqld               mysqlimport                mysql_ssl_rsa_setup
myisamchk       mysqladmin         mysqld-debug         mysql_migrate_keyring      mysql_tzinfo_to_sql
myisam_ftdump   mysqlbinlog        mysqld_multi         mysqlpump                  mysql_upgrade
myisamlog       mysqlcheck         mysqld_safe          mysql_secure_installation  perror

[root@192 mysql-8.0]# ln -sf /usr/local/mysql-8.0/bin/mysql /usr/bin
[root@192 mysql-8.0]#
[root@192 mysql-8.0]# mysql  mysql -uroot -p
Enter password:         
    
#临时密码： 3rNk.RH6gauJ

    Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.29

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use mysql
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                                         |
| replication_asynchronous_connection_failover         |
| replication_asynchronous_connection_failover_managed |
| replication_group_configuration_version              |
| replication_group_member_actions                     |
| 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                                                 |
+------------------------------------------------------+
37 rows in set (0.02 sec)

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit;
Bye
[root@192 mysql-8.0]# firewall-cmd --add-port=3306/tcp --permanent
success
[root@192 mysql-8.0]# firewall-cmd --reload
success
[root@192 mysql-8.0]#








































    

    


    


    

    
          
    • 

          
  • 

            相关阅读:
    
            
              软工实践-Alpha 冲刺 （7/10）
                
    软工实践-Alpha 冲刺 （6/10）
                
    软工实践-Alpha 冲刺 （5/10）
                
    软工实践-Alpha 冲刺 （4/10）
                
    BETA 版冲刺前准备
                
    第十一次作业
                
    Alpha 冲刺 （9/10）
                
    Alpha 冲刺 （8/10）
                
    Alpha 冲刺 （7/10）
                
    Alpha 冲刺 （6/10）
                
                    
          
    • 
          
  • 
            原文地址：https://www.cnblogs.com/ios9/p/16284119.html
          
    • 

        

      



      
      

        

        

      

    

  


  

  
Copyright © 2020-2023 
  润新知