error when upgrading from 5.7.31 to 5.7.37
Posted by: Kirill K
Date: April 17, 2022 11:38AM

Hello DBA

When I upgrade to a different version and pass all the checks, everything is successful, I pass the root@localhost connection check, everything is ok. But when it comes to updating the database and system tables, I see 3 connection attempts(mysql_upgrade.exe,mysql.exe,mysqladmin.exe) in the log and they are not successful. How to fix it?

I tried to add skip-name-resolve to the ini file, but it didn't help because the installer uses its temporary ini file.

log:
Version: '5.7.37' socket: '' port: 3306 MySQL Community Server (GPL).
Running mysql_upgrade tool...

Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql_upgrade.exe --defaults-extra-file="C:\Users\Administrator\AppData\Local\Temp\295ae72b-2870-4dd8-9ac8-5079d7b47843.ini" --user=root --host=localhost --port=3306 --force --verbose...
2022-04-16T18:43:20.111253Z 2 [Note] Access denied for user 'root'@'::1' (using password: YES)
mysql_upgrade: Got error: 1045: Access denied for user 'root'@'::1' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
Process for mysql_upgrade, with ID 12884, was run successfully and exited with code 11.
Shutting down MySQL Server so that any changes made to the system tables take effect in the next start.
Setting innodb_fast_shutdown to do a clean shutdown (a full purge and a change buffer merge before shutting down).

Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe --defaults-extra-file="C:\Users\Administrator\AppData\Local\Temp\c9776bc2-9156-4f39-9de0-4d9a19c91bac.ini" --user=root --host=localhost --port=3306 -e"SET GLOBAL innodb_fast_shutdown = 0"...
2022-04-16T18:43:20.435141Z 3 [Note] Access denied for user 'root'@'::1' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'::1' (using password: YES)
Process for mysql, with ID 7192, was run successfully and exited with code 1.
There was an error trying to set innodb_fast_shutdown to do a clean shutdown.
Executing mysqladmin shutdown to do a clean shutdown.

Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin.exe --defaults-extra-file="C:\Users\Administrator\AppData\Local\Temp\c9776bc2-9156-4f39-9de0-4d9a19c91bac.ini" --user=root --host=localhost --port=3306 shutdown...
2022-04-16T18:43:20.765133Z 4 [Note] Access denied for user 'root'@'::1' (using password: YES)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'::1' (using password: YES)'
Process for mysqladmin, with ID 16416, was run successfully and exited with code 1.
There was an error trying to perform a clean shutdown.

Stopping MySQL Server instance...
Killing process for MySQL Server 5.7.37, with ID 11880...
Killed process for MySQL Server 5.7.37, with ID 11880.
Running mysql_upgrade tool failed. Please examine the log file for more details.


result: now I see all variables updated to 5.7.37 'show variables like '%version%'. Database with the old version.

Options: ReplyQuote


Subject
Views
Written By
Posted
error when upgrading from 5.7.31 to 5.7.37
216
April 17, 2022 11:38AM


Sorry, only registered users may post in this forum.

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.