MySQL Manager in CWP not working

[Starburst]

What do you get when you run:

Code Select Expand

mysql -V

Please post it here.

[mabdala68]

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

[Starburst]

Try running:

Code Select Expand

mysql_upgrade --force

Then:

Code Select Expand

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)

[mabdala68]

 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

[Starburst]

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.

[cyberspace]

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 Expand

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 Expand

mariadb-upgrade

Run it and look for result.