[mysql]

default-character-set=utf8

[mysqld]

# 关闭域名反解

skip_name_resolve

# 每表一个独立的表空间文件(推荐)

innodb_file_per_table

# 设定数据目录位置

datadir="D:/MySQL5.5/Data/"

# 设定服务器的字符编码

character-set-server=utf8

# 默认使用的存储引擎

default-storage-engine=INNODB

# 设置InnoDB表空间文件的存储路径

innodb_data_home_dir="D:/MySQL5.5/InnoDB"

SELECT User,Host,Password FROM mysql.user;

UPDATE mysql.user SET Password=PASSWORD('redhat') WHERE user='root';

DROP USER ''@localhost;

DROP USER ''@'localhost.localdomain';