银河麒麟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数据库