Re: MySQL Server 8.0.29 failed install (server won't start)
Posted by: Randy A
Date: July 21, 2022 04:51PM

Just for jun, I tried to install MySQL 5.7 instead of 8.0. Ran into the exact same wall. But, it created a much more verbose error log. I thought maybe it could help analyse the problem. I know you guys are busy, but, multiple people have had and\or are still stuck due to this issue. I have a website I can't set up because I'm waiting for a solution. I have also been searching everything I can to find a solution. No luck.

Because the file was to large to post in it's entirety, I deleted the table setup commands and hundreds of duplicate lines near the end.

______________________________________________________________________________


C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe, Version: 5.7.38-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
2022-07-21T22:27:20.146738Z 1 Query CREATE DATABASE mysql;

2022-07-21T22:27:20.147609Z 1 Query USE mysql;

2022-07-21T22:27:20.147946Z 1 Query set sql_mode='';

2022-07-21T22:27:20.148175Z 1 Query set default_storage_engine=myisam;

2022-07-21T22:27:20.149314Z 1 Query CREATE TABLE IF NOT EXISTS db ( Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(32) binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Event_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Trigger_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='Database privileges';
2022-07-21T22:27:20.727521Z 1 Query SET @str=IF(@have_ndbinfo <> 0, @cmd, 'SET @dummy = 0;');

2022-07-21T22:27:20.727557Z 1 Query PREPARE stmt FROM @str;

2022-07-21T22:27:20.727582Z 1 Prepare SET @dummy = 0
2022-07-21T22:27:20.727595Z 1 Query EXECUTE stmt;

2022-07-21T22:27:20.727605Z 1 Execute SET @dummy = 0
2022-07-21T22:27:20.727621Z 1 Query DROP PREPARE stmt;

2022-07-21T22:27:20.727646Z 1 Query SET @str=IF(@have_ndbinfo,'CREATE OR REPLACE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `ndbinfo`.`blocks` AS SELECT block_number, block_name FROM `ndbinfo`.`ndb$blocks`','SET @dummy = 0');

2022-07-21T22:27:20.727665Z 1 Query PREPARE stmt FROM @str;

2022-07-21T22:27:20.727682Z 1 Prepare SET @dummy = 0
2022-07-21T22:27:20.727690Z 1 Query EXECUTE stmt;

2022-07-21T22:27:20.727699Z 1 Execute SET @dummy = 0
2022-07-21T22:27:20.727711Z 1 Query DROP PREPARE stmt;

2022-07-21T22:27:20.727730Z 1 Query SET @str=IF(@have_ndbinfo,'CREATE OR REPLACE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `ndbinfo`.`dict_obj_types` AS SELECT type_id, type_name FROM `ndbinfo`.`ndb$dict_obj_types`','SET @dummy = 0');

2022-07-21T22:27:20.727747Z 1 Query PREPARE stmt FROM @str;

2022-07-21T22:27:20.727758Z 1 Prepare SET @dummy = 0
2022-07-21T22:27:20.727763Z 1 Query EXECUTE stmt;

2022-07-21T22:27:20.727768Z 1 Execute SET @dummy = 0
2022-07-21T22:27:20.727774Z 1 Query DROP PREPARE stmt;

2022-07-21T22:27:20.727786Z 1 Query SET @str=IF(@have_ndbinfo,'CREATE OR REPLACE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `ndbinfo`.`config_params` AS SELECT param_number, param_name FROM `ndbinfo`.`ndb$config_params`','SET @dummy = 0');

2022-07-21T22:27:20.727794Z 1 Query PREPARE stmt FROM @str;

2022-07-21T22:27:20.727807Z 1 Prepare SET @dummy = 0
2022-07-21T22:27:20.727823Z 1 Query EXECUTE stmt;

2022-07-21T22:27:20.727829Z 1 Execute SET @dummy = 0
2022-07-21T22:27:20.727839Z 1 Query DROP PREPARE stmt;

2022-07-21T22:27:20.727852Z 1 Query SET @str=IF(@have_ndbinfo,'SET @@global.ndbinfo_offline=FALSE','SET @dummy = 0');

2022-07-21T22:27:20.727862Z 1 Query PREPARE stmt FROM @str;

2022-07-21T22:27:20.727873Z 1 Prepare SET @dummy = 0
2022-07-21T22:27:20.727879Z 1 Query EXECUTE stmt;

2022-07-21T22:27:20.727883Z 1 Execute SET @dummy = 0
2022-07-21T22:27:20.727889Z 1 Query DROP PREPARE stmt;

2022-07-21T22:27:20.727915Z 1 Query FLUSH PRIVILEGES
2022-07-21T22:27:20.732528Z 1 Query CREATE USER root@localhost;

2022-07-21T22:27:20.732966Z 1 Query CREATE USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password'
2022-07-21T22:27:20.733126Z 1 Query GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.733442Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.733524Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764030Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764138Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764223Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764289Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764370Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.764436Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.770418Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.770583Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:20.770696Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.053845Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.053871Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.053896Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.053922Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.053945Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.055190Z 1 Query GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
2022-07-21T22:27:21.055433Z 1 Query CREATE USER 'mysql.session'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE' ACCOUNT LOCK
2022-07-21T22:27:21.055559Z 1 Query CREATE USER 'mysql.session'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE' ACCOUNT LOCK
2022-07-21T22:27:21.056112Z 1 Query GRANT SELECT ON `mysql`.`user` TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.056352Z 1 Query GRANT SELECT ON `performance_schema`.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.056449Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.508574Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.508641Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.508766Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.508829Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.508919Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
'mysql.session'@'localhost'
2022-07-21T22:27:21.512916Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.513161Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'
2022-07-21T22:27:21.513304Z 1 Query GRANT SUPER ON *.* TO 'mysql.session'@'localhost'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Server 8.0.29 failed install (server won't start)
214
July 21, 2022 04:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.