CentOS6.9安装MySQL5.6

CentOS6.9安装MySQL5.6

1.检查系统自带mysql

yum list installed | grep mysql

2.卸载

yum -y remove mysql-libs.x86_64

3.安装mysql5.6

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

当前目录下会下载一个mysql-community-release-el6-5.noarch.rpm的包

安装

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

查看是否存在可安装的软件

yum repolist all | grep mysql

进行安装

yum install mysql-community-server

4.启动

service mysqld start

5.修改密码

mysql -u root
use mysql;
update user set password=PASSWORD("root") where User='root';
flush privileges;

6.设置远程权限(登录mysql情况下设置)

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH  PRIVILEGES;

其中*.*代表所有资源所有权限，‘root’@’%'中root代表账户名，%代表所有的访问地址，IDENTIFIED BY ‘root’，这个root是指访问密码，WITH GRANT OPTION允许级联授权。

7.设置MySQL开机启动

查看MySQL开机自启动

chkconfig --list | grep mysqld

设置自启动

chkconfig mysqld on