Re: Upgrade Error
Posted by: Michael Perdue
Date: February 09, 2022 08:40PM

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?

Options: ReplyQuote

Written By
March 12, 2021 06:11PM
March 12, 2021 07:44PM
March 12, 2021 08:12PM
March 12, 2021 08:26PM
March 14, 2021 10:01AM
March 12, 2021 09:24PM
February 09, 2022 09:22PM
February 09, 2022 09:24PM
February 09, 2022 09:31PM
February 10, 2022 01:55PM
February 11, 2022 01:04PM
February 11, 2022 01:06PM
February 11, 2022 01:13PM
February 11, 2022 03:15PM
February 12, 2022 08:16PM
February 12, 2022 09:10PM
Re: Upgrade Error
February 09, 2022 08:40PM

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.