java吧 关注:1,221,735贴子:12,677,343
  • 2回复贴,共1

Mysql安装后没有my.ini文件 设置编码无效

只看楼主收藏回复

我安装mysql之后只有mysql-default.ini 我按照网上的复制一份改名为my.ini启动服务时候就报错,而且我在my-default.ini设置编码 结果发现编码还是默认的,一点效果都没有,求教大神帮忙看看什么问题!!!!!!



IP属地:江苏1楼2015-08-19 10:32回复
    求教大神!!


    IP属地:江苏2楼2015-08-19 10:41
    回复
      # 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.
      #mysql根目录
      basedir =D:\mysql\mysql-5.6.24-winx64\
      #数据文件存放目录
      datadir =D:\mysql\mysql-5.6.24-winx64\data
      # port = 3306
      # server_id =9999
      # 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
      sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
      #服务端的编码方式
      character-set-server=utf8
      [client]
      #客户端编码方式,最好和服务端保存一致
      loose-default-character-set = utf8
      [WinMySQLadmin]
      Server =D:\mysql\mysql-5.6.24-winx64\bin\mysqld.exe
      本人 的my.ini 详情请看:http://pan.baidu.com/s/1sjsWfSh mysql配置


      3楼2015-08-21 20:34
      回复