linux yum方式安装mysql

原文地址:http://www.cnblogs.com/renjidong/p/7047396.html

Centos 升级MySQL版本或者Yum安装Mysql5.6(阿里云默认安装的mysql不可用)

1.卸载[[email protected] ~]# yum remove mysql mysql-*  //查看mysql详情[[email protected] ~]# yum list installed | grep mysql

2.删除老版本的/etc/my.conf,/var/lib/mysql, 或者备份老版本的mysql

3.下载mysql的rpm的yum源(更多版本地址:http://dev.mysql.com/downloads/repo/yum/)
    centos 6:[[email protected] ~]# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

4.安装这个rpm包
[[email protected] ~]#rpm -ivh mysql-community-release-el6-5.noarch.rpm  //这个时候，可以用[[email protected] ~]#yum repolist mysql这个命令查看一下是否已经有mysql可安装文件

5安装mysql
[[email protected] ~]#yum install mysql-community-server

6启动mysql服务
[[email protected] ~]#service mysqld start

7.登录配置
[[email protected] ~]#mysql -u root
[[email protected] ~]#use mysql;
[[email protected] ~]#grant all privileges on *.* to 'root' @'%' identified by '123456'; flush privileges; //重定义root用户为远程用户并设置密码为123456
[[email protected] ~]#flush privileges;