Tag: delete

Preflight Check

• These instructions are intended for granting a MySQL user permissions on Linux via the command line
• I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I'll be logged in as root.

Login to MySQL

First we'll log in to the MySQL server from the command line with the following command:

There may be times when you need to clean up post revisions created on your site. This is possible, using the commands already available in WP-CLI.

When using PhpMyAdmin, it’s essential to have the correct user permissions to create edits/writes to the database.  Otherwise, insufficient permissions can lead to  errors like the ones pictured below “#1044 – Access denied for user …[using password: YES]” and “#1045 – Access denied for user…[using password: YES]”.  In our tutorial, we’ll show you how to correct this issue using the command line terminal.  Let’s get started!

The Action Scheduler is a background processing, queue job runner which is built into WooCommerce core. A number of plugins use the Action Scheduler, WooCommerce Subscriptions and WooCommerce Follow-Ups being two of the best known.

Table of Contents

Listing databases
Dump a database
Dumping all databases
Dump Grants
Delete or Drop a Database
Delete a Grant
Restore a Database
Restore Grant

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.  Let’s learn how to remove a user from a database.