Five Practical phpMyAdmin skills in WordPress Database Management

WordPress has a wide range of plug-ins and themes. It has been widely used by many bloggers and is not limited to blogs. Many commercial websites and enterprise websites use wordpressg to build their own blogs, wordPress uses the MySQL database. In the daily writing process, some operations on the MySQL database are sometimes involved. Although the modification of plug-ins and code can also help us solve the problem, it is also necessary to use phpMyAdmin to perform data operations freely and reasonably.

What operations does phpMyAdmin help us? This article describes several useful operations for WordPress:

1. Back up the database

Database Backup is very necessary for our webmaster. This network storm involves many webmasters. If the website is backed up, it can be restored within a short period of time, your website is over. Of course, you can also use the WP-db-Backup plug-in to perform database backup conveniently. Wordpress users can install this plug-in and regularly back up data.

2. quickly delete spam comments

WordPress is highly interactive and one of its advantages. It can be exploited by many spam ads. However, you can solve this problem by using a simple Delete statement, run the following command:

Delete from wp_comments where comment_approved = '0 ′;

All spam ads can be deleted.

3. manually reset the password

To increase security, WordPress automatically generates secrets that are hard to crack. However, sometimes bloggers forget their passwords, you can use phpMyAdmin to change the password again. Use the following command:

Update 'wp _ users' set 'user _ pass' = MD5 ('Password') Where 'wp _ users'. 'user _ login' = 'admin' limit 1;

In this way, the password is successfully modified.