CentOS 下的MySQL配置

最新推荐文章于 2025-09-13 19:07:06 发布

转载最新推荐文章于 2025-09-13 19:07:06 发布 · 59 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/benbenduo/p/3852771.html

文章标签：

#数据库

本文详细介绍了MySQL配置文件my.cnf的设置方法，包括如何修改字符集、调整内存参数等，并提供了具体的配置示例及步骤。

先贴出代码（/etc/my.cnf）如下：

#The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock
default_character_set=utf8 --编码问题
default-character-set=utf8 --编码问题

还有[mysqld]下的：

[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-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
default_character_set=utf8 --编码问题
default-character-set=utf8 --编码问题
init_connect='SET NAMES utf8' --编码问题
lower_case_table_names=1 --解决linux下mysql区分大小写问题

ok！

===================================================================

= =

===================================================================

默认my.cnf文件不是这样的，这个是拷贝过来的，步骤：

# find / -iname *.cnf -print

# find / -iname *.cnf -print
/root/Desktop/mysql-5.0.56/mysql-test/std_data/ndb_config_mycnf1.cnf
/root/Desktop/mysql-5.0.56/mysql-test/std_data/bug15328.cnf
/root/Desktop/mysql-5.0.56/mysql-test/std_data/ndb_config_mycnf2.cnf
/etc/my.cnf
/etc/pki/tls/openssl.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-large.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-small.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-huge.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-innodb-heavy-4G.cnf