Category: wordpress database

Restoring WordPress from a Backup

WordPress is a very simple web application. It is made up of a number of PHP files and a database, typically a MySQL database. The files are the actual web application and the database is where all the information such as users, blog posts, pages and other data is stored. The WordPress setup is so […]

Is WordPress More Secure with a Changed Database Prefix?

A popular WordPress hack to improve WordPress security is to rename the WordPress database prefix. Does this really improve the security of WordPress? Read this article to find out how by changing the WordPress database prefix you can contain attacks even when your WordPress or any other component on it is vulnerable to SQL Injection.

How to Grant Remote Access Privileges to a WordPress MySQL Database

This document explains how to grant remote access to a WordPress or any other MySQL database. Remote access might be needed if you need to extract or read data from the WordPress database from a remote location, for example to read the WordPress security alerts generated by WP Security Audit Log plugin and store them in a centralized logging and monitoring system.

How to Manually Add a WordPress Administrator to the Database using SQL Queries

This WordPress tutorial explains how to manually create a WordPress administrator account directly in the database using SQL queries or phpMyAdmin. This operation is useful to regain access to a hacked WordPress blog or website.

Must Have WordPress Database Tools for Administrators

In this WordPress Webmaster Tip we recommend two automated tools (BigDump and Search Replace DB) that will make your WordPress Admin life easier.

How to Create a WordPress Database from CPanel

If you will install WordPress on shared hosting service such as HostGator, you can create the MySQL database for WordPress from the CPanel. In this easy to follow WordPress tutorial we explain how to create a WordPress database using the CPanel wizard in just 5 steps.

How to Reset a WordPress User Password using phpMyAdmin

You can reset WordPress password using the phpMyAdmin web interface. Follow the three easy steps in this WordPress tutorial to reset a WordPress password within a minute and gain back access to your WordPress blog or website.

How to Apply Secure WordPress MySQL Database Privileges

As seen in Why minimum MySQL user WordPress database privileges improve security, it is very important to assign the minimum required database privileges to the MySQL user being used by WordPress to access the MySQL WordPress database, i.e. the user specified in WordPress wp-config.php file.

Change the WordPress Database Prefix and Improve Security

There are different procedures that you can use to rename the WordPress database prefix. It depends on whether you have already installed WordPress or not. If you have not installed WordPress yet, you can simply specify a different database table prefix from the WordPress installation wizard or pre-define it in the wp-config.php file before running […]

Why minimum MySQL user WordPress database privileges improve security

There are many WordPress security plugins and recommended security settings you can apply to secure your WordPress installation. Since hacking is on the rise, and WordPress websites are being hacked daily, WordPress security is not something that should be overlooked. It is highly recommended to install such plugins and follow the security best practises, or […]