找到MySQL安装的根目录底下的my.ini文件
[client]
port=3306
[mysql]
default-character-set=utf8
上面显示的是客户端的参数,[client]和[mysql]都是客户端
port:MySQL数据库端口号,默认是3306,如果需要修改端口号,可以通过这里修改
default-character-set:MySQL默认字符集,如果希望支持中文,可以改成gbk或utf8
[mysqld]
# 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="F:/Program Files (x86)/MySQL/MySQL Server 5.5/"#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/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=utf8# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
[mysqld]往下就是服务端的参数,下面介绍一些常用的参数
port:数据库端口号
basedir:MySQL的安装路径
datadir:表示MySQL数据文件的存储位置,也是数据库表的存放位置。
default-character-server:服务端默认字符集
default-storage-engine:默认的存储引擎,用来执行SQL语句