文档章节

Mac修改MySQL编码

影狼
 影狼
发布于 2017/09/12 14:27
字数 717
阅读 22
收藏 0
  1. 查看当前MySQL编码:show variables like '%char%'; 
  2. 关闭MySQL服务
    1. 找到系统偏好设置 -> MySQL -> Stop MySQL Server
  3. 创建配置文件:vim /etc/my.cnf
  4. 写入下面内容:
    1. # Example MySQL config file for medium systems. 
      # 
      # This is for a system with little memory (32M - 64M) where MySQL plays 
      # an important part, or systems up to 128M where MySQL is used together with 
      # other programs (such as a web server) 
      # 
      # MySQL programs look for option files in a set of 
      # locations which depend on the deployment platform. 
      # You can copy this option file to one of those 
      # locations. For information about these locations, see: 
      # http://dev.mysql.com/doc/mysql/en/option-files.html 
      # 
      # In this file, you can use all long options that a program supports. 
      # If you want to know which options a program supports, run the program 
      # with the "--help" option. 
      # The following options will be passed to all MySQL clients 
      [client]
      default-character-set=utf8
      #password = your_password 
      port = 3306 
      socket = /tmp/mysql.sock 
      # Here follows entries for some specific programs 
      # The MySQL server 
      [mysqld]
      character-set-server=utf8
      init_connect='SET NAMES utf8
      port = 3306 
      socket = /tmp/mysql.sock 
      skip-external-locking 
      key_buffer_size = 16M 
      max_allowed_packet = 1M 
      table_open_cache = 64 
      sort_buffer_size = 512K 
      net_buffer_length = 8K 
      read_buffer_size = 256K 
      read_rnd_buffer_size = 512K 
      myisam_sort_buffer_size = 8M 
      character-set-server=utf8 
      init_connect='SET NAMES utf8' 
      # Don't listen on a TCP/IP port at all. This can be a security enhancement, 
      # if all processes that need to connect to mysqld run on the same host. 
      # All interaction with mysqld must be made via Unix sockets or named pipes. 
      # Note that using this option without enabling named pipes on Windows 
      # (via the "enable-named-pipe" option) will render mysqld useless! 
      # 
      #skip-networking
      
      # Replication Master Server (default) 
      # binary logging is required for replication 
      log-bin=mysql-bin
      
      # binary logging format - mixed recommended 
      binlog_format=mixed
      
      # required unique id between 1 and 2^32 - 1 
      # defaults to 1 if master-host is not set 
      # but will not function as a master if omitted 
      server-id = 1
      
      # Replication Slave (comment out master section to use this) 
      # 
      # To configure this host as a replication slave, you can choose between 
      # two methods : 
      # 
      # 1) Use the CHANGE MASTER TO command (fully described in our manual) - 
      # the syntax is: 
      # 
      # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, 
      # MASTER_USER=<user>, MASTER_PASSWORD=<password> ; 
      # 
      # where you replace <host>, <user>, <password> by quoted strings and 
      # <port> by the master's port number (3306 by default). 
      # 
      # Example: 
      # 
      # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, 
      # MASTER_USER='joe', MASTER_PASSWORD='secret'; 
      # 
      # OR 
      # 
      # 2) Set the variables below. However, in case you choose this method, then 
      # start replication for the first time (even unsuccessfully, for example 
      # if you mistyped the password in master-password and the slave fails to 
      # connect), the slave will create a master.info file, and any later 
      # change in this file to the variables' values below will be ignored and 
      # overridden by the content of the master.info file, unless you shutdown 
      # the slave server, delete master.info and restart the slaver server. 
      # For that reason, you may want to leave the lines below untouched 
      # (commented) and instead use CHANGE MASTER TO (see above) 
      # 
      # required unique id between 2 and 2^32 - 1 
      # (and different from the master) 
      # defaults to 2 if master-host is set 
      # but will not function as a slave if omitted 
      #server-id = 2 
      # 
      # The replication master for this slave - required 
      #master-host = <hostname> 
      # 
      # The username the slave will use for authentication when connecting 
      # to the master - required 
      #master-user = <username> 
      # 
      # The password the slave will authenticate with when connecting to 
      # the master - required 
      #master-password = <password> 
      # 
      # The port the master is listening on. 
      # optional - defaults to 3306 
      #master-port = <port> 
      # 
      # binary logging - not required for slaves, but recommended 
      #log-bin=mysql-bin
      
      # Uncomment the following if you are using InnoDB tables 
      #innodb_data_home_dir = /usr/local/mysql/data 
      #innodb_data_file_path = ibdata1:10M:autoextend 
      #innodb_log_group_home_dir = /usr/local/mysql/data 
      # You can set .._buffer_pool_size up to 50 - 80 % 
      # of RAM but beware of setting memory usage too high 
      #innodb_buffer_pool_size = 16M 
      #innodb_additional_mem_pool_size = 2M 
      # Set .._log_file_size to 25 % of buffer pool size 
      #innodb_log_file_size = 5M 
      #innodb_log_buffer_size = 8M 
      #innodb_flush_log_at_trx_commit = 1 
      #innodb_lock_wait_timeout = 50
      
      [mysqldump] 
      quick 
      max_allowed_packet = 16M
      
      [mysql] 
      no-auto-rehash 
      # Remove the next comment character if you are not familiar with SQL 
      #safe-updates 
      default-character-set=utf8
      
      [myisamchk] 
      key_buffer_size = 20M 
      sort_buffer_size = 20M 
      read_buffer = 2M 
      write_buffer = 2M
      
      [mysqlhotcopy] 
      interactive-timeout

       

  5. 启动MySQL服务,查看编码,已经修改。

© 著作权归作者所有

共有 人打赏支持
影狼
粉丝 31
博文 134
码字总数 66657
作品 0
海淀
程序员
mac下用python连接mysql

本文主要描述在mac系统下如何从安装到实现python到mysql的连接,并解决乱码问题。 整体流程(mac 自带python不用安装): 1、安装mysql(这里就直接发大神的安装教程帖子了:http://www.jian...

yuppy_zyp
2017/11/15
0
0
mysql 修改编码 Linux/Mac/Unix/通用(杜绝修改后无法启动的情况!)

修改mysql的编码需要用到myslq的配置文件,该文件在/etc/my.cnf,mac用户默认是没有这个文件的,可以到mysql的安装目录/support-files中找任意一个my-***.cnf拷贝到/ect中! 最近修改mysql的...

focusme
2013/05/28
0
0
过滤字符串中的Emoji表情[转]

iOS 5.0之前,苹果都是采用3个字节来承接 emoji 表情,Java 的普通 char 可以支持显示。但 iOS 5.0 之后, 苹果升级了系统自带的 emoji 表情输入法,用的 Unicode 6 标准来统一,是采用4个 ...

彭博
2013/04/08
37.5K
8
121 项目 011 周边向 查看和修改mysql 编码

Linux 平台 查看编码 修改编码 打开 /etc/my.cnf 在 [cient] 下添加: 在[mysqld] 下添加 最后的 my.cnf windows 平台 重装 mac 平台 首先,我需要一个苹果电脑 然后......

小代码2016
2016/09/28
3
0
JSP adbc tag 连接 MySQL 数据库中文变?

前言 我也不知道该怎么起标题了。这个标题大概就是我搜索错误是用到的关键词 最近在写 JSP。 昨天用到了数据库,但是遇到了一个超级崩溃的错误。 我的 SQL 语句中 如果出现了中文,在数据库中...

OSong
2017/12/02
0
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

Zookeeper总结

Zookeeper的部分概念 什么是zookeeeper? Zookeeper是一个分布式服务的协调中心 zookeeper节点的角色类型? Leader(领导者)、Follower(跟随者)、Observer(观察者) Leader 负责更新系统...

DemonsI
15分钟前
0
0
Redis学习笔记

常用命令 从Docker进入Redis的命令 sudo docker exec -it redis /bin/bash

OSC_fly
15分钟前
0
0
SqlServer查询某个日期的数据

select * from View_ZJMONITORINGCORROSION where ENTERDATE > CONVERT(datetime,DATEADD(day,1,'2017/12/28 14:53:07'))...

笑丶笑
16分钟前
0
0
常用编码规范

Standard characters https://ascii.cl/

yeahlife
18分钟前
0
0
flannel实战

docker swarm mode的出现是个里程碑,官方原生的编排调度看起来都成雏形了,但是swarm mode和容器外部系统的对接、网络性能始终不尽人意,swarm mode下各种开源周边不能使用,感觉swarm mod...

China_OS
20分钟前
0
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部