#======================================
#平台:windows7
#MYsql版本:mysql-5.5.62-winx64(安装版)
#MYsql工具:SQLyog - 64 bit、Navicat Premium 12
#======================================
(环境请自行搭建)
MySQL安装完毕后,首先找到它的配置文件:my.ini
(windows下默认位置在C:\Program Files\MySQL\MySQL Server 5.5\my.ini)
# CLIENT SECTION
2 # ----------------------------------------------------------------------
3 #
4 # The following options will be read by MySQL client applications.
5 # Note that only client applications shipped by MySQL are guaranteed
6 # to read this section. If you want your own MySQL client program to
7 # honor these values, you need to specify it as an option during the
8 # MySQL client library initialization.
9 #
10 [client]
11#客户端通过3306端口连接MySql服务器,可以直接修改
12 port=3306
13
14 [mysql]
15#客户端的默认字符集
16 default-character-set=gbk
1 # SERVER SECTION
2 # ----------------------------------------------------------------------
3 #
4 # The following options will be read by the MySQL Server. Make sure that
5 # you have installed the server correctly (see above) so it reads this
6 # file.
7 #
8 [mysqld]
9
10 # The TCP/IP Port the MySQL Server will listen on
11 port=3306
12#服务器端的端口号
13
14 #Path to installation directory. All paths are usually resolved relative to this.
#MySQL数据库服务器的安装目录
15 basedir="E:/Java/Mysql/"
16
17 #Path to the database root
#MYsql数据库文件目录
18 datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
19
20 # The default character set that will be used when a new schema or table is
21 # created and no character set is defined
#服务器端的默认字符集
22 character-set-server=gbk
23
24 # The default storage engine that will be used when create new tables when
#Mysql软件的存储引擎
25 default-storage-engine=INNODB
26
27 # Set the SQL mode to strict
28 sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
29
30 # The maximum amount of concurrent sessions the MySQL server will
31 # allow. One of these connections will be reserved for a user with
32 # SUPER privileges to allow the administrator to login even if the
33 # connection limit has been reached.
#MYsql软件的最大连接数
34 max_connections=10035...省略...
46
47 # The number of open tables for all threads. Increasing this value
48 # increases the number of file descriptors that mysqld requires.
49 # Therefore you have to make sure to set the amount of open files
50 # allowed to at least 4096 in the variable "open-files-limit" in
51 # section [mysqld_safe]
#表示所有进程打开表的总数
52 table_cache=25653...后面省略...