mysql×Ö·û¼¯²é¿´ÒÔ¼°ÐÞ¸Ä

mysql×Ö·û¼¯²é¿´ÒÔ¼°ÐÞ¸Ä
http://blog.csdn.net/cs870101/archive/2009/09/23/4580879.aspx
ת×Ô:http://blog.chinaunix.net/u2/85344/showart_2042280.html
LiunxÏÂÐÞ¸ÄMySQL×Ö·û¼¯£º
1.²éÕÒMySQLµÄcnfÎļþµÄλÖÃ
find / -iname '*.cnf' -print
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/texmf/web2c/texmf.cnf
/usr/share/texmf/web2c/mktex.cnf
/usr/share/texmf/web2c/fmtutil.cnf
/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf
/usr/share/texmf/tex/jadetex/jadefmtutil.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-large.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-small.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-huge.cnf
2. ¿½±´ small.cnf¡¢my-medium.cnf¡¢my-huge.cnf¡¢my-innodb-heavy-4G.cnfÆäÖеÄÒ»¸öµ½/etcÏ£¬ÃüÃûΪmy.cnf
cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
3. ÐÞ¸Ämy.cnf
vi /etc/my.cnf
ÔÚ[client]ÏÂÌí¼Ó
default-character-set=utf8
ÔÚ[mysqld]ÏÂÌí¼Ó
default-character-set=utf8
4.ÖØÐÂÆô¶¯MySQL
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL                                        [ È·¶¨ ]
Starting MySQL.                                            [ È·¶¨ ]
[root@bogon ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.22-rc-community-log MySQL Community Edition (GPL