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

[mysql]
default-character-set=utf8



参考：
How to Install MySQL 5.6 on CentOS 6.3/RedHat EL6/Fedora

转载于:https://www.cnblogs.com/easynote/p/3277380.html