CentOS 6.4上面安装MySQL 5.6社区版

首先下载安装包 MySQL-5.6.16-1.el6.x86_64.rpm-bundle.tar，复制到自己的目录
解压该文件会包含如下文件：
(1)MySQL-server-5.6.16-1.el6.x86_64.rpm
(2)MySQL-client-5.6.16-1.el6.x86_64.rpm
(3)MySQL-devel-5.6.16-1.el6.x86_64.rpm
(4)MySQL-shared-5.6.16-1.el6.x86_64.rpm
(5)MySQL-shared-compat-5.6.16-1.el6.x86_64.rpm
(6)MySQL-embedded-5.6.16-1.el6.x86_64.rpm
(7)MySQL-test-5.6.16-1.el6.x86_64.rpm


一般情况下安装MySQL-server-5.6.16-1.el6.x86_64.rpm;MySQL-client-5.6.16-1.el6.x86_64.rpm这个包就行了，其他的根据需要安装；


在安装的时候提示与某个软件相冲突，先删除这个软件，然后再安装
yum remove y 软件名


安装完成，查看有没有安装成功
rpm -q MySQL-server


安装成功，启动MySQL服务
service mysql start


登陆系统：
在这个版本的安装过程中会在 /root/.mysql_secret 生成随机密码，
首次登陆、找到随机密码，用此密码来登录


mysql -u root -p 

进入MySQL之后修改root密码：

--设置新密码
mysql> set password=password('123456');  
 --刷新系统权限,重启服务也可以
mysql>flush privileges; 
mysql> exit;

配置客户端连接服务器：

--赋予任何主机上以root身份访问数据的权限(有密码)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION；  
--赋予任何主机上以root身份访问数据的权限(没密码)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION；  
mysql>flush privileges;

--客户端登陆
mysql -h 192.168.1.197 -u root   --没有密码
mysql -h 192.168.1.197 -u root -p  --有密码

C:\Users\Administrator>d:


D:\>cd D:\Program Files\MySQL\MySQL Server 5.6\bin


D:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -h 192.168.1.197 -u root -p
Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.6.16 MySQL Community Server (GPL)


Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>

--查看连接权限

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.01 sec)
mysql> use mysql;
Database changed
mysql> select user,host from user;
+------+-----------+
| user | host      |
+------+-----------+
| root | %         |
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
| root | syoa      |
+------+-----------+
5 rows in set (0.00 sec)


mysql>

注:host为%，说明可以任意主机连接


--进入之后发现表名区分大小写
修改配置 /usr/my.cnf
在[mysqld]下加入一行：
lower_case_table_names=1


重启服务就OK了


--修改字符集的问题

mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> exit;

[root@syoa usr]# vim /usr/my.cnf
加文件中加入：

[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8


[mysqld]
lower_case_table_names=1
character-set-server=utf8
socket=/var/lib/mysql/mysql.sock


[mysql]
no-auto-rehash
default-character-set=utf8

--重启服务
[root@syoa usr]# service mysql restart


再次登陆：

[root@syoa usr]# mysql -u root -p
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)


mysql>

注意事项：

在连接的时候可能需要关闭防火墙、SeLinux

关闭防火墙：
/etc/init.d/iptables stop
启动防火墙：
/etc/init.d/iptables start
永久关闭防火墙：
chkconfig --level 35 iptables off
service iptables stop

修改配置：
/etc/selinux/config
      #SELINUX=enforcing     #注释掉
      #SELINUXTYPE=targeted  #注释掉
      SELINUX=disabled  #增加
      
shutdown -r now   #重启系统