How to solve phpMyAdmin displaying MySQL/MariaDB data table in use?

使用Wordpressfriend, inphpMyAdminWhen closing comments on a WordPress site in bulk, a bunch of English prompts pop up…

It usually means let's fix the table, and then tragedy strikes...

Next, checking the database structure shows that it is "in use"...

As shown in the screenshot below▼

at this timeE-commerceThe website cannot be accessed, and it will definitely cause a lot of losses...

don't know how to useVestaCPHave friends of the panel encountered a similar situation?

• When phpMyAdmin checks, optimizes and repairs data tables, it can't solve...
• The problem is because the permissions are not enough, so we need to re-grant the permissions.

how to grantMySQL/MariaDB data table permissions?

Step 1:use SSHsoftwareEnter the following command▼

chown mysql:mysql -R /usr/local/mysql/

chown mysql:mysql -R /data/mysql/

• at this time,MySQL/MariaDB data table permissions will be reassigned.

Step 2:Open phpMyAdmin and switch to that database.

Step 3:Select the data table that is "in use".

Step 4:Click "Repair Table" below.

• Finally you can see that the data table is back to normal.

Attention points

Chen WeiliangSuggest:

• You must develop a good habit of regularly backing up your website database, and you must deeply understand this.
• Otherwise, once the MySQL/MariaDB data table crashes again, you don't have a backup, so don't regret it!

MOREMySQL databaseFor problems and solutions, please click the link below to view▼

🔗Solve warning: Database error Column count of mysql.proc is wrong.

🔗Solution to ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

🔗How to use ConnectBot? ConnectBot detailed configuration instructions and tips tutorial