CENTOS 中mysql的简单设置

安装环境                                                       
系统环境：LinuxCentOS5.3操作系统                                                       
服务器软件：SUM mysql5                                                       
                    (mysql-5.1.26-rc-linux-i686-glibc23.tar.gz)                                   
mysql5由CentOS5.3集成安装，在安装CentOS5.3时添加mysql即可。                                                       
但系统所带mysql默认是关闭的。要在系统中手动激活。                                                       
方法如下：                                                       
启动mysql服务                                                       
service mysqld start                                                       
添加用户                                                       
mysql                                                       
grant 权限 on 数据库名.表名 用户@登录主机 identified by "用户密码";                       
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY "password" WITH GRANT OPTION;                                                       
GRANT ALL PRIVILEGES ON *.* TO username@"localhost" IDENTIFIED BY "password" WITH GRANT OPTION;                                                       
开启3306端口                                                       
在/etc/sysconfig/iptables中开放3306端口                                                       
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT                                                       
设置开机启动                                                       
cd /etc/rc.d/init.d/                                                       
chkconfig --add mysqld                                                       
chkconfig mysqld on                                                       
设置mysql大小写                                                       
    由于mysql在上CentOS上默认表名是区分大小写的，所以要改为不区分                                                   
修改my.cnf文件，目录为/etc/my.cnf                                                       
在其中加上                                                       
lower_case_table_names=1                                                       
skip-name-resolve                                                       
有时数据备份后恢复时会出现错误是由于数据量太大，这时要在my.cnf中加的以下字段                                                       
max_allowed_packet=500M                                                       
[mysqld_safe]                                                       
[client]                                                       
[mysql]                                                       
default-character-set=urf8                                                       

创建库并设定编码格式
create database databasename default charset='utf8';