首页 > 代码库 > CentOS 下的MySQL配置

CentOS 下的MySQL配置

2024-07-12 16:24:36   217人阅读

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

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

还有[mysqld]下 的：

[mysqld]port            = 3306socket          = /var/lib/mysql/mysql.sockskip-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = 256Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8Mdefault_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

拷贝一个出来

cp /usr/share/doc/MySQL-server-community-5.0.92/my-medium.cnf  /etc/my.cnf

是否覆盖：Y。

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

打开：

vi /etc/my.cnf

按上面修改后，按两次大写Z保存退出。

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

重启mysqld

# service mysqld restart

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


联系
我们