Tag Archives: MySQL
How to clean huge wp_options in SQL – Transients, wpseo_sitemap _cache_validator
A very useful tutorial if you have a website on WordPress whose SQL table wp_options is very large. Clean huge wp_options in SQL...
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" este o eroare intalnita de multi poses...
Import .SQL File Error – MySQL server has gone away
This tutorial solves the error that appears when importing .sql files via the command line. Import .SQL File Error - MySQL server ha...
Fix phpMyAdmin Import SQL – Unknown collation: ‘utf8mb4_unicode_520_ci’
An import problem via phpMyAdmin or from SSH (with command line for import) of databases or archives, which appears especially...
[Fix phpMyAdmin] The configuration file now needs a secret passphrase (blowfish_secret)
Indiferent ca este instalat phpMyAdmin pe un server Ubuntu, CentOS sau etc Fedora distributie, mesajul "The configuration file now...
WordPress wp_options table corrupted / Error establishing a database connection.
Nu am auzit pana acum pe 2015 sa fi fost vreun virus sau exploit de SQL care sa puna "la pamant" sute de site-uri si bloguri WordPress,...
Change Upload Size Limit SQL file in phpMyAdmin
Tutorial that teaches you step by step how to change the accepted size limit for importing SQL files in phpMyAdmin. Helpful at...
How to recover the password for the user root of a SQL server
Step-by-step tutorial to learn how to recover the root password of a SQL server.
The most important user of a server M...
How to change mysql root password to Linux (SSH)
If you are in the situation where you want to change the root password of MySQL in Linux, from this tutorial you will learn step by step how you can do this...
Show database queries total, memory usage & execution time (WordPress)
WordPress is a platform that no longer needs comments. As flexible as WordPress is, it can ask for more...