easy install mysql_mysql安装设置

· 安装服务器端yum install mysql-server

· 设置开机启动

chkconfig --list mysqld

chkconfig mysqld --level 2345 on

chkconfig --list mysqld

· 配置iptable

iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

service iptables save

service iptables restart

· 设置支持UTF-8

1. vi /etc/my.cnf

2. 在[mysqld]中加入：default-character-set = utf8

3. 在[mysql]中加入：default-character-set = utf8

· 设置大小写敏感

1. 在[mysqld]中加入：lower_case_table_names=1

0：大小写敏感 1：大小写不敏感，表名应均为小写

· 设置安全登陆方式

1. 在[mysqld]中old_passwords=1改为0

2. 在[mysqld]中加入：secure_auth=1

· 最终配置文件

[root@AY13 ~]# cat /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

secure_auth=1

default-character-set=utf8

lower_case_table_names=1

# Disabling symbolic-links is recommended to prevent assorted security risks;

# to do so, uncomment this line:

# symbolic-links=0

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid