MySql简单安装与配置

MySql安装

这里介绍的是便携版安装配置 便携版下载地址
官方提供有安装版, 简单方便 安装版下载地址

官方配置文档

1. my.ini

2. # Other default tuning values
   # MySQL Server Instance Configuration File
   # ----------------------------------------------------------------------
   # Generated by the MySQL Server Instance Configuration Wizard
   #
   #
   # Installation Instructions
   # ----------------------------------------------------------------------
   #
   # On Linux you can copy this file to /etc/my.cnf to set global options,
   # mysql-data-dir/my.cnf to set server-specific options
   # (@localstatedir@ for this installation) or to
   # ~/.my.cnf to set user-specific options.
   #
   # On Windows you should keep this file in the installation directory 
   # of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
   # make sure the server reads the config file use the startup option 
   # "--defaults-file". 
   #
   # To run the server from the command line, execute this in a 
   # command line shell, e.g.
   # mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
   #
   # To install the server as a Windows service manually, execute this in a 
   # command line shell, e.g.
   # mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
   #
   # And then execute this in a command line shell to start the server, e.g.
   # net start MySQLXY
   #
   #
   # Guidelines for editing this file
   # ----------------------------------------------------------------------
   #
   # In this file, you can use all long options that the program supports.
   # If you want to know the options a program supports, start the program
   # with the "--help" option.
   #
   # More detailed information about the individual options can also be
   # found in the manual.
   #
   # For advice on how to change settings please see
   # https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
   #
   #
   # CLIENT SECTION
   # ----------------------------------------------------------------------
   #
   # The following options will be read by MySQL client applications.
   # Note that only client applications shipped by MySQL are guaranteed
   # to read this section. If you want your own MySQL client program to
   # honor these values, you need to specify it as an option during the
   # MySQL client library initialization.
   #
   [client]
   
   # pipe=
   
   # socket=MYSQL
   
   port=3306
   
   [mysql]
   no-beep
   
   # default-character-set=
   
   # SERVER SECTION
   # ----------------------------------------------------------------------
   #
   # The following options will be read by the MySQL Server. Make sure that
   # you have installed the server correctly (see above) so it reads this 
   # file.
   #
   # server_type=3
   [mysqld]
   
   # The next three options are mutually exclusive to SERVER_PORT below.
   # skip-networking
   # enable-named-pipe
   # shared-memory
   
   # shared-memory-base-name=MYSQL
   
   # The Pipe the MySQL Server will use
   # socket=MYSQL
   
   # The TCP/IP Port the MySQL Server will listen on
   port=3306
   
   # Path to installation directory. All paths are usually resolved relative to this.
   # basedir="C:/Program Files/MySQL/MySQL Server 8.0/"
   
   # Path to the database root
   # datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data
   
   # The default character set that will be used when a new schema or table is
   # created and no character set is defined
   # character-set-server=
   
   # The default authentication plugin to be used when connecting to the server
   default_authentication_plugin=caching_sha2_password
   
   # The default storage engine that will be used when create new tables when
   default-storage-engine=INNODB
   
   # Set the SQL mode to strict
   sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
   
   # General and Slow logging.
   log-output=FILE
   
   general-log=0
   
   general_log_file="DESKTOP-KT95ASM.log"
   
   slow-query-log=1
   
   slow_query_log_file="DESKTOP-KT95ASM-slow.log"
   
   long_query_time=10
   
   # Error Logging.
   log-error="DESKTOP-KT95ASM.err"
   
   # ***** Group