Databases

Articles on issues in Databases

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...
How to Reset MediaWiki’s User account Password using SQL query?

There are few ways through which you can reset the user account’s password in MediaWiki. The first method is by...
Why increasing ‘max_connections’ in MySQL is just not enough to fix “Too many connections” Error

For the past few days, I started to see this error “Too many connections” in the error log. Generally, the...
Did you run ‘mysql_secure_installation’ after Installing MySQL? It helps Secure MySQL

The MySQL database package comes with an automated secure installation script called “mysql_secure_installation”. It’s advised to run this script soon...
It all takes One Click to Optimize your WordPress Database!

I have been using WordPress for quite sometime, but I had never thought of optimizing the database. The reason, it seemed bit...
[MySQL Error] : ‘/usr/share/mysql/english/errmsg.sys’ had only 480 error messages

My CentOS box runs with kernel 2.6. Today, I wanted to upgrade it to the recent version 3.14. Also, few important security...
Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

While setting up wordpress 3.8, accessing through web browser, i ran into the following error: Your PHP installation appears to...
10 Effective Mysqldump command Examples for your Reference

MySQL is one of the most widely used Database system, that comes with tons of effective command line utilities. For...