passwords - mysqld.log 中没有临时密码

Question

我使用了 mysql 5.7.16 社区和 centos 7。

我正在关注视频 tutorial安装mysql:

wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

yum localinstall dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

启用 yum repolist | grep "mysql.-community."

yum 安装 mysql-社区服务器

服务 mysqld 启动

启动mysql后，我可以看到状态为 service mysqld status处于事件状态(正在运行) .

但是我无法通过以下方式获得任何东西: grep 'temporary password' /var/log/mysqld.log
msyqld.log(忽略正常日志):

[Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists.
mysqld: Table 'mysql.plugin' doesn't exist

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

[Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists.
mysqld: Table 'mysql.gtid_executed' doesn't exist

[Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

[Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists.

[Warning] Failed to open optimizer cost constant tables

[Warning] InnoDB: Cannot open table mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the table exists.

[Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them

[Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists.

[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

感谢任何帮助!

Answer 1

我想通了。

我安装了centos 7，选择了mysql，mysql版本是5.5。

删除它: yum remove mysql-serverl。

通过本教程安装 5.7.16。

有这些错误。

Yum 删除 mysql-community-server，重新安装 5.7。

还是有这些错误。

Yum 删除 mysql-community-server，但删除目录/var/lib/mysql。

然后再安装，就可以了。

关键是需要手动删除/var/lib/mysql。