银河麒麟v10 安装mysql 8.35

银河麒麟v10 安装mysql 8.35

  • 1、卸载mariadb
  • 2、下载Mysql安装包
  • 3、安装Mysql 8.35
    • 3.1、安装依赖包
    • 3.2、安装Mysql
    • 3.3、安装后配置

1、卸载mariadb

由于银河麒麟v10系统默认安装了mariadb 会与Mysql相冲突,因此首先需要卸载系统自带的mariadb
查看系统上默认安装的Mariadb软件包
使用yum查看已经安装的mariadb软件包

yum list --installed mariadb

在这里插入图片描述

rpm -qa|grep mariadb

在这里插入图片描述

查看默认的mariadb配置文件

在这里插入代码片

默认的配置文件是 /etc/my.cnf

在这里插入图片描述

查看默认的mariadb配置目录

find / -type d  -name my.cnf*

在这里插入图片描述

使用yum卸载 mariadb

yum remove mariadb.x86_64

在这里插入图片描述

验证卸载Mariadb成功

在这里插入图片描述

查看Mariadb配置文件和目录是否还存在 已经不存在了

在这里插入图片描述

至此mariadb卸载完成

2、下载Mysql安装包

访问官网下载链接 链接: https://dev.mysql.com/downloads/mysql/

选择如下 点击下载按钮 下载安装包
在这里插入图片描述

3、安装Mysql 8.35

官方安装文档 链接: https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/binary-installation.html

3.1、安装依赖包

yum search libaio

在这里插入图片描述

yum install libaio

在这里插入图片描述

3.2、安装Mysql

命令顺序如下 安装包放在/root/package/mysql/mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
cd /usr/local
tar -xJvf /root/package/mysql/mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz
ln -s /usr/local/mysql-8.0.35-linux-glibc2.28-x86_64/ mysql
cd mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-filesecho -e "[mysqld]\ndatadir=/var/lib/mysql/data\nbasedir=/var/lib/mysql\nsocket=/var/lib/mysql/mysql.sock\nuser=mysql\nport=3306\ncharacter-set-server=UTF8MB4\nsymbolic-links=0\nsql-mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION\n[mysqld_safe]\nlog-error=/var/log/mysqld/mysqld.log\npid-file=/var/run/mysqld/mysqld.pid\n[client]\nport=3306\nsocket=/var/lib/mysql/mysql.sock"  >> /etc/my.cnfchown mysql:mysql /etc/my.cnfmkdir -p /var/lib/mysql/data
chown mysql:mysql /var/lib/mysqlmkdir -p /var/log/mysqld/
touch /var/log/mysqld/mysqld.log
chown -R mysql:mysql /var/log/mysqld
chmod 777 /var/log/mysqld/mysqld.logmkdir -p /var/run/mysqld/
chown mysql:mysql /var/run/mysqld/
chmod 777 /var/run/mysqld/mkdir -p /var/lib/mysql/bin
cp bin/mysqld_safe /var/lib/mysql/bin
chown -R mysql:mysql /var/lib/mysqlbin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysqlbin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &
# Next command is optional
cp support-files/mysql.server /etc/init.d/mysql.server

其中执行bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql 会打印出Mysql的默认密码
最后一句:A temporary password is generated for root@localhost: Wyfu?iFAW8tY

[root@kylin mysql]# bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
2023-12-21T17:06:04.983518Z 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.
2023-12-21T17:06:04.983548Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-12-21T17:06:04.983669Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld (mysqld 8.0.35) initializing of server in progress as process 2463
2023-12-21T17:06:04.983705Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/var/lib/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-12-21T17:06:04.999543Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-21T17:06:06.162453Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-21T17:06:07.431899Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: /var/lib/mysql/lib/private/.
2023-12-21T17:06:08.403649Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Wyfu?iFAW8tY

其中执行bin/mysqld_safe --user=mysql & 是启动Mysql服务 日志如下

[root@kylin mysql]# cat  /var/log/mysqld/mysqld.log 
2023-12-21T16:56:15.955718Z 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.
2023-12-21T16:56:15.955759Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-12-21T16:56:15.955866Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.35) starting as process 2724
2023-12-21T16:56:15.955909Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/var/lib/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-12-21T16:56:15.994198Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-21T16:56:16.608751Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-21T16:56:17.123876Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: /var/lib/mysql/lib/private/.
2023-12-21T16:56:17.132285Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-12-21T16:56:17.132330Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-12-21T16:56:17.138763Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-12-21T16:56:17.165747Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-12-21T16:56:17.165839Z 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.35'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
[root@kylin mysql]# 

添加mysql的环境变量
vi /etc/profile 最后面添加2行

export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

在这里插入图片描述

配置Mysql开机自启动

chkconfig --add mysql.server

在这里插入图片描述

完整命令执行记录

[root@kylin ~]# cd  /root/package/mysql
[root@kylin mysql]# groupadd mysql
[root@kylin mysql]# useradd -r -g mysql -s /bin/false mysql
[root@kylin mysql]# cd /usr/local
[root@kylin local]# tar -xJvf /root/package/mysql/mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz
mysql-8.0.35-linux-glibc2.28-x86_64/bin/
mysql-8.0.35-linux-glibc2.28-x86_64/bin/myisam_ftdump
mysql-8.0.35-linux-glibc2.28-x86_64/bin/myisamchk
mysql-8.0.35-linux-glibc2.28-x86_64/bin/myisamlog
mysql-8.0.35-linux-glibc2.28-x86_64/bin/myisampack
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_config_editor
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_migrate_keyring
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_secure_installation
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_upgrade
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqladmin
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlbinlog
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlcheck
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqldump
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlimport
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlpump
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlshow
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqlslap
mysql-8.0.35-linux-glibc2.28-x86_64/lib/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/authentication_fido_client.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/authentication_kerberos_client.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/authentication_oci_client.so
mysql-8.0.35-linux-glibc2.28-x86_64/bin/
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld-debug
mysql-8.0.35-linux-glibc2.28-x86_64/bin/
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysql_config
mysql-8.0.35-linux-glibc2.28-x86_64/include/
mysql-8.0.35-linux-glibc2.28-x86_64/include/errmsg.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/field_types.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/my_command.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/my_compress.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/my_list.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql/
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql/client_plugin.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql_com.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql_time.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysql_version.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysqld_error.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysqlx_ername.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysqlx_error.h
mysql-8.0.35-linux-glibc2.28-x86_64/include/mysqlx_version.h
mysql-8.0.35-linux-glibc2.28-x86_64/lib/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/libmysqlclient.a
mysql-8.0.35-linux-glibc2.28-x86_64/lib/libmysqlservices.a
mysql-8.0.35-linux-glibc2.28-x86_64/lib/pkgconfig/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.35-linux-glibc2.28-x86_64/share/
mysql-8.0.35-linux-glibc2.28-x86_64/share/aclocal/
mysql-8.0.35-linux-glibc2.28-x86_64/share/aclocal/mysql.m4
mysql-8.0.35-linux-glibc2.28-x86_64/docs/
mysql-8.0.35-linux-glibc2.28-x86_64/docs/INFO_SRC
mysql-8.0.35-linux-glibc2.28-x86_64/docs/
mysql-8.0.35-linux-glibc2.28-x86_64/docs/INFO_BIN
mysql-8.0.35-linux-glibc2.28-x86_64/docs/INFO_SRC
mysql-8.0.35-linux-glibc2.28-x86_64/man/
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/comp_err.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/ibd2sdi.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/innochecksum.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/lz4_decompress.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/my_print_defaults.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/myisamchk.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/myisamlog.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/myisampack.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql.server.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_config.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqladmin.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlcheck.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqld_multi.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqld_safe.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqldump.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlimport.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlman.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlpump.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlrouter.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlshow.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/mysqlslap.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/perror.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man1/zlib_decompress.1
mysql-8.0.35-linux-glibc2.28-x86_64/man/man8/
mysql-8.0.35-linux-glibc2.28-x86_64/man/man8/mysqld.8
mysql-8.0.35-linux-glibc2.28-x86_64/LICENSE
mysql-8.0.35-linux-glibc2.28-x86_64/README
mysql-8.0.35-linux-glibc2.28-x86_64/bin/
mysql-8.0.35-linux-glibc2.28-x86_64/bin/ibd2sdi
mysql-8.0.35-linux-glibc2.28-x86_64/bin/innochecksum
mysql-8.0.35-linux-glibc2.28-x86_64/bin/lz4_decompress
mysql-8.0.35-linux-glibc2.28-x86_64/bin/my_print_defaults
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld_multi
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld_safe
mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqldumpslow
mysql-8.0.35-linux-glibc2.28-x86_64/bin/perror
mysql-8.0.35-linux-glibc2.28-x86_64/bin/zlib_decompress
mysql-8.0.35-linux-glibc2.28-x86_64/lib/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/matrix.bin
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/pos-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/rewrite.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/right-id.def
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/sys.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/dic/ipadic_utf-8/unk.dic
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/etc/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/mecab/etc/mecabrc
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/adt_null.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/auth_socket.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_audit_api_message_emit.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_keyring_file.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_log_filter_dragnet.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_log_sink_json.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_log_sink_syseventlog.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_mysqlbackup.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_query_attributes.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_reference_cache.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/component_validate_password.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/connection_control.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/ddl_rewriter.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/adt_null.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/auth_socket.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_audit_api_message_emit.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_keyring_file.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_log_filter_dragnet.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_log_sink_json.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_log_sink_syseventlog.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_mysqlbackup.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_query_attributes.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_reference_cache.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/component_validate_password.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/connection_control.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/ddl_rewriter.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/group_replication.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/ha_example.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/ha_mock.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/innodb_engine.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/keyring_file.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/keyring_udf.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/libmemcached.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/libpluginmecab.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/locking_service.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/mypluglib.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/mysql_clone.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/mysql_no_login.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/rewrite_example.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/rewriter.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/semisync_master.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/semisync_replica.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/semisync_slave.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/semisync_source.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/validate_password.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/debug/version_token.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/group_replication.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/ha_example.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/ha_mock.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/innodb_engine.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/keyring_file.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/keyring_udf.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/libmemcached.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/libpluginmecab.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/locking_service.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/mypluglib.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/mysql_clone.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/mysql_no_login.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/rewrite_example.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/rewriter.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/semisync_master.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/semisync_replica.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/semisync_slave.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/semisync_source.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/validate_password.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/plugin/version_token.so
mysql-8.0.35-linux-glibc2.28-x86_64/share/
mysql-8.0.35-linux-glibc2.28-x86_64/share/bulgarian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/bulgarian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/Index.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/README
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/armscii8.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/ascii.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp1250.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp1251.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp1256.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp1257.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp850.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp852.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/cp866.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/dec8.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/geostd8.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/greek.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/hebrew.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/hp8.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/keybcs2.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/koi8r.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/koi8u.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/latin1.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/latin2.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/latin5.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/latin7.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/macce.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/macroman.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/charsets/swe7.xml
mysql-8.0.35-linux-glibc2.28-x86_64/share/czech/
mysql-8.0.35-linux-glibc2.28-x86_64/share/czech/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/danish/
mysql-8.0.35-linux-glibc2.28-x86_64/share/danish/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/dictionary.txt
mysql-8.0.35-linux-glibc2.28-x86_64/share/dutch/
mysql-8.0.35-linux-glibc2.28-x86_64/share/dutch/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/english/
mysql-8.0.35-linux-glibc2.28-x86_64/share/english/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/estonian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/estonian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/french/
mysql-8.0.35-linux-glibc2.28-x86_64/share/french/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/german/
mysql-8.0.35-linux-glibc2.28-x86_64/share/german/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/greek/
mysql-8.0.35-linux-glibc2.28-x86_64/share/greek/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/hungarian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/hungarian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/innodb_memcached_config.sql
mysql-8.0.35-linux-glibc2.28-x86_64/share/italian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/italian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/japanese/
mysql-8.0.35-linux-glibc2.28-x86_64/share/japanese/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/korean/
mysql-8.0.35-linux-glibc2.28-x86_64/share/korean/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/messages_to_clients.txt
mysql-8.0.35-linux-glibc2.28-x86_64/share/messages_to_error_log.txt
mysql-8.0.35-linux-glibc2.28-x86_64/share/norwegian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/norwegian-ny/
mysql-8.0.35-linux-glibc2.28-x86_64/share/norwegian-ny/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/norwegian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/polish/
mysql-8.0.35-linux-glibc2.28-x86_64/share/polish/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/portuguese/
mysql-8.0.35-linux-glibc2.28-x86_64/share/portuguese/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/romanian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/romanian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/russian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/russian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/serbian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/serbian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/slovak/
mysql-8.0.35-linux-glibc2.28-x86_64/share/slovak/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/spanish/
mysql-8.0.35-linux-glibc2.28-x86_64/share/spanish/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/swedish/
mysql-8.0.35-linux-glibc2.28-x86_64/share/swedish/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/share/ukrainian/
mysql-8.0.35-linux-glibc2.28-x86_64/share/ukrainian/errmsg.sys
mysql-8.0.35-linux-glibc2.28-x86_64/support-files/
mysql-8.0.35-linux-glibc2.28-x86_64/support-files/mysql-log-rotate
mysql-8.0.35-linux-glibc2.28-x86_64/support-files/mysql.server
mysql-8.0.35-linux-glibc2.28-x86_64/support-files/mysqld_multi.server
mysql-8.0.35-linux-glibc2.28-x86_64/lib/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/libmysqlclient.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/libmysqlclient.so.21
mysql-8.0.35-linux-glibc2.28-x86_64/lib/libmysqlclient.so.21.2.35
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/burmesedict.dict
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/char.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/cjdict.dict
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/de.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/el.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/en.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/en_US.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/en_US_POSIX.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/es.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/fi.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/fr.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/it.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/ja.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/khmerdict.dict
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/ko.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/laodict.dict
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_loose.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_loose_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_loose_phrase_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_normal.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_normal_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_normal_phrase_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/line_phrase_cj.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/pt.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/res_index.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/root.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/ru.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/sent.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/sent_el.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/sv.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/thaidict.dict
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/title.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/word.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/word_POSIX.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/word_fi_sv.brk
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/zh.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/brkitr/zh_Hant.res
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/cnvalias.icu
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/uemoji.icu
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/ulayout.icu
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/icudt73l/unames.icu
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libcom_err.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libcom_err.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libcom_err.so.3.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libcrypto.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libcrypto.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libfido2.so.1
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libfido2.so.1.13.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libgssapi_krb5.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libgssapi_krb5.so.2
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libgssapi_krb5.so.2.2
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libk5crypto.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libk5crypto.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libk5crypto.so.3.1
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5.so.3.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5support.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5support.so.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libkrb5support.so.0.1
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/liblber-2.5.so.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/liblber-2.5.so.0.1.8
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/liblber.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libldap-2.5.so.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libldap-2.5.so.0.1.8
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libldap.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libprotobuf-lite.so.3.19.4
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libprotobuf.so.3.19.4
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libsasl2.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libsasl2.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libsasl2.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libssl.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/libssl.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libanonymous.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libanonymous.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libanonymous.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libcrammd5.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libcrammd5.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libcrammd5.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libdigestmd5.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libdigestmd5.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libdigestmd5.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgs2.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgs2.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgs2.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgssapiv2.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgssapiv2.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libgssapiv2.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libplain.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libplain.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libplain.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libscram.so
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libscram.so.3
mysql-8.0.35-linux-glibc2.28-x86_64/lib/private/sasl2/libscram.so.3.0.0
mysql-8.0.35-linux-glibc2.28-x86_64/share/
mysql-8.0.35-linux-glibc2.28-x86_64/share/install_rewriter.sql
mysql-8.0.35-linux-glibc2.28-x86_64/share/uninstall_rewriter.sql
[root@kylin local]# ln -s /usr/local/mysql-8.0.35-linux-glibc2.28-x86_64/ mysql
[root@kylin local]# cd mysql
[root@kylin mysql]# mkdir mysql-files
[root@kylin mysql]# chown mysql:mysql mysql-files
[root@kylin mysql]# chmod 750 mysql-files
[root@kylin mysql]# echo -e "[mysqld]\ndatadir=/var/lib/mysql/data\nbasedir=/var/lib/mysql\nsocket=/var/lib/mysql/mysql.sock\nuser=mysql\nport=3306\ncharacter-set-server=UTF8MB4\nsymbolic-links=0\nsql-mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION\n[mysqld_safe]\nlog-error=/var/log/mysqld/mysqld.log\npid-file=/var/run/mysqld/mysqld.pid\n[client]\nport=3306\nsocket=/var/lib/mysql/mysql.sock"  >> /etc/my.cnf
[root@kylin mysql]# chown mysql:mysql /etc/my.cnf
[root@kylin mysql]# mkdir -p /var/lib/mysql/data
[root@kylin mysql]# chown mysql:mysql /var/lib/mysql
[root@kylin mysql]# mkdir -p /var/log/mysqld/
[root@kylin mysql]# touch /var/log/mysqld/mysqld.log
[root@kylin mysql]# chown -R mysql:mysql /var/log/mysqld
[root@kylin mysql]# chmod 777 /var/log/mysqld/mysqld.log
[root@kylin mysql]# chown mysql:mysql /var/log/mysqld/
[root@kylin mysql]# chmod 777 /var/log/mysqld/
[root@kylin mysql]# mkdir -p /var/run/mysqld/
[root@kylin mysql]# chown mysql:mysql /var/run/mysqld/
[root@kylin mysql]# chmod 777 /var/run/mysqld/
[root@kylin mysql]# mkdir -p /var/lib/mysql/bin
[root@kylin mysql]# cp bin/mysqld_safe /var/lib/mysql/bin
[root@kylin mysql]# chown -R mysql:mysql /var/lib/mysql
[root@kylin mysql]# bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
2023-12-21T17:06:04.983518Z 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.
2023-12-21T17:06:04.983548Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-12-21T17:06:04.983669Z 0 [System] [MY-013169] [Server] /usr/local/mysql-8.0.35-linux-glibc2.28-x86_64/bin/mysqld (mysqld 8.0.35) initializing of server in progress as process 2463
2023-12-21T17:06:04.983705Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/var/lib/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-12-21T17:06:04.999543Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-21T17:06:06.162453Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-21T17:06:07.431899Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: /var/lib/mysql/lib/private/.
2023-12-21T17:06:08.403649Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Wyfu?iFAW8tY
[root@kylin mysql]# bin/mysql_ssl_rsa_setup
WARNING: mysql_ssl_rsa_setup is deprecated and will be removed in a future version. Use the mysqld server instead.
[root@kylin mysql]# bin/mysqld_safe --user=mysql &
[1] 2584
[root@kylin mysql]# 2023-12-21T17:06:36.960229Z mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
2023-12-21T17:06:37.008834Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data[root@kylin mysql]# cp support-files/mysql.server /etc/init.d/mysql.server
[root@kylin mysql]# 

3.3、安装后配置

链接: https://dev.mysql.com/doc/mysql-installation-excerpt/8.0/en/postinstallation.html

使用安装Mysql数据库 时生成的默认密码登录mysql数据库

mysql -uroot -p

没修改默认密码前不能进行数据库sql操作
在这里插入图片描述

修改Mysql默认密码为Mysql@123

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root@123' PASSWORD EXPIRE NEVER;
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> 
mysql> use mysql
Database changed
mysql> 
mysql> update user set host = "%" where user = "root";
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> 
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Root@123';
Query OK, 0 rows affected (0.01 sec)mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)mysql> 

使用新密码登录mysql数据库

在这里插入图片描述

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.rhkb.cn/news/222773.html

如若内容造成侵权/违法违规/事实不符,请联系长河编程网进行投诉反馈email:809451989@qq.com,一经查实,立即删除!

相关文章

2023-12-22 linux C语言pthread_kill函数,pthread_kill(tid, 0)可以用来判断线程是否存在

一、该函数其实不是kill线程,而是向线程发送一个signal,pthread_kill()函数的作用是向某个线程传递一个信号,创建的线程中signal(SIGKILL,sig_handler)函数去处理对应的信号,如果你给一个线程发送了SIGQUIT、SIGKILL,但…

论文阅读——llava

Visual Instruction Tuning LLaVA 指令智能体分为两类:端到端的,通过LangChain[1]/LLM[35]协调各种模型的系统。 数据集生成用GPT辅助生成的,具体不写了。 模型结构: input image Xv LLM:Vicuna visual encoder&a…

conda环境下更改虚拟环境安装路径

1 引言 在Anaconda中如果没有指定路径,虚拟环境会默认安装在anaconda所安装的目录下,但如果默认环境的磁盘空间不足,无法满足大量安装虚拟环境的需求,此时我们需要更改虚拟环境的安装路径,有以下两种方案: 方案1: 每次…

数据仓库-数据治理小厂实践

一、简介 数据治理贯穿数仓中数据的整个生命周期,从数据的产生、加载、清洗、计算,再到数据展示、应用,每个阶段都需要对数据进行治理,像有些比较大的企业都是有自己的数据治理平台或者会开发一些便捷的平台,对于没有平…

使用OpenCV DNN模块进行人脸检测

内容的一部分来源于贾志刚的《opencv4应用开发、入门、进阶与工程化实践》。这本书我大概看了一下,也就后面几章比较感兴趣,但是内容很少,并没有想像的那种充实。不过学习还是要学习的。 在实际工程项目中,并不是说我们将神经网络…

【Unity】【WebRTC】如何用Unity而不是浏览器接收远程画面

【背景】 之前几篇我们讨论了如何设置信令服务器,如何发送画面给远端以及如何用浏览器查看同步画面,今天来讨论如何实现Unity内部接收画面。 看本篇之前请先看过之前将web服务器设置和基本远程画面功能的几篇博文。(同专栏下查看&#xff09…

el-select如何去掉placeholder属性

功能要求是&#xff1a;当el-select的disabled属性为true的时候不展示“请选择”字样 1、要去掉 el-select 元素的 placeholder 属性&#xff0c;可以在代码中将其设置为空字符串。 <el-select placeholder"" ...></el-select> 注意&#xff1a;这种方…

Linux目录切换相关命令@cd/pwd

目录 基础指令 cd命令原型命令的搭配以及效果命令本身cd cd 指定目录 基础指令 pwd命令原型pwd 总结&#xff1a; 基础指令 cd cd 取自英文 Change Directory 的首字母组成。 英文的中文翻译为&#xff1a;更改目录。 很明显该指令是用来更改目录的。 命令原型 cd [Linux路径…

Java设计模式之单例模式以及如何防止通过反射破坏单例模式

单例模式 单例模式使用场景 ​ 什么是单例模式&#xff1f;保障一个类只能有一个对象&#xff08;实例&#xff09;的代码开发模式就叫单例模式 ​ 什么时候使用&#xff1f; 工具类&#xff01;&#xff08;一种做法&#xff0c;所有的方法都是static&#xff0c;还有一种单…

27. 过滤器

Filter(过滤器)简介 Filter 的基本功能是对 Servlet 容器调用 Servlet 的过程进行拦截&#xff0c;从而在 Servlet 进行响应处理的前后实现一些特殊的功能。在 Servlet API 中定义了三个接口类来开供开发人员编写 Filter 程序&#xff1a;Filter, FilterChain, FilterConfigFi…

【数据结构】队列的使用|模拟实现|循环队列|双端队列|面试题

一、 队列(Queue) 1.1 概念 队列&#xff1a;只允许在一端进行插入数据操作&#xff0c;在另一端进行删除数据操作的特殊线性表&#xff0c;队列具有先进先出FIFO(First In First Out) 入队列&#xff1a;进行插入操作的一端称为队尾&#xff08;Tail/Rear&#xff09; 出队列…

TSINGSEE青犀可视化视频云平台JT/T1078接入能力在智慧物流中的应用

一、引言 随着科技的快速发展和全球贸易的蓬勃发展&#xff0c;智慧物流成为了现代物流业的重要发展方向。智慧物流通过引入先进的信息技术&#xff0c;实现了物流过程的自动化、智能化和信息化&#xff0c;从而提高了物流效率和准确性。在这个过程中&#xff0c;JT/T1078接入…

【分享】4个方法打开PDF文件

PDF是很多人工作中经常使用的电子文档格式&#xff0c;但是可能有些刚接触的小伙伴不知道用什么工具来打开PDF文件&#xff0c;今天小编就来分享一下4种常用的工具。 1. 使用浏览器 只要有电脑基本都会安装一到两款浏览器&#xff0c;其实浏览器也可以用来打开PDF文件。 只需…

在x64上构建智能家居(home assistant)(二)(新版Debain12)连接Postgresql数据库

新版数据库安装基本和旧版相同,大部分可以参考旧版本在x64上构建智能家居(home assistant)&#xff08;二&#xff09;连接Postgresql数据库_homeassist 数据库-CSDN博客 新版本的home assistant系统安装,我在原来写的手顺上直接修改了,需要的可以查看在x64上构建智能家居(home…

探索未来交通!空客、宝马开启新一轮“量子计算挑战赛”

12月6日&#xff0c;空中客车公司和宝马集团共同发起了一项名为 “量子交通探索”的全球量子计算挑战赛&#xff0c;以应对航空和汽车领域最紧迫的挑战——这些挑战对于传统计算机而言仍然是难以克服的。 这项挑战是首创性的&#xff0c;它将两个全球行业领导者聚集在一起&…

Wavesurfer.js绘制波形图

HTML使用Wavesurfer.js 要使用wavesurfer.js&#xff0c;首先需要在HTML文件中引入Wavesurfer.js库&#xff0c;然后创建一个音频元素并将其添加到页面中。接下来&#xff0c;初始化Wavesurfer实例并配置相关选项。以下是一个简单的示例&#xff1a; 在HTML文件中引入Wavesurf…

jvm内存模型

1、简介 JVM在执行Java程序时&#xff0c;会把它管理的内存划分为若干个的区域&#xff0c;每个区域都有自己的用途和创建销毁时间。如下图所示&#xff0c;可以分为两大部分&#xff0c;线程私有区和共享区。下图是根据自己理解画的一个JVM内存模型架构图&#xff1a; 2、线程…

LeetCode刷题--- 电话号码的字母组合

个人主页&#xff1a;元清加油_【C】,【C语言】,【数据结构与算法】-CSDN博客 个人专栏 力扣递归算法题 http://t.csdnimg.cn/yUl2I 【C】 http://t.csdnimg.cn/6AbpV 数据结构与算法 http://t.csdnimg.cn/hKh2l 前言&#xff1a;这个专栏主要讲述递归递归、搜…

机器学习算法(12) — 集成技术(Boosting — Xgboost 分类)

一、说明 时间这是集成技术下的第 4 篇文章&#xff0c;如果您想了解有关集成技术的更多信息&#xff0c;您可以参考我的第 1 篇集成技术文章。 机器学习算法&#xff08;9&#xff09; - 集成技术&#xff08;装袋 - 随机森林分类器和...... 在这篇文章中&#xff0c;我将解释…

LangChain入门指南:定义、功能和工作原理

LangChain入门指南&#xff1a;定义、功能和工作原理 引言LangChain是什么&#xff1f;LangChain的核心功能LangChain的工作原理LangChain实际应用案例如何开始使用LangChain 引言 在人工智能的浪潮中&#xff0c;语言模型已成为推动技术革新的重要力量。从简单的文本生成到复…