How to call? The popular CMS WordPress is the target of hackers for vulnerability and malicious exploitation. There are many technologies to protect databases. Changing the database prefix and restricting user permissions are two important steps to enhance security. The
The article will continue below, because this is an open source software to change the table prefix, and the database table name of WordPress is known to all. When installed, the table prefix wp_; will be assigned to all these tables. For example, wp\u comments, wp\u posts, wp\u posteta, etc. Users usually use this default prefix. A quick installer such as softaculous can install scripts quickly and easily. However, wp_uis still the default table prefix. Hackers know this and will inject SQL attacks accordingly. This is simple feeding. Changing the table prefix to random and unpredictable is a good security measure. To change the database table prefix, follow these instructions: The
Keep all backups and start them (there will be articles about backup plug-ins in this series soon), install and activate the change DB prefix plug-in. Go to dashboard > Settings > change DB prefix. Enter any unpredictable table prefix, such as dabra_ (keep it short, up to 4 characters). Click save changes. Fuzzy and elusive table prefixes greatly reduce automatic attacks and malicious scripts running on the site. The wisest way to back up a database is to create regular backups. Always keep up-to-date database backups. Therefore, if there is a problem, you can switch other servers and bring the site online as soon as possible. To create a manual backup in phpMyAdmin: The
Go to cpanel>phpmyadmin. On the left, click database for the site. Click the export tab and select custom as the export method. Then, in the object creation options, select add drop table\/view\/procedure\/function\/event statement. Finally, click move. You can connect the database to the WordPress installation and re import the correct content. But if this is difficult, you can use one of the following plug-ins: The
If you are not familiar with using the male plug-in to create and retain backup phpMyAdmin, or if there is no plug-in on the server, there are many backup plug-ins available to back up dB. Backwpup is a widely used backup plug-in. A powerful plug-in with useful functions of storing backups in Dropbox, server and S3. Let’s use it to create a backup. Install and activate the backup plug-in. If enabled, go to backup> to add a new task. Select the items to back up (XML files, theme and plug-in files, database backups, and so on). The backup format is. Must be in ZIP format. Select to move the archive to a location such as server, email, Dropbox, or S3 service. Save changes. After you create a task, you can run it at any time, create a new backup with the same settings, and send it to the specified location. To schedule regular backups, navigate to the schedule tab on the same page. In the task startup, select use WordPress cron. Define a daily, weekly, or monthly backup schedule at the bottom of the page. Finally, click the Save Changes button. After setting the schedule, you will get a backup from the specified destination during task creation. The
Database user permissions WP config. The MySQL user specified in the PHP file has strict permissions
