Mysql配置

一、步骤

  1. 安装：mysqld -install
  2. 1、在命令行中输入“mysql -uroot -p”(不输入密码)，回车即可进入数据库。
  3. 2、执行，“use mysql;”使用mysql数据库。
  4. 3、执行，“update user set password=PASSWORD("rootadmin") where user='root';”（修改root的密码）

二、my.ini文件:

  1. **# For advice on how to change settings please see**
  2. **# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html**
  3. **# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the**
  4. **# *** default location during install, and will be replaced if you**
  5. **# *** upgrade to a newer version of MySQL.**
  7. **[client]**
  8. **port=3306**
  9. **default-character-set=utf8**
  11. **[mysqld]**
  12. **port=3306**
  13. **character_set_server=utf8**
  14. **# Remove leading # and set to the amount of RAM for the most important data**
  15. **# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.**
  16. **#innodb_buffer_pool_size = 128M**
  18. **# Remove leading # to turn on a very important data integrity option: logging**
  19. **# changes to the binary log between backups.**
  20. **# log_bin**
  22. **# These are commonly set, remove the # and set as required.**
  23. **basedir = C:/server/server/sql/mysql**
  24. **datadir = C:/server/server/sql/mysql/data**
  25. **#port = 3306**
  26. **#server_id = 1**
  27. **#default-storage-engine=INNODB**
  29. **# Remove leading # to set options mainly useful for reporting servers.**
  30. **# The server defaults are faster for transactions and fast SELECTs.**
  31. **# Adjust sizes as needed, experiment to find the optimal values.**
  32. **#join_buffer_size = 128M**
  33. **#sort_buffer_size = 2M**
  34. **#read_rnd_buffer_size = 2M **
  36. **sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES **
  37. **[WinMySQLAdmin]**

C:\server\server\sql\mysql\binmysqld.exe