The update from MySQL 5.7 to 8.0 failed
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.
-
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? 0 -
# 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 0 -
i have 140.000 generated processes in 2 hours. for ex.
server is blazing fast (2xXEON Gold) and for 2 hours it keeps going. How to stop this - after reboot it continues.157808 (Kill) mysql 0 10.45 0.20 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --validate-config 0 -
Can you let me know what output led to the data from the last post? That format doesn't look familiar to me. 0 -
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) " 0 -
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? 0 -
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. 0
Please sign in to leave a comment.
Comments
7 comments