• ADADADADAD

    Linux平台用RPM包方式安装Mysql 5.7[ mysql数据库 ]

    mysql数据库 时间:2024-11-28 13:01:53

    作者:文/会员上传

    简介:

    在 Mysql 官网下载 RPM 的 bundle 包并解压。[root@localhost mysql5.7]# tar xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar单独安装 Server 包,报依赖关系的错误。[root@T

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    在 Mysql 官网下载 RPM 的 bundle 包并解压。

    [root@localhost mysql5.7]# tar xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar

    单独安装 Server 包,报依赖关系的错误。

    [root@T400-kelong software]# rpm -ivh mysql-community-server-5.7.10-1.el6.x86_64.rpm
    warning: mysql-community-server-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    error: Failed dependencies:
    mysql-community-client(x86-64) = 5.7.10-1.el6 is needed by mysql-community-server-5.7.10-1.el6.x86_64
    mysql-community-common(x86-64) = 5.7.10-1.el6 is needed by mysql-community-server-5.7.10-1.el6.x86_64

    将所需的包添加上,依然报错,缺少另外一个包。

    [root@T400-kelong software]# rpm -ivh mysql-community-server-5.7.10-1.el6.x86_64.rpm mysql-community-common-5.7.10-1.el6.x86_64.rpm mysql-community-client-5.7.10-1.el6.x86_64.rpm
    warning: mysql-community-server-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    error: Failed dependencies:
    mysql-community-libs(x86-64) = 5.7.10-1.el6 is needed by mysql-community-client-5.7.10-1.el6.x86_64

    将所需的包添加上,继续报错,和系统自带的5.1 版本冲突。

    [root@T400-kelong software]# rpm -ivh mysql-community-server-5.7.10-1.el6.x86_64.rpm mysql-community-common-5.7.10-1.el6.x86_64.rpm mysql-community-client-5.7.10-1.el6.x86_64.rpm mysql-community-libs-5.7.10-1.el6.x86_64.rpm
    warning: mysql-community-server-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...########################################### [100%]
    file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.10-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
    file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.10-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64

    卸载掉报错的mysql 5.1安装包

    [root@T400-kelong software]# yum remove mysql-libs-5.1.73-5.el6_6.x86_64
    Loaded plugins: fastestmirror, refresh-packagekit, security
    Setting up Remove Process
    Resolving Dependencies
    There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
    --> Running transaction check
    ---> Package mysql-libs.x86_64 0:5.1.73-5.el6_6 will be erased
    --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
    --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
    --> Running transaction check
    ---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be erased
    --> Finished Dependency Resolution

    Dependencies Resolved

    =============================================================================================================================================================
    Package Arch Version RepositorySize
    =============================================================================================================================================================
    Removing:
    mysql-libsx86_645.1.73-5.el6_6 @base4.0 M
    Removing for dependencies:
    perl-DBD-MySQLx86_644.013-3.el6 @base338 k

    Transaction Summary
    =============================================================================================================================================================
    Remove2 Package(s)

    Installed size: 4.4 M
    Is this ok [y/N]: y

    安装 RPM 包

    [root@T400-kelong software]# rpm -ivh mysql-community-server-5.7.10-1.el6.x86_64.rpm mysql-community-common-5.7.10-1.el6.x86_64.rpm mysql-community-client-5.7.10-1.el6.x86_64.rpm mysql-community-libs-5.7.10-1.el6.x86_64.rpm
    warning: mysql-community-server-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...########################################### [100%]
    1:mysql-community-common ########################################### [ 25%]
    2:mysql-community-libs########################################### [ 50%]
    3:mysql-community-client ########################################### [ 75%]
    4:mysql-community-server ########################################### [100%]

    启动数据库。

    [root@T400-kelong sbin]# service mysqld start
    初始化 MySQL 数据库: [确定]
    正在启动 mysqld: [确定]
    [root@T400-kelong sbin]# service mysqld status
    mysqld (pid 4782) 正在运行...

    [root@T400-kelong sbin]# ps -ef|grep mysql
    root 4586 1 0 21:11 pts/100:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
    mysql 4782 4586 2 21:11 pts/100:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
    root 4847 3857 0 21:11 pts/100:00:00 grep mysql


    使用临时密码登录到 ROOT 用户,更改 ROOT 密码。

    grep 'temporary password' /var/log/mysql/mysqld.log

    [root@T400-kelong sbin]# mysql -uroot -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 4
    Server version: 5.7.10

    Copyright (c) 2000, 2015, 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> alter user 'root'@'localhost' identified by 'System#2013';
    Query OK, 0 rows affected (0.00 sec)

    Linux平台用RPM包方式安装Mysql 5.7.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysqllinux