mysql 5.6.24 win32_mysql-5.6.24-win32解决没有my.ini并且修改编码
3.配置環境變量:新建一個系統變量:?MYSQL_HOME, 值:D:\MySql\mysql5611? //這一步不做也行
4.修改MySql啟動配置文件: 將安裝目錄下文件:my-default.ini 重命名為 my.ini
5.修改my.ini, 比如這個:
# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the
# and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M
basedir = E:\迅雷下載\mysql-5.6.24-win32.1432006610\mysql-5.6.24-win32
datadir = E:\迅雷下載\mysql-5.6.24-win32.1432006610\mysql-5.6.24-win32\data
default-storage-engine=MYISAM
port=3306
server-id=1
bind-address=0.0.0.0
character-set-server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
這里需要額外說明的是:
[mysql]
default-character-set=utf8
[mysqld] character-set-server=utf8
這兩個配置是為了保證中文的正常顯示,根據需要修改為你期望的字符編碼
[mysqld]
bind-address=0.0.0.0
這個配置是允許通過網絡遠程訪問mysql服務,如果不去要,請刪除此配置項,或者將地址改為:127.0.0.1
6.開始安裝MySql
a) 以管理員身份打開cmd,定位到安裝目錄/bin下
b) 執行安裝: mysqld --install MySql服務名
c) 啟動MySql服務: net start MySql服務名
如果你已經安裝了Mysql服務那就關閉Mysql服務按上述所說的修改my-default.ini文件之后再重啟Mysql服務就可以解決中文亂碼的問題了
終于成功了
另外,連接屬性->使用MySQL字符集是不用改的,保持默認設置就行。
具體可參考兩篇文章:http://blog.163.com/chenyao_2000/blog/static/1280109302011431476629/
http://www.cnblogs.com/northriver/archive/2013/06/07/3123385.html
總結
以上是生活随笔為你收集整理的mysql 5.6.24 win32_mysql-5.6.24-win32解决没有my.ini并且修改编码的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: mysql的存储引擎详解_Mysql存储
- 下一篇: mysql数据定义语句有哪些_MySQL