Home >Database >Mysql Tutorial >Mysql5.5中设置utf-8编码、大小写、root启动的问题_MySQL
Mysql5.5中设置utf-8编码、大小写、root启动的问题_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:35:171184browse
bitsCN.com
Mysql5.5中设置utf-8编码、大小写、root启动的问题
mysql5.1和之前的版本是在[mysqld]节点下添加
Java代码
default-character-set = utf8
5.5的mysql设置方式修改为
Java代码
character_set_server = utf8
配置文件文件仍旧为 /etc/my.cnf
如果文件不存在，可以从MYSQL解压目录/support-files/my-**.cnf重命名拷贝过去一个
注意权限问题
ubuntu直接用root启动mysqld会报错
应当使用
Java代码
/usr/local/mysql/bin/mysqld-safe --user=root &
这行命令来启动
linux下表名默认区分大小写，修改方式为在mysqld节点下添加
Java代码
lower_case_table_names=1
bitsCN.com
Statement：
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
Previous article：mysql查表语句_MySQLNext article：mysql导入导出表结构及表数据及执行sql文件_MySQL