mysql永久更换字符集_请问 如何永久修改mysql字符集

展开全部

要设置Mysql的字符集，在PHP.ini文件中是办不到的，必须在 Mysql配置文件中修改e69da5e887aa62616964757a686964616f31333332616461

[my.ini]文件66行找，也可以搜索mysqld[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=3306

#Path to installation directory. All paths are usually resolved relative to this.

basedir="D:\AppServ/MySQL"

#Path to the database root

datadir="D:\AppServ/MySQL/data/"

# The default character set that will be used when a new schema or table is

# created and no character set is defined

default-character-set = utf8

character-set-server = utf8

collation-server = utf8_general_ci

init_connect = 'SET collation_connection = utf8_general_ci'

init_connect = 'SET NAMES utf8'