centos6.4 安装mysql5.6_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   #重启系统