2 mysql安装

已于 2023-11-26 17:39:46 修改
阅读量388 收藏 5
点赞数 8
分类专栏： kafka安装 文章标签： mysql 数据库
于 2023-11-26 17:15:32 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_37057214/article/details/134630078
版权

2 mysql

2.1 下载

MySQL :: Download MySQL Community Server (Archived Versions)

2.2 处理原始环境

[root@kafka ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@kafka ~]# yum remove mariadb-libs* -y
已加载插件：fastestmirror
正在解决依赖关系
--> 正在检查事务
---> 软件包 mariadb-libs.x86_64.1.5.5.68-1.el7 将被 删除
--> 正在处理依赖关系 libmysqlclient.so.18()(64bit)，它被软件包 2:postfix-2.10.1-9.el7.x86_64 需要
--> 正在处理依赖关系 libmysqlclient.so.18(libmysqlclient_18)(64bit)，它被软件包 2:postfix-2.10.1-9.el7.x86_64 需要
--> 正在检查事务
---> 软件包 postfix.x86_64.2.2.10.1-9.el7 将被 删除
--> 解决依赖关系完成

依赖关系解决

=================================================================================================================================================================================================================
 Package                                             架构                                          版本                                                   源                                                大小
=================================================================================================================================================================================================================
正在删除:
 mariadb-libs                                        x86_64                                        1:5.5.68-1.el7                                         @anaconda                                        4.4 M
为依赖而移除:
 postfix                                             x86_64                                        2:2.10.1-9.el7                                         @anaconda                                         12 M

事务概要
=================================================================================================================================================================================================================
移除  1 软件包 (+1 依赖软件包)

安装大小：17 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在删除    : 2:postfix-2.10.1-9.el7.x86_64                                                                                                                                                                1/2 
  正在删除    : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                           2/2 
  验证中      : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                           1/2 
  验证中      : 2:postfix-2.10.1-9.el7.x86_64                                                                                                                                                                2/2 

删除:
  mariadb-libs.x86_64 1:5.5.68-1.el7                                                                                                                                                                             

作为依赖被删除:
  postfix.x86_64 2:2.10.1-9.el7                                                                                                                                                                                  

完毕！
[root@kafka ~]#

2.3 安装

上传压缩包到/root/software目录下

[root@kafka ~]# ll /root/software/
总用量 958312
-rw-r--r--. 1 root root  14853274 11月 23 02:20 apache-zookeeper-3.8.3-bin.tar.gz
-rw-r--r--. 1 root root 113400977 11月 22 22:05 kafka_2.12-3.6.0.tgz
-rw-r--r--. 1 root root  89962364 11月 22 23:37 kafka-eagle-bin-3.0.1.tar.gz
-rw-r--r--. 1 root root 660017902 11月 26 15:48 mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
-rw-r--r--. 1 root root 103063877 11月 22 17:19 OpenJDK8U-jdk_x64_linux_hotspot_8u322b06.tar.gz

解压至/opt/mysql目录下

[root@kafka ~]# mkdir -p /opt/mysql
[root@kafka ~]# tar -zxvf /root/software/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /opt/mysql
mysql-5.7.30-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-5.7.30-linux-glibc2.12-x86_64/bin/myisamchk
mysql-5.7.30-linux-glibc2.12-x86_64/bin/myisamlog
mysql-5.7.30-linux-glibc2.12-x86_64/bin/myisampack
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_client_test_embedded
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_config_editor
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_embedded
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_install_db
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_plugin
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_secure_installation
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_ssl_rsa_setup
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_tzinfo_to_sql
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_upgrade
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqladmin
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlbinlog
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlcheck
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqldump
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlimport
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlpump
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlshow
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlslap
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqltest_embedded
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqlxtest
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld-debug
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqld-debug.a
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysqlx_ername.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysqlx_error.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysqlx_version.h
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysql_config
mysql-5.7.30-linux-glibc2.12-x86_64/include/big_endian.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/binary_log_types.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/byte_order_generic.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/byte_order_generic_x86.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/decimal.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/errmsg.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/keycache.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/little_endian.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/m_ctype.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/m_string.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_alloc.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_byteorder.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_command.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_compiler.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_config.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_dbug.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_dir.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_getopt.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_global.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_list.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_sys.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_thread.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_thread_local.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/my_xml.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/client_authentication.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/client_plugin.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/client_plugin.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/com_data.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/get_password.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/group_replication_priv.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/innodb_priv.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/mysql_lex_string.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_audit.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_audit.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_auth.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_auth.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_auth_common.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_ftparser.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_ftparser.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_group_replication.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_keyring.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_keyring.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_trace.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/plugin_validate_password.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_file.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_idle.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_mdl.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_memory.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_ps.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_socket.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_sp.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_stage.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_statement.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_table.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_thread.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/mysql_transaction.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/psi.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/psi_base.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/psi/psi_memory.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_command.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_locking.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_my_plugin_log.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_my_snprintf.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_mysql_alloc.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_mysql_keyring.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_mysql_password_policy.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_mysql_string.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_parser.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_rpl_transaction_ctx.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_rpl_transaction_write_set.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_rules_table.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_security_context.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_srv_session.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_srv_session_info.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_ssl_wrapper.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_thd_alloc.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_thd_engine_lock.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_thd_wait.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/service_thread_scheduler.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/services.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/services.h.pp
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/thread_pool_priv.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql/thread_type.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql_com.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql_com_server.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql_embed.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql_time.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysql_version.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysqld_ername.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin_audit.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin_ftparser.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin_group_replication.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin_keyring.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/plugin_validate_password.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/sql_common.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/sql_state.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/sslopt-case.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/sslopt-longopts.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/sslopt-vars.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/thr_cond.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/thr_mutex.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/thr_rwlock.h
mysql-5.7.30-linux-glibc2.12-x86_64/include/typelib.h
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqlclient.a
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqlservices.a
mysql-5.7.30-linux-glibc2.12-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-5.7.30-linux-glibc2.12-x86_64/share/aclocal/mysql.m4
mysql-5.7.30-linux-glibc2.12-x86_64/docs/ChangeLog
mysql-5.7.30-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqld.a
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/comp_err.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/innochecksum.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/lz4_decompress.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/my_print_defaults.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/myisam_ftdump.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/myisamchk.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/myisamlog.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/myisampack.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql.server.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_config.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_config_editor.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_install_db.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_plugin.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_secure_installation.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysql_upgrade.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqladmin.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlbinlog.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlcheck.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlimport.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlman.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlpump.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlshow.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/mysqlslap.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/perror.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/replace.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/resolve_stack_dump.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/resolveip.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man1/zlib_decompress.1
mysql-5.7.30-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-5.7.30-linux-glibc2.12-x86_64/LICENSE
mysql-5.7.30-linux-glibc2.12-x86_64/README
mysql-5.7.30-linux-glibc2.12-x86_64/bin/innochecksum
mysql-5.7.30-linux-glibc2.12-x86_64/bin/lz4_decompress
mysql-5.7.30-linux-glibc2.12-x86_64/bin/my_print_defaults
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-5.7.30-linux-glibc2.12-x86_64/bin/perror
mysql-5.7.30-linux-glibc2.12-x86_64/bin/replace
mysql-5.7.30-linux-glibc2.12-x86_64/bin/resolve_stack_dump
mysql-5.7.30-linux-glibc2.12-x86_64/bin/resolveip
mysql-5.7.30-linux-glibc2.12-x86_64/bin/zlib_decompress
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/matrix.bin
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/pos-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/rewrite.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/right-id.def
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/sys.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_utf-8/unk.dic
mysql-5.7.30-linux-glibc2.12-x86_64/lib/mecab/etc/mecabrc
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/adt_null.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/auth_socket.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/connection_control.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/adt_null.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/auth_socket.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/authentication_ldap_sasl_client.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/connection_control.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/group_replication.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/ha_example.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/innodb_engine.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_file.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/keyring_udf.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libmemcached.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libpluginmecab.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_framework.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_services.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_services_threaded.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_session_detach.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_session_in_thd.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_session_info.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_2_sessions.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_all_col_types.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_cmds_1.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_commit.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_complex.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_errors.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_lock.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_processlist.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_replication.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_shutdown.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_sqlmode.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_stored_procedures_functions.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_sql_views_triggers.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_x_sessions_deinit.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/libtest_x_sessions_init.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/locking_service.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/mypluglib.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/mysql_no_login.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/mysqlx.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/rewrite_example.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/rewriter.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_master.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/semisync_slave.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/test_security_context.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/test_udf_services.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/validate_password.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/debug/version_token.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/group_replication.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/ha_example.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/innodb_engine.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/keyring_file.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/keyring_udf.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libmemcached.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libpluginmecab.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_framework.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_services.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_services_threaded.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_session_detach.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_session_in_thd.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_session_info.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_2_sessions.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_all_col_types.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_cmds_1.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_commit.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_complex.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_errors.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_lock.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_processlist.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_replication.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_shutdown.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_sqlmode.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_stored_procedures_functions.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_sql_views_triggers.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_x_sessions_deinit.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/libtest_x_sessions_init.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/locking_service.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/mypluglib.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/mysql_no_login.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/mysqlx.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/rewrite_example.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/rewriter.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/semisync_master.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/semisync_slave.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/test_security_context.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/test_udf_services.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/validate_password.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/plugin/version_token.so
mysql-5.7.30-linux-glibc2.12-x86_64/share/bulgarian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/Index.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/README
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/armscii8.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/ascii.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp1250.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp1251.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp1256.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp1257.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp850.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp852.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/cp866.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/dec8.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/geostd8.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/greek.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/hebrew.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/hp8.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/keybcs2.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/koi8r.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/koi8u.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/latin1.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/latin2.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/latin5.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/latin7.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/macce.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/macroman.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/charsets/swe7.xml
mysql-5.7.30-linux-glibc2.12-x86_64/share/czech/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/danish/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/dictionary.txt
mysql-5.7.30-linux-glibc2.12-x86_64/share/dutch/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/english/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/errmsg-utf8.txt
mysql-5.7.30-linux-glibc2.12-x86_64/share/estonian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/fill_help_tables.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/french/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/german/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/greek/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/hungarian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/innodb_memcached_config.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/italian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/japanese/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/korean/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/mysql_security_commands.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/mysql_sys_schema.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/mysql_system_tables.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/mysql_system_tables_data.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/mysql_test_data_timezone.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/norwegian-ny/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/norwegian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/polish/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/portuguese/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/romanian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/russian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/serbian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/slovak/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/spanish/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/swedish/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/share/ukrainian/errmsg.sys
mysql-5.7.30-linux-glibc2.12-x86_64/support-files/mysql-log-rotate
mysql-5.7.30-linux-glibc2.12-x86_64/support-files/mysqld_multi.server
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqlclient.so
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqlclient.so.20
mysql-5.7.30-linux-glibc2.12-x86_64/lib/libmysqlclient.so.20.3.17
mysql-5.7.30-linux-glibc2.12-x86_64/share/install_rewriter.sql
mysql-5.7.30-linux-glibc2.12-x86_64/share/uninstall_rewriter.sql
mysql-5.7.30-linux-glibc2.12-x86_64/support-files/magic
mysql-5.7.30-linux-glibc2.12-x86_64/support-files/mysql.server
mysql-5.7.30-linux-glibc2.12-x86_64/docs/INFO_BIN
mysql-5.7.30-linux-glibc2.12-x86_64/docs/INFO_SRC
您在 /var/spool/mail/root 中有新邮件
[root@kafka ~]#

2.4 设置环境变量

添加MYSQL_HOME

[root@kafka ~]# vi /etc/profile
[root@kafka ~]# source /etc/profile
[root@kafka ~]# mysql -V
mysql  Ver 14.14 Distrib 5.7.30, for linux-glibc2.12 (x86_64) using  EditLine wrapper

在这里插入图片描述

2.5 初始化

此时初始化会有个默认密码：Tw+s/gUfu0+k，需要记住，后面登录有用到

[root@kafka ~]# mkdir -p /usr/local/mysql/data/
[root@kafka ~]# mysqld --initialize
2023-11-26T08:13:56.943774Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-11-26T08:13:56.944101Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-11-26T08:13:57.261665Z 0 [Warning] InnoDB: New log files created, LSN=45790
2023-11-26T08:13:57.307169Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-11-26T08:13:57.378914Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: bf2ea0b6-8c33-11ee-b76c-000c2917916a.
2023-11-26T08:13:57.399557Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-11-26T08:13:58.226895Z 0 [Warning] CA certificate ca.pem is self signed.
2023-11-26T08:13:58.333449Z 1 [Note] A temporary password is generated for root@localhost: Tw+s/gUfu0+k
[root@kafka ~]#

2.6 准备配置文件

[root@kafka ~]# cat >/etc/my.cnf <<EOF
> [mysqld]
> user=root
> basedir=/opt/mysql/mysql-5.7.30-linux-glibc2.12-x86_64
> datadir=/usr/local/mysql/data/
> socket=/tmp/mysql.sock
> server_id=6
> port=3306
> [mysql]
> socket=/tmp/mysql.sock
> EOF
[root@kafka ~]#

2.7 设置systemd启动方式

[root@kafka ~]# cat >/etc/systemd/system/mysqld.service <<EOF
> [Unit]
> Description=MySQL Server
> Documentation=man:mysqld(8)
> Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
> After=network.target
> After=syslog.target
> [Install]
> WantedBy=multi-user.target
> [Service]
> User=root
> Group=root
> ExecStart=/opt/mysql/mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld --defaults-file=/etc/my.cnf
> LimitNOFILE = 5000
> EOF
[root@kafka ~]# systemctl daemon-reload

2.8 启动服务

[root@kafka ~]# systemctl start mysqld
[root@kafka ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/etc/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: active (running) since 日 2023-11-26 16:41:32 CST; 2s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
 Main PID: 38133 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─38133 /opt/mysql/mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld --defaults-file=/etc/my.cnf

11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.725817Z 0 [Warning] CA certificate ca.pem is self signed.
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.725879Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.727468Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.728488Z 0 [Note] IPv6 is available.
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.728592Z 0 [Note]   - '::' resolves to '::';
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.728636Z 0 [Note] Server socket created on IP: '::'.
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.771716Z 0 [Note] Failed to start slave threads for channel ''
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.850429Z 0 [Note] Event Scheduler: Loaded 0 events
11月 26 16:41:33 kafka mysqld[38133]: 2023-11-26T08:41:33.856499Z 0 [Note] /opt/mysql/mysql-5.7.30-linux-glibc2.12-x86_64/bin/mysqld: ready for connections.
11月 26 16:41:33 kafka mysqld[38133]: Version: '5.7.30'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
[root@kafka ~]#

2.9 登录数据库并修改密码

[root@kafka ~]# mysql -u root -pTw+s/gUfu0+k
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.30

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

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

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

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user root@'localhost' identified by '123456';
Query OK, 0 rows affected (0.04 sec)

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.06 sec)

mysql> select host,user from mysql.user;
+-----------+---------------+
| host      | user          |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | root          |
+-----------+---------------+
3 rows in set (0.03 sec)

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

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)

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

mysql> quit
Bye
#重新登录用密码“123456”
[root@kafka ~]# mysql -u root -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.30 MySQL Community Server (GPL)

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

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

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

mysql>

2.10 用客户端进行连接测试

在这里插入图片描述
在这里插入图片描述

笑丶科技
关注
专栏目录
mysql2安装与使用
weixin_54645137的博客
03-29 3291
nodejs中mysql2模块 安装 npm i mysql2 -S 使用 const mysql2 = require("mysql2"); 配置和数据库之间的连接 const connection = mysql2.createConnection({ host: 'localhost', //主机 user: "root", //用户名 password: "102327", //自己设置的密码 database: "js05", //表名 charset:
MySQL-2-MySQL下载与安装
qq_22938603的博客
01-24 416
<1>MySQL版本: MySQL Community Server 社区版本，开源免费，自由下载，但不提供官方技术支持，适用于 大多数普通用户。 MySQL Enterprise Edition 企业版本，需付费，不能在线下载，可以试用30天。提供了更多的 功能和更完备的技术支持，更适合于对数据库的功能和可靠性要求较高的企业客户。 MySQL Cluster 集群版，开源免费。用于架设集群服务器，可将几个MySQL Server封装成一个 Server。需要在社区版或企业版的基础上
mysql-2:安装mysql
最新发布
陈小陈的博客
09-05 383
注：如果连接不上，可以按以下步骤排错。
MySQL 二 安装
W_H_M_2018的博客
10-26 125
Table of Contents MySQL安装 Linux/UNIX 上安装 MySQL 验证 MySQL 安装 使用 MySQL Client(Mysql客户端) 执行简单的SQL命令 Mysql安装后需要做的 Windows 上安装 MySQL 登录 MySQL MySQL安装 所有平台的 MySQL 下载地址为：MySQL 下载。 挑选你需要的MySQL Community Server版本及对应的平台。 注意：安装过程我们需要通过开启管理员权限来安装，否则会由于...
MySQL2
sunv_lx的博客
12-20 305
SQL
mysql2
qq_68932428的博客
07-25 87
查询
MySQL安装配置教程（超级详细、保姆级）
热门推荐
Soloversion的博客
03-26 42万+
一、 下载MySQL Mysql官网下载地址https://downloads.mysql.com/archives/installer/ 1. 选择想要安装的版本，本篇文章选择的是5.7.31版本，下面的那个文件，点击Download下载 二、 安装MySQL 1. 选择设置类型 双击运行mysql-installer-community-5.7.31.0.msi 这里选择是自定义安装，所以直接选择“Custom”，点击“Next” “Developer Default”是开发者默认
SUSE12-SP2 mysql安装
Kaylee_123的博客
01-03 2569
1. 下载mysql安装包 官方下载地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads 2. 将安装包上传到指定位置 #mkdir /opt/mysql #cd /opt/mysql #ls 3. 解压安装包 4. 卸载SUSE自带的mariadb   用rpm -e卸载即可 5. 安装mysq...
MySQL安装配置教程（超级详细）
fwdwqdwq的博客
08-02 8万+
2.选择安装的产品和功能依次点开“MySQLServers”、“MySQLServers”、“MySQLServers5.7”、“MySQLServers5.7.31-64”，然后点击绿色箭头将选中的版本移植到右边选中框中。9.先选中“MySQLServer5.7.31”，若电脑中没有这个环境，会提示安装“MicrosoftVisualC++2013”环境，点击“Execute”5.点击“新建”，将MySQL的安装路径添加上去，之后点击“确定”...
mysql custom安装_MySQL安装步骤详解
weixin_39724441的博客
02-07 1922
一、MYSQL的安装１、打开下载的mysql安装文件mysql-5.5.27-win32.zip，双击解压缩，运行“setup.exe”。 ２、选择安装类型，有“Typical(默认)”、“Complete(完全)”、“Custom(用户自定义)”三个选项，选择“Custom”，按“next”键继续。 ３、点选“Browse”，手动指定安装目录。 ４、填上安装目录，我的是“F:\Server\M...
linux安装配置Mysql详细步骤
王佳斌
06-14 7万+
下载Mysql rpm包 官网下载：https://dev.mysql.com/downloads/mysql/ 如果你到了这里，本地应该有了如下四个rpm包： mysql-community-client-5.7.26-1.el6.x86_64.rpm mysql-community-common-5.7.26-1.el6.x86_64.rpm mysql-community-libs-5...
mysql2教程_mySQL 教程 第2章 安装和介绍mySQL
weixin_34082213的博客
01-25 144
设置mySQL字符集支持中文的字符集是utf8，该设置可以更改mySQL配置文件进行全局设置，也可以针对数据库设置，也可以针对表设置，也可以针对列设置。字符集更改后新插入的数据生效，对以前不生效。练习1：更改MySQL的默认字符集直接修改 my.cnf，增加一行内容，然后重启 MySQL，使之全局生效，影响新建的所有数据库。default-character-set = utf8重启mySQL服务...
mysql2_mysql2
weixin_42531710的博客
02-27 55
视图视图是一个虚拟表，其本质是【根据SQL语句获取动态的数据集，并为其命名】，用户使用时只需要使用【名称】即可获取结果集，并可以将其当做表来使用。select * from (select nid,name from tb1 where nid >2) as A where A.name > 'alex'1.创建视图--格式：create view 视图名称 as SQL语句eg:cr...
安装mysql 2._2 MySQL安装
weixin_42121272的博客
01-19 122
目录：1. mysql安装简介2. 下载AppServ3. 安装AppServ4. 使用phpmyadmin连接MySQL5. 使用MySQL Command Line Client 连接MySQL1. mysql安装简介简单查看了win7下MySQL的安装教程，单独安装配置都显得比较麻烦。而安装配置的繁琐过程不是学习MySQL的重点，但这却是最消耗入门同学学习兴趣的一部分。上文提到LAMP的开发...
MySQL5.7安装步骤详解
2. 运行MySQL安装程序，接受许可协议，选择典型安装。 3. 设置MySQL服务器的配置，如端口和用户账号。 4. 配置并启动MySQL服务。 5. 使用命令行工具或MySQL提供的其他客户端进行数据库操作。 对于初学者，了解并...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值