MariaDB
How to Create, List or Drop Indexes on MySQL Table
Indexes are very useful to improve search queries on database tables. For example you are searching for particular record in…
Category: Databases
MySQL
How to Install PHP 7, NGINX, MySQL on CentOS/RHEL 7.6 & 6.10
A few days back PHP version 7.2 has been released. Which has a number of changes and improvements over PHP…
Nginx
How to Install Nginx, PHP 7 & MySQL on Ubuntu 16.04, 14.04
The latest major release of PHP version 7.2 has been released with the number of speed optimizations and security. So…
MySQL
How to Connect Node.js with MySQL
Node.js is a popular server-side JavaScript platform used to build scalable and high-performance applications. MySQL is a popular open-source relational…
PostgreSQL
How to Install PostgreSQL on Ubuntu 18.04 & 16.04 LTS
The PostgreSQL Development Team has announced the latest version PostgreSQL 12. PostgreSQL is an open-source object-relational database system. It is…
MongoDB
How to Install MongoDB 4.4 on Ubuntu 18.04 & 16.04 via PPA
MongoDB is a full flexible index support and rich queries database. Mongodb is a NoSQL database. MongoDB provides large media…
Databases
How to Install MongoDB on CentOS/RHEL 7
MongoDB (named from “huMONGOus“) is a full flexible index support and rich queries database. Its is a NoSQL database. MongoDB…
Apache
How to Install PHP 7.2, Apache 2.4, MySQL 5.6 on CentOS/RHEL 7.5 & 6.9
The PHP team has released upgrade version 7.2. Which has a number of changes and improvements than over version 5.X.…
MariaDB
How to Temporarily Disable Foreign Key Checks in MySQL
You must have faced the foreign key constrains issues many times while working with MySQL database. Generally this issue occurred…
MySQL
How to Install MySQL 5.7 on Ubuntu 16.04 LTS
MySQL is an open-source relational database management system. This tutorial will help you to install MySQL server on your Ubuntu…