`
knight_black_bob
  • 浏览: 850895 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

mysql 安装 【解决】mariadb-libs is obsoleted by mysql-community-libs-5.7.17-1.el6.x86

阅读更多

【解决】mariadb-libs is obsoleted by mysql-community-libs-5.7.17-1.el6.x86_64

 

问题

 

[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm 
warning: mysql-community-libs-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-5.7.17-1.el6.x86_64
	mariadb-libs is obsoleted by mysql-community-libs-5.7.17-1.el6.x86_64

 

解决方法:

[root@fdfs-mysql1 ~]# rpm -qa | grep postfix
postfix-2.10.1-6.el7.x86_64
[root@fdfs-mysql1 ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@fdfs-mysql1 ~]#  rpm -ev postfix-2.10.1-6.el7.x86_64
Preparing packages...
postfix-2:2.10.1-6.el7.x86_64
[root@fdfs-mysql1 ~]# rpm -ev  mariadb-libs-5.5.56-2.el7.x86_64
Preparing packages...
mariadb-libs-1:5.5.56-2.el7.x86_64

 

结果:

[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-common-5.7.17-1.el6.x86_64.rpm  
warning: mysql-community-common-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.17-1.e################################# [100%]
[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm  
warning: mysql-community-libs-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-5.7.17-1.el6################################# [100%]
[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-client-5.7.17-1.el6.x86_64.rpm  
warning: mysql-community-client-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-5.7.17-1.e################################# [100%]
[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-server-5.7.17-1.el6.x86_64.rpm  
warning: mysql-community-server-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-5.7.17-1.e^[[A################################# [100%]
[root@fdfs-mysql1 ~]# rpm -ivh mysql-community-devel-5.7.17-1.el6.x86_64.rpm
warning: mysql-community-devel-5.7.17-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-devel-5.7.17-1.el################################# [100%]
[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# 

 

 

[root@fdfs-mysql1 ~]# cat /var/log/mysqld.log 
2019-05-08T09:12:39.778853Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-08T09:12:40.369078Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-05-08T09:12:40.451732Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-05-08T09:12:40.517425Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 6e2ca610-7171-11e9-9d48-005056bb58dd.
2019-05-08T09:12:40.519284Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-05-08T09:12:40.520711Z 1 [Note] A temporary password is generated for root@localhost: H(=XYN<l&1(x
[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# 
[root@fdfs-mysql1 ~]# setenforce 0 
setenforce: SELinux is disabled
[root@fdfs-mysql1 ~]# service mysqld start 
Starting mysqld (via systemctl):                           [  OK  ]
[root@fdfs-mysql1 ~]# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.17

Copyright (c) 2000, 2016, 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> set global validate_password_policy=0 
    -> ;
ERROR 1193 (HY000): Unknown system variable 'validate_password_policy'
mysql> SET PASSWORD = PASSWORD('Aa12345');  
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set host='%' where user='root' and host='localhost';  
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)

mysql> exit  
Bye


create user 'root'@'localhost' identified by 'root';
grant all on *.* to 'root'@'localhost' with grant option;
FLUSH PRIVILEGES

update user set host='%' where user='fastdfs_w' 
flush privileges; 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

捐助开发者 

在兴趣的驱动下,写一个免费的东西,有欣喜,也还有汗水,希望你喜欢我的作品,同时也能支持一下。 当然,有钱捧个钱场(支持支付宝和微信 以及扣扣群),没钱捧个人场,谢谢各位。

 

个人主页http://knight-black-bob.iteye.com/



 
 
 谢谢您的赞助,我会做的更好!

0
0
分享到:
评论

相关推荐

    mariadb-libs-5.5.68-1.el7.x86_64.rpm

    官方离线安装包,测试可用。请使用rpm -ivh [rpm完整包名] 进行安装

    mysql-community-libs-5.7.34-1.el7.x86_64.rpm

    mysql-community-libs-5.7.34-1.el7.x86_64.rpm

    mariadb-5.5.68-1.el7.x86_64.rpm

    官方离线安装包,测试可用。请使用rpm -ivh [rpm完整包名] 进行安装

    mariadb-5.5.68-linux-x86_64.tar.gz

    总而言之,"mariadb-5.5.68-linux-x86_64.tar.gz"是一个针对Linux平台的MariaDB数据库服务器的安装包,包含了丰富的特性和优化,为开发者和管理员提供了强大且灵活的数据库解决方案。用户在使用时应根据具体需求进行...

    MariaDB(mariadb-10.6.8-linux-systemd-x86_64.tar.gz)

    MariaDB(mariadb-10.6.8-linux-systemd-x86_64.tar.gz)适用于Linux x86_64系统 MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护,采用GPL授权许可 MariaDB的目的是完全兼容MySQL,包括API和命令行...

    mariadb-10.10.3-linux-systemd-x86-64.tar.gz

    "mariadb-10.10.3-linux-systemd-x86_64.tar.gz"这个压缩包就是专门为64位Linux系统设计的,包含了MariaDB服务器以及相关的配置和服务脚本。 安装这个压缩包后,用户可以享受到以下关键功能和特性: 1. **存储引擎...

    mariadb10.4.7的rpm包及安装所需要的依赖包

    MariaDB-client-10.4.7-1.el7.centos.x86_64.rpm;MariaDB-common-10.4.7-1.el7.centos.x86_64.rpm;MariaDB-compat-10.4.7-1.el7.centos.x86_64.rpm;MariaDB-server-10.4.7-1.el7.centos.x86_64.rpm;perl-...

    mariadb-10.2.31-linux-x86_64.tar.gz

    安装"mariadb-10.2.31-linux-x86_64"步骤通常包括以下部分: 1. **解压文件**:使用`tar -zxvf mariadb-10.2.31-linux-x86_64.tar.gz`命令解压缩文件到指定目录。 2. **配置前准备**:确保系统满足最低硬件需求,...

    mariadb-10.11.2-linux-systemd-x86-64.tar.gz

    1. 解压文件:使用`tar -zxvf mariadb-10.11.2-linux-systemd-x86_64.tar.gz`命令解压文件到指定目录。 2. 移动或链接二进制文件:将解压后的bin目录下的可执行文件移动到系统路径(如/usr/bin)或者创建软链接。 3....

    mariadb-5.5.60-1.el7_5.x86_64.rpm

    离线安装包,亲测可用

    MariaDB-5.5.68的RPM包

    MariaDB-5.5.68-centos6-i686-compat.rpm包含了与MySQL兼容的库和文件,确保那些为MySQL编写的旧应用程序或库可以在MariaDB上运行。 MariaDB-5.5.68-centos6-i686-shared.rpm是共享库,包含了MariaDB运行时所需的...

    mariadb-java-client-2.4.0.jar和mysql-connector-java-8.0.11.jar驱动

    mariadb-java-client-2.4.0.jar和mysql-connector-java-8.0.11.jar驱动 驱动信息。mm-mysql-2.0.13-bin.jar 这些jar包都可以驱动

    autoInstall_mariadb-5.5.68-linux-x86_64

    总结来说,`autoInstall_mariadb-5.5.68-linux-x86_64`压缩包提供了一个方便的解决方案,用于在Linux x86_64平台上快速部署和配置MariaDB 5.5.68。通过理解每个文件的作用和使用提供的脚本,你可以轻松地在你的环境...

    MariaDB(mariadb-10.6.7-linux-systemd-x86_64.tar.gz)

    MariaDB(mariadb-10.6.7-linux-systemd-x86_64.tar.gz)适用于Linux x86_64系统 MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护,采用GPL授权许可 MariaDB的目的是完全兼容MySQL,包括API和命令行...

    mariadb-10.6.5-linux-systemd-x86_64.tar.gz

    这个压缩包文件"mariadb-10.6.5-linux-systemd-x86_64.tar.gz"是MariaDB 10.6.5版本的Linux(Systemd)64位安装包,采用tar.gz格式进行压缩,便于在Linux系统中下载和部署。 **MariaDB 10.6.5 知识点** 1. **版本...

    mariadb-10.5.10-rhel-7-x86_64-rpms.tar

    mariadb-10.5.10-rhel-7-x86_64-rpms.tar

    mariadb-repo包

    sudo rpm -ivh mariadb-repo.x86_64.rpm ``` 然后,使用`yum`安装MariaDB: ```bash sudo yum install mariadb-server ``` 对于基于Debian或Ubuntu的系统,使用`apt-get`: ```bash sudo apt-get update...

    mariadb-devel-5.5.68-1.el7.x86_64.rpm

    官方离线安装包,测试可用。请使用rpm -ivh [rpm完整包名] 进行安装

    mariadb-5.5.66-linux-x86_64.tar.gz

    6. **安装与配置**: 安装"mariadb-5.5.66-linux-x86_64"时,通常需要解压tar.gz文件,然后执行编译和安装步骤。在配置过程中,可以调整各种参数来适应特定的硬件和工作负载,如innodb_buffer_pool_size等。 7. **...

Global site tag (gtag.js) - Google Analytics