Mass repair and optimize all MySQL databases

Q) How can I mass optimize repair & optimize on my MySQL  databases?

A) open SSH and connect to your server.
Run the following command:

mysqlcheck -u root -p --auto-repair --optimize --all-databases

it will ask you for your MySQL root password, if you do not know this then Login to WHM as root user, on the left type MySQL and click MySQL Root password.  Enter a new password and save.
Don't worry this won't break anything!

then go back to SSH and try again.

Recent Posts
FTP error Failed to retrieve directory listing

Question) When I connect to FTP I get this error: Command: LISTError: Connection timed outError:...

Enabling full features of softaculous

Softaculous is installed with the free version by default on your CPanel VPS.  To Enable the...

How can I repair settings on my Cpanel VPS/Dedicated server

q) how do i fix/repair permissions on cpanel servers? a) login as root. Below is a list of...