MySQL Manager in CWP not working

What do you get when you run:

Code: [Select]

mysql -V
Please post it here.

mysql -V
mysql  Ver 15.1 Distrib 10.11.9-MariaDB, for Linux (x86_64) using readline 5.1

Try running:

Code: [Select]

mysql_upgrade --force
Then:

Code: [Select]

sh /scripts/mysql_fix_myisam_tables

If that fails, reimage it to the basic AlmaLinux 9.4, and leave it.
Sen me a PM with the IP & root PW, and I'll login and get the system installed and updated (No I'm not going to charge)

 mysql_upgrade --force
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

Since you have client data already, the only thing I could suggest if to open a paid support ticket with CWP, it's $7.49 for a one-time support, and see if they might be able to login and fix whatever has gotten corrupted at this point.

Here is the link:
https://support.centos-webpanel.com/index.php?rp=/store/support-onetime

Hopefully they might be able to get it sorted out for you.

Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

Run:

Code: [Select]

ls -ld /var/lib/mysql
ls -l /var/lib/mysql

in shell as root and show output.

Anyway, it doesn't look like CWP problem.

Moreover, to update the database of MariaDB 10.6+ the following command must be executed:

Code: [Select]

mariadb-upgrade
Run it and look for result.