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 […]
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 […]
Fixing “Error Establishing a Database Connection” in WordPress
WordPress database connection problems are very common, especially when installing, upgrading and migrating a site. However, they can also occur on other occasions. If you have a WordPress site you’ve surely seen the error establishing database connection: WordPress database connectivity problems can be solved very easily. This article explains how to use our database connection […]