简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Linux系统下修改MySQL字符编码问题

WBOY
Release： 2016-06-07 16:51:50
Original
1080 people have browsed it

1.在Linux系统中找到MySQL的安装文件夹，找到里面的my.ini文件2.打开my.ini,里面有两处default-character-set 将[mysqld]上面的修

Linux系统下修改MySQL字符编码问题

[日期：2008-04-28] 来源：Linux公社  作者：Linux整理 [字体：]

1.在Linux系统中找到MySQL的安装文件夹，找到里面的my.ini文件

2.打开my.ini,里面有两处default-character-set

将[mysqld]上面的修改为gbk,下面的修改为utf8

3.重启服务即可。

linux

  • 0

    • Linux系统下手动安装pdo_mysql 成功

    Red Hat Linux 9上安装MYSQL“mysqld已死，，但是subsys被锁”的解决方案

    Related labels：
    linux mysql Linux系统下修改MySQL字符编
    source：php.cn
    Previous article：MySQL磁盘满repair多个表问题的解决 Next article：vb连接MySQL遇到的问题解决方法
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
    From 2024-04-06 21:44:19
    0
    1
    603
    Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
    From 2024-04-06 19:39:29
    0
    1
    441
    MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
    From 2024-04-06 19:25:54
    0
    2
    529
    How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
    From 2024-04-06 18:30:17
    0
    1
    353
    MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
    From 2024-04-06 18:42:44
    0
    2
    479
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn：Public welfare online PHP training，Help PHP learners grow quickly！