Re: Upgrade Error

[Michael Perdue]

I have version 5.7.37 installed and running for a couple of informational websites. All using root and a single password.

I have done the check tables, and mysql upgrade commands.

I have tried several installers including versions a couple higher than 5.7.37. I am currently trying to use the latest 8.0.28.

mysql workbench installed no problem.

Goes to upgrade mysql and it asks for the password for root@localhost. Enter it and select check and says it's good. It's the same password I use to access with the websites and the same password I can log in using command prompt.

When it gets down to backup mysql data base it errors out with :

Beginning configuration step: Writing configuration file

Saving installer_config.xml configuration file...
Saved installer_config.xml configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Updating existing service
Existing service updated
Ended configuration step: Adjusting Windows service

Beginning configuration step: Backing up MySQL database

Starting MySQL Server in order to run the mysql_upgrade tool.
Warning: There may be some errors thrown by MySQL Server, the mysql_upgrade tool is going to be run next to attempt to fix database incompatibilities.
Starting process for MySQL Server 5.7.37...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console...
Process for mysqld, with ID 5680, has been started successfully and is running.
Successfully started process for MySQL Server 5.7.37.
2022-02-09T23:45:33.427166Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-02-09T23:45:33.427372Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-02-09T23:45:33.434118Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.37-log) starting as process 5680 ...
2022-02-09T23:45:33.449252Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-09T23:45:33.449682Z 0 [Note] InnoDB: Uses event mutexes
2022-02-09T23:45:33.449951Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2022-02-09T23:45:33.450273Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-09T23:45:33.450683Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2022-02-09T23:45:33.451992Z 0 [Note] InnoDB: Number of pools: 1
2022-02-09T23:45:33.452755Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-02-09T23:45:33.461750Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-02-09T23:45:33.464174Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-09T23:45:33.566343Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-02-09T23:45:33.571879Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 57753438315
2022-02-09T23:45:33.572265Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 57753438324
2022-02-09T23:45:33.572593Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-02-09T23:45:33.572981Z 0 [Note] InnoDB: Starting crash recovery..
2022-02-09T23:45:39.047291Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-09T23:45:39.047934Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-09T23:45:39.049313Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-09T23:45:39.125156Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-02-09T23:45:39.149151Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-02-09T23:45:39.149725Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-02-09T23:45:39.151395Z 0 [Note] InnoDB: Waiting for purge to start
2022-02-09T23:45:39.214242Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5747ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2022-02-09T23:45:39.215074Z 0 [Note] InnoDB: 5.7.37 started; log sequence number 57753438324
2022-02-09T23:45:39.217011Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-02-09T23:45:39.217578Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2022-02-09T23:45:39.483696Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-02-09T23:45:39.484264Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-02-09T23:45:39.484528Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-02-09T23:45:39.484767Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-02-09T23:45:39.488595Z 0 [Warning] CA certificate ca.pem is self signed.
2022-02-09T23:45:39.489591Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-02-09T23:45:39.490703Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-02-09T23:45:39.491679Z 0 [Note] IPv6 is available.
2022-02-09T23:45:39.491987Z 0 [Note] - '::' resolves to '::';
2022-02-09T23:45:39.492617Z 0 [Note] Server socket created on IP: '::'.
2022-02-09T23:45:39.700683Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220209 18:45:39
2022-02-09T23:45:39.709884Z 0 [Note] Failed to start slave threads for channel ''
2022-02-09T23:45:39.764598Z 0 [Note] Event Scheduler: Loaded 0 events
2022-02-09T23:45:39.765635Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.37-log' socket: '' port: 3306 MySQL Community Server (GPL).
Running mysqldump tool to backup the database...
Backup files will be dumped to "C:\ProgramData\MySQL\MySQL Server 5.7\Backup\mysql_dump-2022-02-09T18.45.41.sql".

Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe --defaults-extra-file="C:\Users\Administrator\AppData\Local\Temp\4f031789-2116-417a-b684-f32bf02a6f2f.ini" --user=root --host=localhost --port=3306 --default-character-set=utf8 --routines --events --single-transaction=TRUE --all-databases --result-file="C:\ProgramData\MySQL\MySQL Server 5.7\Backup\mysql_dump-2022-02-09T18.45.41.sql"...
2022-02-09T23:45:42.472764Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES)
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Process for mysqldump, with ID 680, was run successfully and exited with code 2.
Ended configuration step: Backing up MySQL database



it seems to error out on access denied for root when accessing mysqldump. Any suggestions to fix?