How to clean huge wp_options in SQL - Transients, wpseo_sitemap _cache_validator
WordPress is a fairly light CMS for web servers. Minimum hardware resource requirements and a web server with...
MySQL
How to quickly delete all WooCommerce Orders [SQL Tips]
How to delete fast all orders in WooCommerce. Dashboard & SQL Tips.
Fix Error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress
"Your PHP installation appears to be missing the MySQL extension which is required by WordPress" is an error encountered by ...
Import .SQL File Error - MySQL server has gone away
When we import large .SQL files into a database, the classic method via phpMyAdmin it's not a...
Fix phpMyAdmin Import SQL - Unknown collation: 'utf8mb4_unicode_520_ci'
The import problem via phpMyAdmin or from SSH (with command line for import) of databases or...
How can we add a user Admin in WordPress if we do not have access to Dashboard or SQL
There are situations in which we need to "take over" a blog / website on WordPress, but we don't have a lot of data...
[Fix phpMyAdmin] The configuration file now needs a secret passphrase (blowfish_secret)
Regardless of whether phpMy is installedAdmin on an Ubuntu server, CentOS or etc. Fedora distribution, the message “The configuration file now needs a...
Import large databases (.SQL) by changing upload size limit (2048 KiB) from phpMyAdmin.
When we work with databases, the most handy is phpMyAdmin, which provides us with support from...
Recover MySQL Server root Password
The most important user of a MySQL server is definitely the "root" user. The user who has all the privileges adminincentives for...
MySQL Server - How to change / set the root user password via SSH.
How can we set or change the MySQL password for the root user. After installing MySQL server on Linux, ...