mysql mariadb libs_mysql 安装 【解决】mariadb-libs is obsoleted by *** - Ctrl+C&Ctrl+V - ITeye博客...

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

问题

[root@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]# rpm -qa | grep postfix

postfix-2.10.1-6.el7.x86_64

[root@fdf◇◇ysql1 ~]# rpm -qa | grep mariadb

mariadb-libs-5.5.56-2.el7.x86_64

[root@fdf◇◇ysql1 ~]# rpm -ev postfix-2.10.1-6.el7.x86_64

Preparing packages...

postfix-2:2.10.1-6.el7.x86_64

[root@fdf◇◇ysql1 ~]# rpm -ev mariadb-libs-5.5.56-2.el7.x86_64

Preparing packages...

mariadb-libs-1:5.5.56-2.el7.x86_64

结果：

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]# 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@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]# 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◇◇ume 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

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]#

[root@fdf◇◇ysql1 ~]# setenforce 0

setenforce: SELinux is disabled

[root@fdf◇◇ysql1 ~]# service mysqld start

Starting mysqld (via systemctl): [ OK ]

[root@fdf◇◇ysql1 ~]# 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;

捐助开发者

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

谢谢您的赞助，我会做的更好！