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...
Databases
Articles on issues in Databases
-
-
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... -
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...