Database Archive

15 Apr 2019

How to Install Oracle Database 12c Release 2 in Linux 7

Oracle Database is an object-relational database management system (RDBMS) developed by Oracle Corporation. The Oracle Database 12c is a high-performance, enterprise-class database. Oracle Database is the most popular, trusted database systems. Oracle Database support multiple operating systems
12 Apr 2019

Install MySQL Password Validation Plugin on Linux

When thinking about security within a MySQL installation is protecting MySQL data. MySQL provides many tools and plugins in order to protect your data. Now MySQL version 5.6.4 comes with a new security plugin called Password Validation
18 Mar 2019

How to Change MySQL Password Policy Level on Linux

MySQL version 5.6.6 comes with a new security plugin called Password Validation Plugin. The validate_password plugin test password strength and improve security. Sometimes while changing the password you got the error “ERROR 1819 (HY000): Your password does
11 Jul 2017

For “Too Many Connections” Error in MySQL

Some times on your server in MySQL there is too many connections issue occurs. To resolve this issue you need to increase the value of max_connections. In this article we will help you how to update max_connections
30 Jun 2017

How to Install MongoDB 3.4 on Ubuntu 16.04/14.04

MongoDB is a NoSQL database that offers a high performance, high availability, and automatic scaling enterprise database. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as
5 Oct 2015

Adminer Tool for CentOS/RHEL & Ubuntu/Debian

Adminer tool is a full-featured database management tool written in PHP. It consist of a single PHP file which is ready to deploy on the target server. Adminer supports MySQL, PostgreSQL, SQLite, SQL Server, and Oracle, and
18 Sep 2015

How to Resize MySQL InnoDB logs file in CentOS/RHEL

Log files are important disk-based resources which is managed by the InnoDB storage engine. MySQL creates two log files named ib_logfile0 and ib_logfile1 in the MySQL data directory. We define the size of log file in innodb_log_file_size
9 Aug 2015

How to configure Master-Slave MySQL Replication on CentOS/RHEL 5/6/7

MySQL replication is a procedure that permits you to easily keep up multiple copies of a MySQL data by having them replicated consequently from an master to a slave database. This can helpful for some reasons including
22 May 2015

How to Install and configure MySQL 5.6 on CentOS

Oracle today declared the general accessibility of MySQL 5.6, the world’s most prevalent open-source database. Optimizer enhancements for all-around query execution. InnoDB enhancements for higher value-based throughput. New NoSQL-style memcached APIs. Partitioning changes for questioning and overseeing
24 Apr 2015

Mysql Commands for CentOS/RHEL

MySQL is a uninhibitedly accessible open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most prevalent dialect for including, getting to and overseeing substance in a database. It is most