源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

Centos MySQL 5.7安装、升级教程

  • 时间:2022-01-09 12:27 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:Centos MySQL 5.7安装、升级教程
MySQL 5.7安装、升级笔记分享: [b]卸载当前的 MySQL[/b] 查看当前 MySQL 版本:
[root@coderknock ~]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1
停止 MySQL 服务
[root@coderknock ~]# service mysqld stop
Stopping mysqld:      [ OK ]
备份数据【数据不重要可以忽略】 备份数据库,升级MySQL通常不会丢失数据,但保险起见,我们需要做这一步。输入命令: [root@coderknock ~]# mysqldump -u xxx -h xxx -P 3306 -p --all-databases > databases.sql 卸载旧版本 MySQL
[root@coderknock ~]# yum remove mysql mysql-*
Loaded plugins: security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.1.73-7.el6 will be erased
---> Package mysql-libs.i686 0:5.1.73-7.el6 will be erased
--> Processing Dependency: libmysqlclient.so.16 for package: 2:postfix-2.6.6-6.el6_7.1.i686
--> Processing Dependency: libmysqlclient.so.16 for package: perl-DBD-MySQL-4.013-3.el6.i686
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: 2:postfix-2.6.6-6.el6_7.1.i686
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: perl-DBD-MySQL-4.013-3.el6.i686
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_7.1.i686
---> Package mysql-server.i686 0:5.1.73-7.el6 will be erased
--> Running transaction check
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be erased
---> Package postfix.i686 2:2.6.6-6.el6_7.1 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.i686
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.i686
--> Running transaction check
---> Package cronie.i686 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.i686
---> Package redhat-lsb-core.i686 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package cronie-anacron.i686 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-31.el6.i686
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.i686 0:9.0.4-31.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================================================================================================================
 Package     Arch    Version     Repository        Size
=======================================================================================================================================================================================================
Removing:
 mysql     i686    5.1.73-7.el6     @base        2.3 M
 mysql-libs     i686    5.1.73-7.el6     @base        3.9 M
 mysql-server    i686    5.1.73-7.el6     @base        24 M
Removing for dependencies:
 cronie     i686    1.4.4-16.el6_8.2    @updates        169 k
 cronie-anacron    i686    1.4.4-16.el6_8.2    @updates        38 k
 crontabs     noarch    1.10-33.el6     @anaconda-CentOS-201311291201.i386/6.5    2.4 k
 perl-DBD-MySQL    i686    4.013-3.el6     @base        341 k
 postfix     i686    2:2.6.6-6.el6_7.1    @base        9.3 M
 redhat-lsb-core    i686    4.0-7.el6.centos    @anaconda-CentOS-201311291201.i386/6.5    22 k
 sysstat     i686    9.0.4-31.el6     @base        804 k

Transaction Summary
=======================================================================================================================================================================================================
Remove 10 Package(s)

Installed size: 41 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
 Erasing : mysql-server-5.1.73-7.el6.i686                   1/10 
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
 Erasing : redhat-lsb-core-4.0-7.el6.centos.i686                  2/10 
/var/tmp/rpm-tmp.Y5QGjy: line 1: lsb_release: command not found
 Erasing : mysql-5.1.73-7.el6.i686                    3/10 
 Erasing : perl-DBD-MySQL-4.013-3.el6.i686                   4/10 
 Erasing : sysstat-9.0.4-31.el6.i686                    5/10 
 Erasing : crontabs-1.10-33.el6.noarch                   6/10 
 Erasing : cronie-anacron-1.4.4-16.el6_8.2.i686                  7/10 
 Erasing : cronie-1.4.4-16.el6_8.2.i686                   8/10 
 Erasing : 2:postfix-2.6.6-6.el6_7.1.i686                   9/10 
 Erasing : mysql-libs-5.1.73-7.el6.i686                   10/10 
 Verifying : redhat-lsb-core-4.0-7.el6.centos.i686                  1/10 
 Verifying : perl-DBD-MySQL-4.013-3.el6.i686                   2/10 
 Verifying : mysql-server-5.1.73-7.el6.i686                   3/10 
 Verifying : crontabs-1.10-33.el6.noarch                   4/10 
 Verifying : sysstat-9.0.4-31.el6.i686                    5/10 
 Verifying : cronie-anacron-1.4.4-16.el6_8.2.i686                  6/10 
 Verifying : cronie-1.4.4-16.el6_8.2.i686                   7/10 
 Verifying : mysql-libs-5.1.73-7.el6.i686                   8/10 
 Verifying : mysql-5.1.73-7.el6.i686                    9/10 
 Verifying : 2:postfix-2.6.6-6.el6_7.1.i686                   10/10 

Removed:
 mysql.i686 0:5.1.73-7.el6     mysql-libs.i686 0:5.1.73-7.el6     mysql-server.i686 0:5.1.73-7.el6     

Dependency Removed:
 cronie.i686 0:1.4.4-16.el6_8.2  cronie-anacron.i686 0:1.4.4-16.el6_8.2 crontabs.noarch 0:1.10-33.el6 perl-DBD-MySQL.i686 0:4.013-3.el6 postfix.i686 2:2.6.6-6.el6_7.1 
 redhat-lsb-core.i686 0:4.0-7.el6.centos sysstat.i686 0:9.0.4-31.el6  

Complete!

这样就卸载完成了,为了保险起见我们检查一下系统中是否还有 MySQL 相关内容没有删除干净
[root@coderknock ~]# yum list installed | grep mysql
[root@coderknock ~]# 
上面的情况是没有未删除部分,如果有的话可通过下面的命令删除: [root@coderknock ~]# yum remove mysql-libs [b]下载最新版本的 MySQL[/b] 查看系统配置信息选择对应 MySQL 包
[root@coderknock ~]# uname -r 
3.10.104-1.el6.elrepo.i686
在浏览器打开 sohu提供的%E2%80%98root IDENTIFIED BY ‘你的密码' 如果遇到ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 则需要退出安全模式,正常启动MySQL后登陆再进行以上操作:
mysql> quit
[root@coderknock ~]# ps -ef|grep mysql
root 14208 12686 0 23:02 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking
mysql 14381 14208 0 23:02 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-grant-tables --skip-networking --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 15148 12686 0 23:23 pts/0 00:00:00 grep mysql
[root@coderknock ~]# kill -9 114208
-bash: kill: (114208) - No such process
[root@coderknock ~]# kill -9 14208
[1]+ Killed   mysqld_safe --user=mysql --skip-grant-tables --skip-networking
[root@coderknock ~]# kill -9 1438
[root@coderknock ~]# service mysqld start
[root@coderknock ~]# mysql -u root mysql
精彩专题分享:[url=http://www.1sucai.cn/Special/832.htm]mysql不同版本安装教程[/url] [url=http://www.1sucai.cn/Special/863.htm]mysql5.7各版本安装教程[/url] 以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持编程素材网。
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部