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'