文档章节

Mac修改MySQL编码

影狼
 影狼
发布于 2017/09/12 14:27
字数 717
阅读 18
收藏 0
点赞 0
评论 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服务,查看编码,已经修改。

© 著作权归作者所有

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

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

yuppy_zyp ⋅ 2017/11/15 ⋅ 0

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

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

focusme ⋅ 2013/05/28 ⋅ 0

过滤字符串中的Emoji表情[转]

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

彭博 ⋅ 2013/04/08 ⋅ 8

121 项目 011 周边向 查看和修改mysql 编码

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

小代码2016 ⋅ 2016/09/28 ⋅ 0

JSP adbc tag 连接 MySQL 数据库中文变?

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

OSong ⋅ 2017/12/02 ⋅ 0

Mac下安装mysql服务及基于workbench的使用方法

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

孟飞阳 ⋅ 2016/07/23 ⋅ 0

MacOS下MySQL的安装、配置、删除

MacOS下,MySQL的安装方法和Linux下几乎一样,我这里安装后的目录是: /usr/local/mysql 安装之后,发现下面两个问题。 1. 中文乱码 这是由于默认安装的时候,数据库服务器用的是latin的编码...

K-X ⋅ 2012/06/30 ⋅ 3

python报错-安装 mysql5.7.20 遇到的各种问题

Mac平台重新设置MySQL的root密码 您是否忘记了Mac OS 的MySQL的root密码? 通过以下4步就可重新设置新密码: 停止 . 通常是在 '系统偏好设置' > MySQL > 'Stop MySQL Server' 打开终端,输入:...

时间之友 ⋅ 2017/12/10 ⋅ 0

搭建Mysql数据库

**使用Mysql数据库的好处:1.使用C和C++编程语言编写,且可以使用多种编译器进行测试,保证源代码的可移植性,安装简单小巧。2.支持AIX、FreeBSD、HP-UX、Linux、Mac OS、NovellNetware、Ope...

曹歆博 ⋅ 01/04 ⋅ 0

入门学习 安装Ofbiz 12 (mac os x)

本人系统环境 os x 10.9 、jdk1.6、mysql5.5 1、在官方网站上下载ofbiz 版本12.02 下载地址 http://www.apache.org/dyn/closer.cgi/ofbiz/apache-ofbiz-12.04.02.zip 2、对下载文件进行解压 ...

小鲅鱼 ⋅ 2014/02/25 ⋅ 1

没有更多内容

加载失败,请刷新页面

加载更多

下一页

zblog2.3版本的asp系统是否可以超越卢松松博客的流量[图]

最近访问zblog官网,发现zlbog-asp2.3版本已经进入测试阶段了,虽然正式版还没有发布,想必也不久了。那么作为aps纵横江湖十多年的今天,blog2.2版本应该已经成熟了,为什么还要发布这个2.3...

原创小博客 ⋅ 23分钟前 ⋅ 0

聊聊spring cloud的HystrixCircuitBreakerConfiguration

序 本文主要研究一下spring cloud的HystrixCircuitBreakerConfiguration HystrixCircuitBreakerConfiguration spring-cloud-netflix-core-2.0.0.RELEASE-sources.jar!/org/springframework/......

go4it ⋅ 47分钟前 ⋅ 0

二分查找

二分查找,也称折半查找、二分搜索,是一种在有序数组中查找某一特定元素的搜索算法。搜素过程从数组的中间元素开始,如果中间元素正好是要查找的元素,则搜素过程结束;如果某一特定元素大于...

人觉非常君 ⋅ 今天 ⋅ 0

VS中使用X64汇编

需要注意的是,在X86项目中,可以使用__asm{}来嵌入汇编代码,但是在X64项目中,再也不能使用__asm{}来编写嵌入式汇编程序了,必须使用专门的.asm汇编文件来编写相应的汇编代码,然后在其它地...

simpower ⋅ 今天 ⋅ 0

ThreadPoolExecutor

ThreadPoolExecutor public ThreadPoolExecutor(int corePoolSize, int maximumPoolSize, long keepAliveTime, ......

4rnold ⋅ 昨天 ⋅ 0

Java正无穷大、负无穷大以及NaN

问题来源:用Java代码写了一个计算公式,包含除法和对数和取反,在页面上出现了-infinity,不知道这是什么问题,网上找答案才明白意思是负的无穷大。 思考:为什么会出现这种情况呢?这是哪里...

young_chen ⋅ 昨天 ⋅ 0

前台对中文编码,后台解码

前台:encodeURI(sbzt) 后台:String param = URLDecoder.decode(sbzt,"UTF-8");

west_coast ⋅ 昨天 ⋅ 0

实验楼—MySQL基础课程-挑战3实验报告

按照文档要求创建数据库 sudo sercice mysql startwget http://labfile.oss.aliyuncs.com/courses/9/createdb2.sqlvim /home/shiyanlou/createdb2.sql#查看下数据库代码 代码创建了grade......

zhangjin7 ⋅ 昨天 ⋅ 0

一起读书《深入浅出nodejs》-node模块机制

node 模块机制 前言 说到node,就不免得提到JavaScript。JavaScript自诞生以来,经历了工具类库、组件库、前端框架、前端应用的变迁。通过无数开发人员的努力,JavaScript不断被类聚和抽象,...

小草先森 ⋅ 昨天 ⋅ 0

Java桌球小游戏

其实算不上一个游戏,就是两张图片,不停的重画,改变ball图片的位置。一个左右直线碰撞的,一个有角度碰撞的。 左右直线碰撞 package com.bjsxt.test;import javax.swing.*;import j...

森林之下 ⋅ 昨天 ⋅ 0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部