文档章节

Mac修改MySQL编码

易冥天
 易冥天
发布于 2017/09/12 14:27
字数 717
阅读 23
收藏 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服务,查看编码,已经修改。

© 著作权归作者所有

共有 人打赏支持
易冥天
粉丝 30
博文 140
码字总数 70939
作品 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
121 项目 011 周边向 查看和修改mysql 编码

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

小代码2016
2016/09/28
3
0
Mac下安装mysql服务及基于workbench的使用方法

首先,Mac下安装Mysql服务及客户端的方式与Windows和Linux都是不一样的。 其次,mysql5.7的安装方式与之前版本的安装过程也有不同。 网上好多教程都不完整,下面是我安装mysql服务的完整过程...

孟飞阳
2016/07/23
2.4K
0
JSP adbc tag 连接 MySQL 数据库中文变?

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

OSong
2017/12/02
0
0

没有更多内容

加载失败,请刷新页面

加载更多

linux脚本中父shell与子shell 执行的几种方式

本文主要介绍以下几个命令的区别: shell subshell source $ (commond) `commond` Linux执行Scripts有两种方式,主要区别在于是否建立subshell 1. source filename or . filename 不创建sub...

问题终结者
18分钟前
1
0
安装jdk和Tomcat

12月12日任务 16.1 Tomcat介绍 16.2 安装jdk 16.3 安装Tomcat Tomcat介绍 Tomcat是apache软件基金会(Apache Software Foundation)的Jakarta项目中的一个核心项目,由apache、Sun和其他一些...

robertt15
19分钟前
3
0
Beetl 免费视频

来自 https://my.oschina.net/gking?q=Beetl ,Beetl终于有人录制视频了 项目git地址:https://gitee.com/gavink/beetl-blog 视频地址:下载下来会更清晰,视频比较长,可使用倍速看 百度网盘...

闲大赋
31分钟前
0
0
isEmpty和null的区别

isEmpty和null的区别: 1.一个是对象为空(IsNull),一个是值为空(IsEmpty) 2.IsNull指任务类型变量是否为空包括对象类型的变量。 IsNull函数: 功能:返回Boolean的值,指明表达是否不包...

DemonsI
57分钟前
3
0
Centos7 安装mysql与php

https://blog.csdn.net/qq_36431213/article/details/79576025 官网下载安装mysql-server 依次使用下面三个命令安装 wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.r......

Yao--靠自己
今天
2
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部