centos6.9 腾讯云安装mysql

首先查询系统是否安装了

 rpm -qa | grep -i mysql
1.png

卸载彻底删除安装的mysql

rpm -ev mysql-community-common-5.6.44-2.el7.x86_64
rpm -ev mysql-community-release-el7-5.noarch
rpm -ev mysql-community-client-5.6.44-2.el7.x86_64
rpm -ev mysql-community-server-5.6.44-2.el7.x86_64
rpm -ev mysql-community-libs-5.6.44-2.el7.x86_64

在卸载服务是遇到了三个组件服务无法卸载问题,提示缺少依赖postfix-2:2.10.1-7.el7.x86_64:

error: Failed dependencies:
libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64

解决方法就是在 rpm -ev 加上--nodeps:

 --nodeps就是安装时不检查依赖关系
 

查看yum源提供mysql的版本


[root@tbc-pc ~]# yum list|grep mysql

运行结果:


[root@tbc-pc ~]# 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                base 

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 

mysql-embedded.i686                        5.1.73-8.el6_8                base 

mysql-embedded.x86_64                      5.1.73-8.el6_8                base 

mysql-embedded-devel.i686                  5.1.73-8.el6_8                base 

mysql-embedded-devel.x86_64                5.1.73-8.el6_8                base 

mysql-libs.i686                            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 

mysql-test.x86_64                          5.1.73-8.el6_8                base 

pcp-pmda-mysql.x86_64                      3.10.9-9.el6                  base 

php-mysql.x86_64                          5.3.3-49.el6                  base 

qt-mysql.i686                              1:4.6.2-28.el6_5              base 

qt-mysql.x86_64                            1:4.6.2-28.el6_5              base 

rsyslog-mysql.x86_64                      5.8.10-12.el6                base 

rsyslog7-mysql.x86_64                      7.4.10-7.el6                  base

接下来从yum源安装mysql mysql-server mysql-devel


[root@tbc-pc ~]# yum install -y mysql mysql-server mysql-devel


结果

已安装:

  mysql-devel.x86_64 0:5.1.73-8.el6_8                                                                   

作为依赖被安装:

  keyutils-libs-devel.x86_64 0:1.4-5.el6              krb5-devel.x86_64 0:1.10.3-65.el6               

  libcom_err-devel.x86_64 0:1.41.12-24.el6            libselinux-devel.x86_64 0:2.0.94-7.el6           

  libsepol-devel.x86_64 0:2.0.41-4.el6                openssl-devel.x86_64 0:1.0.1e-57.el6             

  zlib-devel.x86_64 0:1.2.3-29.el6                   

作为依赖被升级:

  e2fsprogs.x86_64 0:1.41.12-24.el6                e2fsprogs-libs.x86_64 0:1.41.12-24.el6             

  libcom_err.x86_64 0:1.41.12-24.el6                libss.x86_64 0:1.41.12-24.el6

已安装:

  mysql.x86_64 0:5.1.73-8.el6_8                    mysql-server.x86_64 0:5.1.73-8.el6_8                 

作为依赖被安装:

  mysql-libs.x86_64 0:5.1.73-8.el6_8  perl-DBD-MySQL.x86_64 0:4.013-3.el6  perl-DBI.x86_64 0:1.609-4.el6

完毕!

首次启动初始化mysql数据库


[root@tbc-pc ~]# service mysqld start

初始化 MySQL 数据库:

重启mysql


[root@tbc-pc ~]# service mysqld restart

停止 mysqld:                                              [确定]

正在启动 mysqld:                                          [确定]

修改密码


[root@tbc-pc ~]# mysqladmin -u root password 123456

连接mysql


[root@tbc-pc ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

提示符号告诉你可以使用mysql了。

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容