Tag : delete

Blog

Remove Permissions for a MySQL User on Linux via Command Line

Viking Coin
MySQL via Command Line 102: Basic User Interaction Create a MySQL User on Linux via Command Line Grant Permissions to a MySQL User on Linux via Command Line Remove Permissions for a MySQL User on Linux via Command Line Remove a MySQL User on Linux via Command Line Previous Series:MySQL......
Blog

How to Backup, Delete and Restore a PostgreSQL Database in CentOS 7 or Ubuntu 16

Viking Coin
Listing databases Dump a database Dumping all databases Dump Grants Delete or Drop a Database Delete a Grant Restore a Database Restore Grant   PostgreSQL is an excellent alternative database engine to MySQL or MariaDB, but managing those databases is very different, especially for those system administrators who are very use......
Blog

Delete Posts and Comments from Action Scheduler

Viking Coin
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. WP-CLI makes it easy to delete posts and comments which have been created by the......
Blog

Grant Permissions to a MySQL User on Linux via Command Line

Viking Coin
MySQL via Command Line 102: Basic User Interaction Create a MySQL User on Linux via Command Line Grant Permissions to a MySQL User on Linux via Command Line Remove Permissions for a MySQL User on Linux via Command Line Remove a MySQL User on Linux via Command Line Previous Series:......
Blog

Troubleshooting: MySQL/MariaDB Error #1044 & #1045 Access Denied for User

Viking Coin
When using phpMyAdmin, it’s essential to have the correct user permissions to create edits/writes to the database.  Otherwise insufficent 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,......