Access denied for user ‘root’@’localhost’ after installing MySQL [Fix]
I Installed MySQL server (MariaDB 8.0) on my CentOS 7 using yum. Once started the service and when I tried...
Databases
Incompatible with sql_mode=only_full_group_by [Fix]
While migrating a client website from one WHM/cPanel to another WHM/cPanel, I got an SQL error “Incompatible with sql_mode=only_full_group_by“. Below...mysqldump error access denied while using LOCK TABLES [Solved]
Question: I have been using mysqldump to take a backup of my website. Today the command failed to execute with an...JSON Decoding Failure WP Migrate Plugin error [Solution]
I’m a big fan of WP Migrate plugin for WordPress and that’s reason I use this plugin for migrating my...How to redirect output of MySQL source command to Log file?
Here’s a question from one of our regular reader Mr. Waseem. He wants to know how to redirect output of...Createuser could not connect to database postgres [Fix]
Here’s a question from one of our regular reader Sam. He says that PostgreSQL does not allow to create user...How to Delete all Records of a Table in phpMyAdmin
Recently my client’s WordPress site was flooded with fifteen thousand spam comments & posts. To protect the site, I advised...Why mysql user has bash shell in /etc/passwd?
If you install MySQL on Linux, then a new user account called ‘mysql‘ will be created for running mysqld service....Secure WordPress MySQL database with restricted privileges
Since hacking is on the rise and we have seen in recent times many WordPress websites are getting hacked daily, it...Fix Unknown collation utf8mb4_unicode_ci [WP Migration]
Do you get an error Unknown collation utf8mb4_unicode_ci while migrating your WordPress database? No worries, this tutorial will explain how...How to Disable Secure_file_priv option in MySQL – Linux
If you are getting an error “The MySQL server is running with the secure_file_priv option so it cannot execute this...How to disable MySQL Password Validation plugin
I had recently Installed MySQL v5.7 on Debian 8 Jessie. After the successful installation of MySQL, to improve the security of...How to update GPG key for MySQL APT repository on Debian/Ubuntu?
If you are getting an error “GPG error and Duplicate sources.list” while configuring MySQL repository for installing MySQL server version...How to Install MySQL v5.7 using apt-get on Debian 8 Jessie
This tutorial will explain how to install MySQL v5.7 on Debian 8 Jessie server. The default repositories in Debian 8 will...Unknown column password_last_changed in ‘mysql.user’ [Solved]
Question: After upgrading MySQL to version 5.7, I’m not able to create a user or set password using GRANT query. Here’s the...Change MySQL engine type of all tables from MyISAM to InnoDB
Do you want to change MySQL engine type of a table from MyISAM to InnoDB? Well, it can be done...MySQL Table Crash fix – marked as crashed and should be repaired?
One of the table in my MySQL database has been corrupted and the worst part of it is, the corrupted...Failed to start PostgreSQL database server – Unregistered Authentication Agent for unix-process [Solved]
Question: I got an error ‘Failed to start PostgreSQL database server – Unregistered Authentication Agent for unix-process‘ while starting PostgreSQL...How to reset MySQL root password ?
What happens if you forget your MySQL root password? No worries, the below steps will help you to reset mysql root...How to Mass Delete Pending Comments in WordPress?
Question: I have around 5,000 pending comments in my WordPress and most of those are spams. I would like to know...