mysql for windows 解压版的安装 及常用配置

首先将mysql 的bin目录加入到系统环境变量的path中

mysqld --remove



mysqld --initialize-insecure  --explicit_defaults_for_timestamp

mysqld --install

net start mysql

mysql -uroot

mysql>set password for root@localhost=password('db2admin');

mysql>commit;

mysql>GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'db2admin' WITH GRANT OPTION;

mysql>FLUSH PRIVILEGES;

 

[mysqld]
# 以下用于规避function创建错误  （ERROR 1418）  http://blog.sina.com.cn/s/blog_6f68845001013k8a.html
log_bin_trust_function_creators = 1


# 以下用于突破索引长度不能超过767的限制
innodb_file_format = barracuda
innodb_file_per_table = true
innodb_large_prefix = true