DATABASES

How To Reset MySql Root User Password

How To Reset MySql Root User Password

How To Reset MySql Root User Password/Recover MySql Root User Password Hello Guys Today I will share with you one line command which you can use in two case: 1) When you forgotten MySql root user password. 2) To reset  MySql root…

MySql Master To Master Replication Installation On Linux

MySql Master To Master Replication Installation On Linux

Master To Master Replication installation & configuration. In master to Master replication we need two MySql nodes and both will be master and slave to each other. Both nodes will perform read/write operation. Master to master replications provides high availability…

MySql Replication On LINUX

MySql Replication On LINUX

What is MySql Replication? Replication is a basic feature of MySQL server. Its allow us to create replica of any database from one Mysql node to other MySql node or multiple MySql nodes.   Why we need Replications? In order…

MYSQL-ODBC Connectivity on CentOS/RHEL/Debian/Ubuntu

MYSQL-ODBC Connectivity on CentOS/RHEL/Debian/Ubuntu

What is ODBC ?? ODBC  stands for “Open Database Connectivity”. It  is a standard middleware API written in C-Programming Language for accessing DBMS i.e Database Management System. It uses an ODBC driver as a translation layer among the Application &…

MYSQL Administration Commands

MYSQL Administration Commands

Some Useful MYSQL Commands DATABASE CREATION In order to Create a Database,  run below Command: mysql> create database databasename; DATABASE LISTING In order to list all the databases on the mysql server, run below Command: mysql> show databases; DATABASE DELETION…