1、检查本机是否安装了mysql
yum list installed | grep mysql
执行后效果如下:
mysql-libs.i686 5.1.71-1.el6 @anaconda-CentOS-201311271240.i386/6.5
说明本机已有安装版本,需要删除:
yum -y remove mysql-libs.i686(名称为查询出来的名称)
2、下载最新版本
从mysql的官网下载mysql57-community-release-el6-5.noarch.rpm(注意这里的el6-5即适配RHEL6.5的版本,如果下载了其它版本后面的安装过程中可能会报错):
wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
3、安装rpm包
yum install mysql-community-release-el6-5.noarch.rpm
安装成功后,我们可以看到/etc/yum.repos.d/目录下增加了以下两个文件
# ls /etc/yum.repos.d
mysql-community-source.repo
mysql-community.repo
查看mysql57的安装源是否可用,如不可用请自行修改配置文件(/etc/yum.repos.d/mysql-community.repo)使mysql57下面的enable=1
若有mysql其它版本的安装源可用,也请自行修改配置文件使其enable=0
# yum repolist enabled | grep mysql
mysql-connectors-community MySQL Connectors Community 13
mysql-tools-community MySQL Tools Community 18
mysql57-community-dmr MySQL 5.7 Community Server Development Milesto 65
4、使用yum安装mysql
yum install mysql-community-server
5、启动mysql
service mysqld start
查看root密码:
# grep "password" /var/log/mysqld.log
2016-08-10T15:03:02.210317Z 1 [Note] A temporary password is generated for root@localhost: AYB(&-3Cz-rW
现在必须立刻修改密码,不然会报错:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改密码(如果在此步报错ERROR 1819,请向下翻查看原因及解决方法):
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
6、设置mysql自动启动
chkconfig --list | grep mysqld
chkconfig mysqld on
7、修改字符集
vim /etc/my.cnf
#在[mysqld]部分添加:
character-set-server=utf8
#在文件末尾新增[client]段,并在[client]段添加:
default-character-set=utf8
8、重启服务
service mysqld restart