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
Articles on issues in 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... -
Secure_file_priv option in MySQL – Modify/Disable
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...