On 12/10/18 4:27 PM, Danny Horne via users wrote: > Managed to get it going (found another log file I didn't know > existed!!). Websites are back up now but it looks like I have much work > to do judging by logged errors - > > 2018-12-11T00:23:09.838450Z 0 [System] [MY-010116] [Server] > /usr/libexec/mysqld (mysqld 8.0.13) starting as process 5200 > 2018-12-11T00:23:11.373458Z 0 [Warning] [MY-010068] [Server] CA > certificate ca.pem is self signed. > 2018-12-11T00:23:11.384224Z 0 [ERROR] [MY-013129] [Server] A message > intended for a client cannot be sent there as no client-session is > attached. Therefore, we're sending the information to the error-log > instead: MY-001146 - Table 'mysql.component' doesn't exist > 2018-12-11T00:23:11.384307Z 0 [Warning] [MY-013129] [Server] A message > intended for a client cannot be sent there as no client-session is > attached. Therefore, we're sending the information to the error-log > instead: MY-003543 - The mysql.component table is missing or has an > incorrect definition. > 2018-12-11T00:23:11.455427Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.user]. > 2018-12-11T00:23:11.455478Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.db]. > 2018-12-11T00:23:11.455487Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.tables_priv]. > 2018-12-11T00:23:11.455495Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.columns_priv]. > 2018-12-11T00:23:11.455503Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.procs_priv]. > 2018-12-11T00:23:11.455511Z 0 [Warning] [MY-010929] [Server] Storage > engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. > 2018-12-11T00:23:11.456005Z 0 [ERROR] [MY-013143] [Server] Column count > of mysql.user is wrong. Expected 50, found 45. The table is probably > corrupted > 2018-12-11T00:23:11.456042Z 0 [Warning] [MY-010966] [Server] ACL table > mysql.role_edges missing. Some operations may fail. > 2018-12-11T00:23:11.456050Z 0 [Warning] [MY-010966] [Server] ACL table > mysql.default_roles missing. Some operations may fail. > 2018-12-11T00:23:11.456058Z 0 [Warning] [MY-010966] [Server] ACL table > mysql.global_grants missing. Some operations may fail. > 2018-12-11T00:23:11.456065Z 0 [Warning] [MY-010966] [Server] ACL table > mysql.password_history missing. Some operations may fail. > 2018-12-11T00:23:11.458828Z 0 [Warning] [MY-010315] [Server] 'user' > entry 'root@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.458886Z 0 [Warning] [MY-010315] [Server] 'user' > entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.458903Z 0 [Warning] [MY-010315] [Server] 'user' > entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.458920Z 0 [Warning] [MY-010315] [Server] 'user' > entry 'rtadmin@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.458936Z 0 [Warning] [MY-010315] [Server] 'user' > entry 'multi_admin@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.459128Z 0 [Warning] [MY-010323] [Server] 'db' entry > 'performance_schema mysql.session@localhost' ignored in > --skip-name-resolve mode. > 2018-12-11T00:23:11.459145Z 0 [Warning] [MY-010323] [Server] 'db' entry > 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.459155Z 0 [Warning] [MY-010323] [Server] 'db' entry > 'rt rtadmin@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.459165Z 0 [Warning] [MY-010323] [Server] 'db' entry > 'trisect\_multi multi_admin@localhost' ignored in --skip-name-resolve mode. > 2018-12-11T00:23:11.459306Z 0 [Warning] [MY-010311] [Server] > 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve > mode. > 2018-12-11T00:23:11.459325Z 0 [ERROR] [MY-010965] [Server] Missing > system table mysql.global_grants; please run mysql_upgrade to create it. > 2018-12-11T00:23:11.463177Z 0 [Warning] [MY-010330] [Server] > 'tables_priv' entry 'user mysql.session@localhost' ignored in > --skip-name-resolve mode. > 2018-12-11T00:23:11.463210Z 0 [Warning] [MY-010330] [Server] > 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in > --skip-name-resolve mode. > 2018-12-11T00:23:11.465057Z 0 [Warning] [MY-010727] [Server] System > table 'func' is expected to be transactional. > 2018-12-11T00:23:11.467349Z 0 [Warning] [MY-010405] [Repl] Info table is > not ready to be used. Table 'mysql.slave_master_info' cannot be opened. > 2018-12-11T00:23:11.467390Z 0 [ERROR] [MY-010422] [Repl] Error in > checking mysql.slave_master_info repository info type of TABLE. > 2018-12-11T00:23:11.467404Z 0 [ERROR] [MY-010415] [Repl] Error creating > master info: Error checking repositories. > 2018-12-11T00:23:11.467413Z 0 [ERROR] [MY-010426] [Repl] Slave: Failed > to initialize the master info structure for channel ''; its record may > still be present in 'mysql.slave_master_info' table, consider deleting it. > 2018-12-11T00:23:11.467422Z 0 [ERROR] [MY-010529] [Repl] Failed to > create or recover replication info repositories. > 2018-12-11T00:23:11.469538Z 0 [System] [MY-010931] [Server] > /usr/libexec/mysqld: ready for connections. Version: '8.0.13' socket: > '/var/lib/mysql/mysql.sock' port: 3306 Source distribution. > 2018-12-11T00:23:11.537075Z 0 [System] [MY-011323] [Server] X Plugin > ready for connections. Socket: '/var/lib/mysql/mysqlx.sock' > bind-address: '::' port: 33060 Yup. Some of those are fixable via mysql_upgrade, others are fairly important and appear to be caused by using a newer mysqld that's not backwards compatible with your previous version. You didn't say which version of MySQL you were running before and whether 8.0.13 was compatible with it. Generally, the website has info on what's compatible and how to convert from old to new. The entry that bothers me the most is the Column count of mysql.user is wrong. Expected 50, found 45. The table is probably corrupted message. That's going to need fixing. Also, how did you get it to start? ---------------------------------------------------------------------- - Rick Stevens, Systems Engineer, AllDigital ricks@xxxxxxxxxxxxxx - - AIM/Skype: therps2 ICQ: 226437340 Yahoo: origrps2 - - - - Better to understand a little than to misunderstand a lot. - ---------------------------------------------------------------------- _______________________________________________ users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx
