mysql：mysql5.6安装

一、安装环境

Centos6.4
Mysql5.6

二、步骤

1.删除系统自带mysql
需要检测系统是否自带安装mysql

[root@bigdata software]# rpm -qa | grep mysql 
mysql-community-release-el6-5.noarch

如果有，则删除mysql

[root@bigdata software]# rpm -e --nodeps mysql-community-release-el6-5.noarch

2.下载mysql的rpm源
下载mysql的yum源的安装文件

# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

安装mysql的yum源仓库，在/etc/yum.repos.d/ 这个目录下多出mysql-community-source.repo和mysql-community.repo

# rpm -ivh mysql-community-release-el6-5.noarch.rpm

查看是否已有可用的mysql的yum源

#yum repolist all | grep mysql

3.安装mysql服务

# yum install -y mysql-community-server

4.启动mysql服务

# service mysqld start

5.对于5.6mysql，安装完成，mysql密码默认为空，需要修改密码

[root@bigdata software]# mysql -uroot -p
mysql> use mysql;
mysql> update user set password=PASSWORD("123456") where User='root';
mysql> flush privileges; 

6.设置mysql开机启动

# chkconfig --list | grep mysqld
# chkconfig mysqld on

7.设置允许远程登陆

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected (0.00 sec)
然后，切记重启mysql
[root@bigdata software]# service mysqld restart
Stopping mysqld:  [  OK  ]
Starting mysqld:  [  OK  ]

8.重新远程登陆即可