Upgrading from MySql 5.7 --> 8.0 Problems

[Dave Sawyer]

Hi,

I am using the WHM gui to upgrade MySql 5.7 --> 8.0 but get the following error message when running the upgrade checker utility - see image attached.

Additionally in the mysqld.log file the following has been logged:

2023-09-07T19:46:22.462796Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230907 20:46:22
2023-09-07T19:46:32.740746Z 2 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-09-07T19:46:32.743798Z 3 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-09-07T19:48:14.957606Z 14 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-09-07T19:48:14.961019Z 15 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-09-07T19:55:24.957629Z 39 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2023-09-07T19:55:24.960758Z 40 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)

Any ideas?

Many Thanks

Dave

 

[cPRex]

Hey there! Two thoughts on this one:

1 - Are you logged in as the root user and not a reseller?
2 - If "yes" to #1, can you try using the WHM >> MySQL Root Password page to reset the root MySQL password and see if that takes care of it?