我是靠谱客的博主 笨笨海燕,最近开发中收集的这篇文章主要介绍mysql 5.7 mysql init_mysql 5.7安装过程中,初始化的问题,觉得挺不错的,现在分享给大家,希望可以做个参考。

概述

2017-07-27T03:41:16.224833Z 0 [Warning] InnoDB: New log files created, LSN=45791mysqld:Table 'mysql.plugin' doesn't exist

mysqld: Table'mysql.gtid_executed'doesn't exist2017-07-27T03:41:16.371369Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed'cannot be opened.2017-07-27T03:41:16.413614Z 0 [Warning] CA certificate ca.pem isself signed.2017-07-27T03:38:27.049543Z 3 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.

2017-07-27T03:38:27.050140Z 3 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.

2017-07-27T03:40:01.619183Z mysqld_safe mysqld from pid file /data/mysql/barry_mysql/tmp/mysql.pid ended2017-07-27T03:41:04.955142Z mysqld_safe Logging to '/data/mysql/barry_mysql/logs/barry-mysql.err'.2017-07-27T03:41:05.040377Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/barry_mysql/data2017-07-27T03:41:05.190872Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.100 200 300 400 500 600 700 800 900 1000

100 200 300 400 500 600 700 800 900 1000

100 200 300 400 500 600 700 800 900 1000

100 200 300 400 500 600 700 800 900 1000

2017-07-27T03:41:16.224833Z 0 [Warning] InnoDB: New log files created, LSN=45791

2017-07-27T03:41:16.275795Z 0 [Warning] InnoDB: Creating foreign key constraintsystem tables.2017-07-27T03:41:16.366508Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how toresolve the issue.

mysqld:Table 'mysql.plugin' doesn't exist

2017-07-27T03:41:16.366637Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to createit.2017-07-27T03:41:16.371317Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how toresolve the issue.

mysqld:Table 'mysql.gtid_executed' doesn't exist

2017-07-27T03:41:16.371369Z 0 [Warning] Gtid table is not ready to be used. Table'mysql.gtid_executed'cannot be opened.

2017-07-27T03:41:16.413614Z 0 [Warning] CA certificate ca.pem is self signed.

2017-07-27T03:41:16.415576Z 0 [Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.415629Z 0 [Warning] Failed to open optimizer cost constant tables

2017-07-27T03:41:16.416613Z 0 [Warning]'user'entry'root@localhost'ignored in --skip-name-resolve mode.

2017-07-27T03:41:16.416702Z 0 [Warning]'user'entry'mysql.sys@localhost'ignored in --skip-name-resolve mode.

2017-07-27T03:41:16.416761Z 0 [Warning]'db'entry'sys mysql.sys@localhost'ignored in --skip-name-resolve mode.

2017-07-27T03:41:16.416792Z 0 [Warning]'proxies_priv'entry'@ root@localhost'ignored in --skip-name-resolve mode.

2017-07-27T03:41:16.416986Z 0 [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. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.417023Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them

2017-07-27T03:41:16.417647Z 0 [Warning]'tables_priv'entry'sys_config mysql.sys@localhost'ignored in --skip-name-resolve mode.

2017-07-27T03:41:16.417846Z 0 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.417874Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

2017-07-27T03:41:16.418373Z 0 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.418579Z 0 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.418763Z 0 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.

2017-07-27T03:41:16.418798Z 0 [Warning] Info table is not ready to be used. Table'mysql.slave_master_info'cannot be opened.

2017-07-27T03:41:16.418819Z 0 [ERROR] Error in checking mysql.slave_master_info repository info type of TABLE.

2017-07-27T03:41:16.418833Z 0 [ERROR] Error creating master info: Error checking repositories.

2017-07-27T03:41:16.418842Z 0 [ERROR] Failed to create or recover replication info repository.

2017-07-27T03:41:16.418857Z 0 [ERROR] Failed to create or recover replication info repositories.

最后

以上就是笨笨海燕为你收集整理的mysql 5.7 mysql init_mysql 5.7安装过程中,初始化的问题的全部内容,希望文章能够帮你解决mysql 5.7 mysql init_mysql 5.7安装过程中,初始化的问题所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(48)

评论列表共有 0 条评论

立即
投稿
返回
顶部