阿里云首次优惠购买地址享受2-5折优惠
https://promotion.aliyun.com/ntms/act/enterprise-discount.html?userCode=bqdn3ccq
1、卸载mysql
(1)、查看已装的mysql版本
-
[root@localhost ~]# yum list installed | grep mysql
-
mysql.x86_64 5.1.73-8.el6_8 @base
-
mysql-devel.x86_64 5.1.73-8.el6_8 @base
-
mysql-libs.x86_64 5.1.73-8.el6_8 @base
-
mysql-server.x86_64 5.1.73-8.el6_8 @base
(2)、依次卸载,有依赖关系
[root@localhost ~]# yum -y remove mysql-5.1.73-8.el6_8.x86_64
[root@localhost ~]# yum -y remove mysql-libs.x86_64
(3)、再次查看,卸载完成
-
[root@localhost ~]# rpm -qa|grep mysql
-
[root@localhost ~]#
(4)、查看系统自带的mysql
-
[root@localhost ~]# yum list | grep mysql
-
apr-util-mysql.x86_64 1.3.9-3.el6_0.1 base
-
bacula-director-mysql.x86_64 5.0.0-13.el6 base
-
bacula-storage-mysql.x86_64 5.0.0-13.el6 base
-
dovecot-mysql.x86_64 1:2.0.9-22.el6 base
-
freeradius-mysql.x86_64 2.2.6-7.el6_9 updates
-
libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 base
-
mod_auth_mysql.x86_64 1:3.0.0-11.el6_0.1 base
-
mysql.x86_64 5.1.73-8.el6_8 base
-
mysql-bench.x86_64 5.1.73-8.el6_8 base
-
mysql-connector-java.noarch 1:5.1.17-6.el6 base
-
mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 base
-
mysql-devel.i686 5.1.73-8.el6_8 base
-
mysql-devel.x86_64 5.1.73-8.el6_8 base
版本过低,选择其他的源
2、安装mysql
(1)获取其它源
-
[root@localhost ~]# cd /etc/yum.repos.d
-
[root@localhost yum.repos.d]# wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
(2)安装
[root@localhost yum.repos.d]# yum install mysql-community-release-el6-5.noarch.rpm
[root@localhost yum.repos.d]# yum install mysql mysql-server
(3)启动
[root@localhost yum.repos.d]# service mysqld start
(4)呵呵呵,报错了
-
[root@localhost yum.repos.d]# service mysqld start
-
MySQL Daemon failed to start.
-
Starting mysqld: [FAILED]
(5)原因:我上个删除的mysql没有删除历史数据库文件
解决方法:删除数据库文件
[root@localhost yum.repos.d]# cd /var/lib
[root@localhost lib]# rm -rf mysql
[root@localhost lib]# mkdir mysql
(6)再次启动
[root@localhost lib]# service mysqld start
(7)查看版本
-
[root@localhost lib]# mysql -V
-
mysql Ver 14.14 Distrib 5.6.38, for Linux (x86_64) using EditLine wrapper
(8)修改密码
-
[root@localhost lib]# mysqladmin -u root password 123456
-
Warning: Using a password on the command line interface can be insecure.
-
[root@localhost lib]# mysql -u root -p
3、成功!