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...
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 Store the output of SHOW PROCESSLIST into a file in MySQL? Question: I have used SPOOL command in Oracle SQL for storing query results into a file and when all is done, spool...
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...
[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...
Failed to open stream: Permission denied [Apache] Moved my local development files to the server after setting up Apache, PHP, and MySQL on my CentOS 7. When...
WSO2 Cannot remove API as active subscriptions exists [Solution] Trying to delete an API from WSO2 API Manager and end up seeing this error – Cannot remove API as...
How to Install/Update PHP to 7.4 on CentOS 7 Recently while looking onto my client’s WordPress dashboard, found a notification that the PHP version might be vulnerable and needs...
Installing WSO2 API Manager on CentOS WSO2 API Manager is an Open Source-based API Gateway that allows the development teams to deploy and monitor APIs and...
phpize configure error: cannot find sources (config.m4) Question: Trying to install one of the PHP extension from the source. I ran phpize command and encountered the error...
502 Bad Gateway Error NGINX [Solution] How do you feel when your client WhatsApps a screenshot of his website that says 502 bad gateway NGINX error? Nothing...
Run multiple versions of PHP for different domains in NGNIX I recently purchased EduExpression WordPress plugin for a client to setup an examination software. I was able to install and...
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...