Check all MySQL Databases on Plesk Linux via SSH/Command Line

Should you require a thorough database check and repair, you will need the MySQL root password, but often this is not known to Plesk users.

Here's the best way to check and repair via SSH:

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair -A

Remember, don't put a space after "-p" and back quotes matter!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Do I use localhost or remotemysqlhost for my mysql connection?

You can view whether your account is using localhost or remotemysql host in your cPanel account....

How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...

How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

How do I create a MySQL database?

To create a MySQL database please follow the steps below:- Login to your control panel at...