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.

Please Note

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 the warning: database error Column count of mysql.proc is wrong.

In fact, if you use phpMyAdmin, you can't find the error where is the problem?The problem is because you have upgraded the MariaDB or MySQL database version.After upgrading the MariaDB or MySQL database version, the data structures are not finished using the mysql_upgrade command...

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

Upgrade the VestaCP panel's MySQL database to Mariadb 10.4.6 version using a Linux host.Unexpectedly, enter the following command ▼mysql -uroot -p to enter the password to log in to mysql.The following error occurs ▼ERROR 1045 (28000): A…

How to use ConnectBot? ConnectBot detailed configuration instructions skills tutorial

Trying to import the private key into ConnectBot for Android.The key used works fine with Putty but not with ConnectBot.To make it work with ConnectBot, you need to have the OpenSSH version of this file.Fortunately, we can make...