银河麒麟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-files

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

chown mysql:mysql /etc/my.cnf

mkdir -p /var/lib/mysql/data
chown mysql:mysql /var/lib/mysql

mkdir -p /var/log/mysqld/
touch /var/log/mysqld/mysqld.log
chown -R mysql:mysql /var/log/mysqld
chmod 777 /var/log/mysqld/mysqld.log

mkdir -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/mysql

bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
  
bin/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: 0

mysql> 
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数据库

在这里插入图片描述

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

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈qq邮箱809451989@qq.com,一经查实,立即删除!

相关文章

Quartz.NET 事件监听器

1、调度器监听器 调度器本身收到的一些事件通知,接口ISchedulerListener,如作业的添加、删除、停止、挂起等事件通知,调度器的启动、关闭、出错等事件通知,触发器的暂停、挂起等事件通知,接口部分定义如下&#xff1a…

面试题:JVM 对锁都进行了哪些优化?

文章目录 锁优化自旋锁和自适应自旋锁消除锁粗化逃逸分析方法逃逸线程逃逸通过逃逸分析,编译器对代码的优化 锁优化 jvm 在加锁的过程中,会采用自旋、自适应、锁消除、锁粗化等优化手段来提升代码执行效率。 自旋锁和自适应自旋 现在大多的处理器都是…

C++入门-【13-C++ 多维数组】

C 多维数组 C 支持多维数组。多维数组声明的一般形式如下: type name[size1][size2]...[sizeN]; 例如,下面的声明创建了一个三维 5 . 10 . 4 整型数组: int threedim[5][10][4]; 二维数组 多维数组最简单的形式是二维数组。一个二维数组&am…

超维空间S2无人机使用说明书——32、使用yolov7进行目标识别

引言:为了提高yolo识别的质量,提高了yolo的版本,改用yolov7进行物体识别,同时系统兼容了低版本的yolo,包括基于C的yolov3和yolov4,也有更高版本的yolov8。 简介,为了提高识别速度,系…

Android Studio各种Gradle常见报错问题及解决方案

大家好,我是咕噜铁蛋!在开发Android应用程序时,我们可能会遇到各种Gradle错误。这些错误可能来自不同的原因,例如依赖项问题、配置错误、版本冲突等。今天我通过搜索整理了一下,在这篇文章中,我将分享一些常…

AI 绘画StableDiffusionWebui图生图

介绍 stable-diffusion-webui AI绘画工具,本文介绍图生图,以一张图片做底图优化生成。 例如:上传一张真人照片,让AI把他改绘成动漫人物;上传画作线稿,让AI自动上色;上传一张黑白照&#xff0c…

001 图书增删改查 SSM MySQL

技术框架:Spring SpringMVC Mybatis JSP MySQL 001 图书增删改查 SSM MySQL package com.demo.controller;import com.demo.pojo.Book; import com.demo.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.spri…

Uniapp + Vue3 + Pinia + Vant3 框架搭建

现在越来越多项目都偏向于Vue3开发&#xff0c;想着uniapp搭配Vue3试试效果怎么样&#xff0c;接下来就是详细操作步骤。 初始化Uniapp Vue3项目 App.vue setup语法 <script setup>import {onLaunch,onShow,onHide} from dcloudio/uni-apponLaunch(() > {console.l…

人工智能_机器学习072_SVM支持向量机_人脸识别模型训练_训练时间过长解决办法_数据降维_LFW人脸数据建模与C参数选择---人工智能工作笔记0112

我们先来看一下之前的代码: import numpy as np 导入数学计算库 from sklearn. svm import SVC 导入支持向量机 线性分类器 import matplotlib.pyplot as plt 加载人脸图片以后,我们用pyplot把人脸图片数据展示一下 from sklearn.model_selection import train_test_split 人脸…

Mysql-干净卸载教程

卸载 服务停掉 先把mysql服务停掉&#xff0c;如下点击右键&#xff0c;停止运行。 删除C盘内文件 接下来c盘里面的三个文件下的MySQL一一删除&#xff0c;需要注意的是 需要注意的是programdata文件下可能 隐藏了MySQL文件&#xff0c;所以可以在查看选项显示隐藏的文件。 …

032 - STM32学习笔记 - TIM基本定时器(一) - 定时器基本知识

032 - STM32学习笔记 - TIM定时器&#xff08;一&#xff09; - 基本定时器知识 这节开始学习一下TIM定时器功能&#xff0c;从字面意思上理解&#xff0c;定时器的基本功能就是用来定时&#xff0c;与定时器相结合&#xff0c;可以实现一些周期性的数据发送、采集等功能&#…

python实现批量替换目录下多个后缀为docx文档内容

批量替换目录下多个后缀为docx文档内容 摘要&#xff1a; 本文将介绍如何使用Python实现批量替换目录下多个后缀为docx文档内容。通过使用Python的os和glob模块&#xff0c;我们可以轻松地遍历目录下的所有文件&#xff0c;并对每个文件进行操作。此外&#xff0c;我们还将使用…

使用Ubuntu22+Minikube快速搭建K8S开发环境

安装Vmware 这一步&#xff0c;可以参考我的如下课程。 安装Ubuntu22 下载ISO镜像 这里我推荐从清华镜像源下载&#xff0c;速度会快非常多。 下载地址&#xff1a;https://mirrors.tuna.tsinghua.edu.cn/ubuntu-releases/22.04.3/ 如果你报名了我的这门视频课程&#xf…

【网络编程】网络通信基础——简述TCP/IP协议

个人主页&#xff1a;兜里有颗棉花糖 欢迎 点赞&#x1f44d; 收藏✨ 留言✉ 加关注&#x1f493;本文由 兜里有颗棉花糖 原创 收录于专栏【网络编程】【Java系列】 本专栏旨在分享学习网络编程的一点学习心得&#xff0c;欢迎大家在评论区交流讨论&#x1f48c; 目录 一、ip地…

26、湾湾国立阳明交通大学、湾湾长庚纪念医院提出:ALL Attention U-Net,独属头部CT分割的[玛格丽特]

本文由台湾国立阳明交通大学、台湾长庚纪念医院于2023年12月16日在arXiv<Image and Video Processing>发表。 论文地址&#xff1a; 2312.10483.pdf (arxiv.org) 0、Abstract 脑出血在 Head CT扫描中作为第一线工具&#xff0c;帮助专家诊断不同类型的出血。然而&…

AI技术图像编辑 Luminar Neo最新中文 for Mac

Luminar Neo是一款功能强大的AI智能图像处理工具&#xff0c;借助Luminar Neo领先的AI技术和灵活的工作流程&#xff0c;用户可以完成创意任务并获得专业品质的编辑结果。以下是该软件的主要特点和功能&#xff1a; 支持多种文件格式&#xff1a;Luminar Neo支持多种文件格式&…

Android模拟器的安装和adb连接

一、前置说明 APP 自动化可以使用真机进行测试&#xff0c;也可以使用模拟器来模拟安卓设备。我们可以根据个人喜好安装模拟器&#xff0c;个人推荐安装两款模拟器&#xff1a;网易 MuMu 模拟器、夜神模拟器。 MuMu模拟器可以支持 Android 12 版本&#xff0c;优点是&#xf…

docker-compaose部署openldap

前段时间在本地搭建了一套gitlab geo测试环境&#xff0c;因为需要集成ldap&#xff0c;所以特意搭建下&#xff0c;特此作为笔记记录下。 文章目录 1. 前置条件2. 编写docker-openldap.yml文件3. 登录4. 使用创建组创建用户登录测试 1. 前置条件 安装docker-compose 安装docke…

el-select绑定值的坑

碰到一个问题&#xff0c;选择框的数据是后端传过来的&#xff0c;下拉框的数据也是后端传过来的&#xff0c;但是打开下拉框时&#xff0c;发现数据没有高亮。 最后发现&#xff0c;只要选择框v-model给的值和option的value绑定的值一致&#xff0c;就可以高亮。 大多数情况下…

041_小驰私房菜_MTK平台添加支持通过原生Camera API接口调用UsbCamera

平台:MTK 问题:通过调用Android Camera API去调用UsbCamera,需要做哪些修改? Google官方文档,关于usbcamera的支持: 外接 USB 摄像头 | Android 开源项目 | Android Open Source Project 相关修改内容如下: 一、MTK平台支持通过标准接口打开USB Camera 1)device相…