The update from MySQL 5.7 to 8.0 failed

[plumdesign]

This is the log:

Starting process with log file at /var/cpanel/logs/mysql_upgrade.20230215-142519/upgrade_mysql_with_status.log
Obtained version information from system.
(XID x6bhyj) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2))
Ensuring the “Mysql80” repository is available and working.
distro does not use package modules; ignoring request to disable mysql
distro does not use package modules; ignoring request to disable mariadb
checkyum version 22.3 (excludes: bind-chroot)
Ensuring that the package “coreutils” is available.
The package “coreutils” version “8.22-24.el7_9.2” is already installed.
Ensuring that the package “grep” is available.
The package “grep” version “2.20-3.el7” is already installed.
Ensuring that the package “mysql-community-devel” with version matching “8.0” is available.
Ensuring that the package “mysql-community-libs-compat” with version matching “8.0” is available.
Ensuring that the package “mysql-community-server” with version matching “8.0” is available.
Ensuring that the package “perl-DBI” is available.
The package “perl-DBI” version “1.627-4.el7” is already installed.
Ensuring that the package “shadow-utils” is available.
The package “shadow-utils” version “4.6-5.el7” is already installed.
The “Mysql80” repository is available and working.
Installing pre-known Mysql dependencies.
Installed pre-known Mysql dependencies.

 

[cPRex]

Hey there! This seems like a problem with the current installation, and not an issue with the upgrade. If you just type "mysql" on the server's command line, do you get a similar error?

if so, can you try using the WHM >> MySQL Root Password tool to reset that and see if that gets the access working?

 

[plumdesign]

# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

===
password

Updated the password for the active MySQL profile.
MySQL password change failed!!
A forced reset will now be attempted.

Attempting MySQL Root Password Reset

 

[plumdesign]

i have 140.000 generated processes in 2 hours. for ex.

157808 (Trace) (Kill)

mysql

0

10.45

0.20

/usr/sbin/mysqld --defaults-file=/etc/my.cnf --validate-config

server is blazing fast (2xXEON Gold) and for 2 hours it keeps going. How to stop this - after reboot it continues.

 

[cPRex]

Can you let me know what output led to the data from the last post? That format doesn't look familiar to me.

 

[plumdesign]

thank for response cPRex.
This is table row copied from WHM process manager. I have stopped the proces (power off of the server helped). i have removed all mysql installation programs and reinstalled mysql from terminal and it works.

now it works in version 8 .... but I cannot create the user - the pass cloQFoQ)M!dY is auto-generated (mode set is 0 during instalation) but it somehow fails (see this log message)

"
MySQL” database “mysql”: 1819 (Your password does not satisfy the current policy requirements)
[2023-02-15 18:34:33 -0100] warn [cpwrapd] GRANT statement “CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'cloQFoQ)M!dY';” failed:
[2023-02-15 18:34:33 -0100] warn [cpwrapd] Error from MySQL query: (XID 7tq6su) The system received an error from the “MySQL” database “mysql”: 1410 (You are not allowed to create a user with GRANT)
"

 

[cPRex]

Reinstalling is likely not the best way to solve this issue, as many of the cPanel system tables may not be included.

Can you open a ticket with our team so we can take a look at the system for you?

 

[plumdesign]

i have solved the problem
mysql> UNINSTALL COMPONENT 'file://component_validate_password';
Query OK, 0 rows affected (0.00 sec)

and reinstalled component - something was wrong with it
... but you might be right - i expect futher problems in MySQL usage.