Mysql相关配置

#mysql配置文件(windows)
[mysql]
default-character-set=utf8

[mysqld]
basedir=D:\\ProgramFiles\\Mysql
datadir=D:\\ProgramFiles\\Mysql\\data
max_connections=200             
character-set-server=utf8
default-storage-engine=INNODB
default-time_zone='+8:00'

[mysqldump]
default-character-set=utf8

#mysql配置文件(linux)
[mysql]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8

symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#mysql四种语言
数据定义语言 create,drop,alter
数据操作语言 insert,delete,update
数据查询语言 select
数据控制语言 grant,revoke,commit,rollback