Change Mysql password.

  We all have worked in Mysql with the default username ‘root’ and password ‘root’ but we should not keep our Mysql password to default as its insecure. I am here with a blog which helps you change the password of Mysql with minimal steps...

Power of Liquibase

Hi Guys! I am back with a new blog post titled “Power of Liquibase”. This post is meant for those who have a basic idea of using Liquibase. As we know that Liquibase is used to keep a track of the changes that we apply to the database. It not only keeps a...

Liquibase Basics

Liquibase is an open source technology for tracking, managing and applying database schema changes. All changes to the database are stored in XML files in the form of change-sets and is identified by a combination of an “id” and “author” tag....

Create-A-New-User-In-MySQL

In general, We did all of the editing in MySQL as the root user, with full access to all of the databases. However, in the cases where more restrictions may be required, there are ways to create users with custom permissions. Let’s start by making a new user within...

Transaction isolation levels in database

I was recently studying about transaction isolation levels in database. First of all, let us see the definition of transaction isolation level. Definition: Every transaction specify an isolation level that defines the level at which one transaction must be isolated...

Configure MYSQL as case insensitive on Linux

Few months back I was working on a task in which I had to construct few SQL queries to fetch specific data and display on the GSP pages. I fired few queries(table names were given in lower case) but it failed. It showed an error that there is no such table with the...